substring usage

Posted by Admin on 16-Mar-2005 07:27

I have a field with data like (whm,lkh,jpm,ypm,lpm) length not predictable but would like to get hold of the last text in this case lpm

All Replies

Posted by Matt Baker on 16-Mar-2005 21:45

Try using:

define variable i as integer no-undo.

define variable lastentry as character no-undo.

i = num-entries(datastring, ",").

lastentry = entry(i,datastring).

Of course this will only work if your string of data is delimited by some value. Such as a comma in this example.

This thread is closed