Using Field function to get final delimeter of a string

[chulett]

If that really works for you (I didn't check it) there's no need for a routine. You can inline all that and save all those intermediate variables:

Code: Select all

left(mystring[index(mystring,' ',dcount(mystring,' ')-1)+1,30],3)

[vivek]

Chulette,
The reason I went for a subroutine is to specify an exception, such as how to handle the string if the delimeter(the double space) is not found.
we are replacing the result with '00' for now.

even though that's not the present situation may be in future we may get data with out this delimeter.that's why i have opted for a routine.

once agian thanks for your followup with the request.