Page 1 of 1

String extraction

Posted: Mon Jun 01, 2009 4:54 am
by senthilmp
Hi,

I dont want to extract the last four characters of the string. But the no of characters in the string is not know. Can you let me know what function should i use to achieve this?

For Eg: in the following string:
FY200901041233501234 - the last 4 character i.e 1234 shoud be eliminated and the result should be FY20090104123350

Thanks in Advance.
Senthil MP

Posted: Mon Jun 01, 2009 6:10 am
by chulett

Code: Select all

YourField[4]

Posted: Mon Jun 01, 2009 6:12 am
by chulett
Sorry, don't want. :oops:

Code: Select all

YourField[1,Len(YourField)-4]

Posted: Mon Jun 01, 2009 6:23 am
by senthilmp
Thanks