click below
click below
Normal Size Small Size show me how
F452 Computing
12 String Manipulation
Term | Definition |
---|---|
Concatenation | Joining two strings together, e.g. with & |
Length | Find how many characters in a string, e.g. Num = LENGTH(Name) |
Search | Find the position of one string within another, e.g. Pos = Name.INDEXOF(“Jones”) |
Substring | Extract part of a string, e.g. Firstname = Name.SUBSTRING(0, 8) |
LEFT / RIGHT / MID | LEFT(stringName, 7) extract the first 7 characters / RIGHT(stringName, 7) extract the last 7 characters / MID(stringName, 5, 4) extract 4 characters starting at the 5th character. |