RE: [sqr-users] How to extract the suffix from name

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

This is harder than it looks (speaking from experience).  First, the format
should be "lastname suffix,firstname" as you say, but many Peoplesoft sites
find that the users have been inconsistant.  Also, we cannot assume that the
suffix is whatever appears after the first space and before the comma.  Some
lastnames have spaces, and some data entry has an extra comma.  Fortunately,
PS_PERSONAL_DATA also has fields for first name and last name separately.
You can hope that those fields are spelled the same as the firstname and
lastname in the name field.  Use those fields to strip away as much as you
can from the name field, then search it for your suffixes.  Search for
longer values first.  If you have a "III" or a "I I", you don't want to just
pick up an "I".  Also be prepared for mixed case; "Iii".

-----Original Message-----
From: Raj Srinivasan [mailto:raj.srinivasan@hccs.edu]
Sent: Monday, September 13, 2004 9:30 AM
To: This list is for discussion about the SQR database reportinglanguage
fr omHyperion Solutions.
Subject: RE: [sqr-users] How to extract the suffix from name


Hi Subbu,

Use the Unstring to parse out the required suffix.

Thanks,

Raj

-----Original Message-----
From: sqr-users-bounces+raj.srinivasan=hccs.edu@sqrug.org
[mailto:sqr-users-bounces+raj.srinivasan=hccs.edu@sqrug.org]On Behalf Of
subrahmanyam Uppuganti
Sent: Monday, September 13, 2004 11:23 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] How to extract the suffix from name


All,
Iam trying to write a fixed length flat file and have a field suffix to be
populated in the file,
The source for this suffix is the Personal_Data.Name (The Name is stored in
this format,
lastname sufix,firstname)...What i need to get is suffix.The valid values
for the suffix are
'I I','I I I','I V','II','III','IV','Jr','Jr.','JR','Ms.','Sr','Sr.'
I would appreciate if some one can tell me how to extract this suffix from
the name field.
Thanks in advance,
Subbu



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users