[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
re: [sqr-users] Name
- Subject: re: [sqr-users] Name
- From: harriaj@NU.COM
- Date: Tue, 30 Nov 2004 12:21:51 -0500
- Delivery-date: Tue, 30 Nov 2004 12:22:54 -0500
- In-reply-to: <20041130170232.45886.qmail@web80502.mail.yahoo.com>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
> I need some help in getting lastname and middle name from the
> following string which i get through a flat file. Some names have
> middle name at the end and some don't(like M and R). I want to
> get the last name and first name and give a warning message
> when there is a middle name.
>
> Beach,Linda
> Ward,Joan
> Williams,Robert M
> kim,mellisa R
This solution assumes there is no space except between a first name
and middle name.
unstring $FullName by ',' into $LastName $FirstAndMiddleName
unstring $FirstAndMiddleName by ' ' into $FirstName $MiddleName
if $MiddleName <> ''
! warning
end-if
Andrew :)
**********************************************************************
This e-mail, including any files or attachments transmitted with it, is
confidential and intended for a specific purpose and for use only by the
individual or entity to whom it is addressed. Any disclosure, copying or
distribution of this e-mail or the taking of any action based on its contents,
other than for its intended purpose, is strictly prohibited. If you have
received this e-mail in error, please notify the sender immediately and delete
it from your system. Any views or opinions expressed in this e-mail are not
necessarily those of Northeast Utilities, its subsidiaries and affiliates (NU).
E-mail transmission cannot be guaranteed to be error-free or secure or free
from viruses, and NU disclaims all liability for any resulting damage, errors,
or omissions.
**********************************************************************
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users