Phil,
Wouldn't R:BASE's SSUB do the job for you?
SET VAR x = 'Salisbury, Scott'
SET VAR y = (SSUB(.x,1))
The value of "y" is "Salisbury" now.
Had I used (SSUB(.x,2)) the value of "y" would
have been "Scott".
Scott
====
"Phil Nolette (NCS Group, Inc.)" wrote:
> 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]
>
> ------------------------------------------------------------------------
> Name: winmail.dat
> winmail.dat Type: application/ms-tnef
> Encoding: base64
--
Scott
====
Scott J. Salisbury
Matrix Data Systems / The R:Street Journal
5114 Point Fosdick Drive NW, Suite E-272
Gig Harbor, WA 98335-1733
E-Mail Address: [EMAIL PROTECTED]
Temporary URL: www.seanet.com/~sjs (downloads available)
New Web Address: www.rStreetJournal.Com
Direct Line: 206-423-7679
Toll Free: 888-386-5040
Seattle: 206-448-7975
Fax: 305-425-0491
