If I understand you want to go from Jones, john to select only Jones, the
last name.
You can use SLOC to find the comma, it returns the position and then SGET to
extract the partial name.
set var vposition = (sloc(.fullname, ',')) --- this will return the
position of the comma
set var numberofchar = (.vposition -1)
vposition is where the comma is, so the name stops 1 prior, is
numberofchar long
set var vlastname = (sget (.fullname, .numberofchar, .vposition))
will return a text name of the correct number of characters long starting
from vposition.
Depending on your data you may need to adjust for spaces, and watch our for
JR, SR etc.
Both are in the documents and help file and are easy to use
Mark Lindner
Lindner & Associates
[EMAIL PROTECTED]
(781) 449- 8824 Fax (781) 449 3042
800 982 7757
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, September 15, 2001 6:22 PM
> To: Rbase-L
> Subject: Weekend Conversion Code - Help
>
> Greetings,
> I am working this weekend on writing an application to do some conversion
> of data from three systems into one.
> I need some help with something that I know someone can spout it off from
> the top of their head.
> I have done matching of records based upon several conditions and things
> are working well. I am at the point now where I have a record from a
> system source (Cursor C1) and the criteria for Cursor C2 matches or they
> have 5-10 records. I would like to use the last name which is in the full
> name as criteria for matching. I just want to use from the comma
> backwards in C2 (last name, first name) and compare that to the same in
> C1. Can someone tell me the function code to insert into my RMD file?
>
> I would certainly appreciate it.
>
> Phil Nolette
> [EMAIL PROTECTED]
winmail.dat
