[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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

Subbu,
       Hope your problem wouldn't have seen today.

       But then, I wonder why you are not taking the NAME_SUFFIX value from the 
same table.
       Your problem will be significant if you are reading Suffix from an 
Inbound file.
 
       Enjoy coding SQR...

With Best Regards,
Murty MVS
Software Developer
+9144-28241970 Ext:233
(For Client Sun Trust)







-----Original Message-----
From: Knapp, Richard [mailto:KnappR@umsystem.edu]
Sent: Monday, September 13, 2004 11:59 PM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] How to extract the suffix from name



I would put all the valid suffixes in an array and do an
instr(the_full_name,element(#),1) for each of them for each name you
need to process.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu
 

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.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