on 2007 Dec 21 4:08 AM
Halo:)
I try to get last char using substring formula, but i cant.
example:
Field_001 = ABCDEFGH
Field_002 = IJKLMN
The result that I want is grep 3 last character (FGH) and (LMN).
Would you help me how..
I try to combine with
substring(Field_002,0,-3)
substring(Field_002,-3,0)
substring(Field_002,0,3)
substring(Field_002,3,0)
substring(Field_002,-3)
substring(Field_002,3)
and i try to use sentence too, like :
Sentence(Field_002,3)
But cant work. Would you help me?
Thanks
Edited by: dony donse on Dec 21, 2007 5:08 AM
Edited by: dony donse on Dec 21, 2007 5:15 AM
Dony,
You will use the Substring function with 2 parameters.
Example Substring(,)
For your example you will use
example:
Field_001 = ABCDEFGH
Field_002 = IJKLMN
Substring(Field_001,5) for Field_101
Substring(Field_002,3) for Field_102
The charecter count starts from 0....A would be 0, B would be 1
Suda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
103 | |
10 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.