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