Tony, Thx. That was the command I was looking for.
Jan -----Original Message----- From: "Tony IJntema" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 25 Jun 2015 22:27:32 +0200 Subject: [RBASE-L] - RE: Last postion Try (SLOCP(TextNoteVarcharValue,string,occurrence)) Locates the exact position of a given string and occurrence in a TEXT, NOTE or VARCHAR value, returning the position if the string is found, 0 if it is not found. Using -1 as the third parameter will return the LAST occurrence. Then perform something like sget Tony From:[email protected] [mailto:[email protected]] On Behalf Ofjan johansen Sent: donderdag 25 juni 2015 22:23 To: RBASE-L Mailing List Subject: [RBASE-L] - Last postion Group, I need to run a cursor to get a comma separated list of emails. My solution ends up with a comma in the last position of the TEXT string. How would you trim the last comma off? Jan
