Jan
Here is what I've done in the past. You may have to adjust the sget and sloc
depending on how the names are set.
Buddy
***********Code Starts Here***************
CLE ALL VAR
SET VAR VFullName = ('Doe, John E.')
SET VAR VLastNameEnds = (SLOC(.VFullName,','))
SET VAR VLastName = (SGET(.VFullName,((SLOC(.VFullName,','))-1),1))
SET VAR VFirstMid = (SGET(.VFullName,45,((SLOC(.VFullName,','))+2)))
SET VAR VFirstName = (SGET(.VFirstMid,((SLOC(.VFirstMid,' '))-1),1))
SET VAR VMiddle = (SGET(.VFirstMid,45,((SLOC(.VFirstMid,' '))+1)))
CLE ALL VAR EXCEPT VLastName,VFirstName,VMiddle
SHO VAR
***********Code Ends Here***************
-----Original Message-----
From: Jan Johansen [mailto:[EMAIL PROTECTED]
Sent: Wed 10/13/2004 1:57 PM
To: RBG7-L Mailing List
Cc:
Subject: [RBG7-L] - First & Last name
I've searched through my email posts. I thought someone had submitted a nice
snippet of code that
bascically took a single name column and was able to split it into two or
three seperate columns with first, middle, and last names.
Maybe it was a dream. Can't seem to get my head around a bunch of STRIM's
and IFEQ's.
Jan
<<winmail.dat>>
