Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Strings
- Thread starter Geo45
- Start date
hi,
Here is some functions for string manipulation:
LEFT(<string>, <nb char>) : Return the first <nb char> of <string> from the left
Ex:
left("Hello",2) Will give He
RIGHT(<string>, <nb char>) : Return the first <nb char> of <string> from the right
Ex:
left("Hello",3) Will give llo
MID(<string>, <start>, <end>): Return part of <string>
Ex:
Mid("Hello", 2, 3) will give ell
Mid("Hello", 3, 1) will give l
Mid("Hello", 2) will give ello
INSRT (<start>, <string1>, <string2>) : Retrun the starting position of <string2> if its found in <string1>
Ex:
Instr(1, "Hello", "e"
will give 2
Instr(1, "Hello", "l" will give 3
Instr(4, "Hello", "l" will give 4
Hope it can help!
Mal'chik![[bigglasses]](/data/assets/smilies/bigglasses.gif "[bigglasses] [bigglasses]")
Here is some functions for string manipulation:
LEFT(<string>, <nb char>) : Return the first <nb char> of <string> from the left
Ex:
left("Hello",2) Will give He
RIGHT(<string>, <nb char>) : Return the first <nb char> of <string> from the right
Ex:
left("Hello",3) Will give llo
MID(<string>, <start>, <end>): Return part of <string>
Ex:
Mid("Hello", 2, 3) will give ell
Mid("Hello", 3, 1) will give l
Mid("Hello", 2) will give ello
INSRT (<start>, <string1>, <string2>) : Retrun the starting position of <string2> if its found in <string1>
Ex:
Instr(1, "Hello", "e"
will give 2Instr(1, "Hello", "l"
will give 3Instr(4, "Hello", "l"
will give 4Hope it can help!
Mal'chik
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question