IBM Mainframe Forum

Posted: **Wed Aug 22, 2007 5:27 pm**

Hi I am creating a report using SORT.

Here I am stuck with one problem.
The name is FULL NAME in
FIRSTNAME$LASTNAME format
e.g.
FULL NAME is : JIMI$ADAMS
here First NAME is JIMI and LAST NAME is ADAMS.

I have to populate FIRSTNAME and LASTNAME seperately.

How can FULL name be splitted in Last name and first name?

Posted: **Wed Aug 22, 2007 9:20 pm**

You can use DFSORT's PARSE function to do that. For example:

Select all

//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD *
JIMI$ADAMS
FRANK$YAEGER
MICKEY$MOUSE
CHARLOTTE$SPIDER
//SORTOUT DD SYSOUT=*
//SYSIN DD *
OPTION COPY
INREC PARSE=(%01=(ENDBEFR=C'$',FIXLEN=10),
%02=(ENDBEFR=C' ',FIXLEN=10)),
BUILD=(%01,X,%02)

SORTOUT would have:

Select all

JIMI ADAMS
FRANK YAEGER
MICKEY MOUSE
CHARLOTTE SPIDER

For more information on DFSORT's PARSE function, see:

http://www.ibm.com/servers/storage/supp ... /mvs/peug/

Posted: **Thu Aug 23, 2007 10:07 am**

Yes,this will do..Thanks Frank !

Posted: **Thu Aug 23, 2007 9:02 pm**

Glad I could help.

IBM Mainframe Forum

How to split strinf using DFSORT ?

How to split strinf using DFSORT ?

Re: How to split strinf using DFSORT ?

Re: How to split strinf using DFSORT ?

Re: How to split strinf using DFSORT ?