Page 2 of 2
Posted: Tue Aug 08, 2006 1:12 pm
by 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)
Posted: Tue Aug 08, 2006 6:58 pm
by 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.