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

Re: substr

Thanks to all for the help.  The attached did the trick.

Bob H

-----Original Message-----
From: Kenny Melton (CORP)

Robert, try this:

$SOURCE_STRING = 'Robert J Hallmark'

UNSTRING $SOURCE_STRING BY ' ' INTO $FIRST_NAME $MIDDLE_INIT $LAST_NAME

LET $NEW_STRING = SUBSTR($FIRST_NAME, 1, 1) || $MIDDLE_INIT || ' ' ||
$LAST_NAME

$NEW_STRING = 'RJ Hallmark'

HTH,
Kenny

-----Original Message-----
From: Hallmark, Robert J [mailto:robert.j.hallmark@LMCO.COM]
Sent: Tuesday, November 20, 2001 9:39 AM
To: SQR-USERS@list.iex.net
Subject: substr


Can anyone tell me how to extract the first initial, second intitial and
last name as follows. I believe I would use the subsrt function, but I am
not sure how to make it apply in this case.



This is what is in Database                     This is what I need to print
in the report

Robert J Hallmark                               RJ Hallmark
Byron B Douglass                                BB Douglass
Michael R Greenfeder                            MR Greenfeder

Thanks


Bob H