String extraction

senthilmp · Post by **senthilmp** » Mon Jun 01, 2009 4:54 am

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

chulett · Post by **chulett** » Mon Jun 01, 2009 6:10 am

Code: Select all

YourField[4]

chulett · Post by **chulett** » Mon Jun 01, 2009 6:12 am

Sorry, don't want.

Code: Select all

YourField[1,Len(YourField)-4]

senthilmp · Post by **senthilmp** » Mon Jun 01, 2009 6:23 am

Thanks