Thanks for the quick reply from both you and Bill. Very much appreciated.
Phil Nolette
[EMAIL PROTECTED]
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, September 15, 2001 6:52 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Weekend Conversion Code - Help
>
> 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
