dgokulakrishnan
New User
Joined: 01 Jun 2011 Posts: 5 Location: Chennai
|
|
|
|
Dear All,
I have a PS file which a have a list of customer's e-mail address. Now, the requirement is need to identify the statistics of E-mail Service provider
Ex: mail-address @ Service Provider
Sample file:-
=============
aaaaaaa@yahoo.co.in
bbbbbbbb@gmail.com
cccccc@hotmail.com
dddd@facebook.com
eeeeeeee@hotmail.com
ffff@yahoo.co.in
Expected Output:-
=============
yahoo.co.in 2
gmail.com 1
hotmail.com 2
facebook.com 1
Is it possible to do the above task in a single step? |
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
You can use a DFSORT job like the following to do what you asked for:
Code: |
//S1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD *
aaaaaaa@yahoo.co.in
bbbbbbbb@gmail.com
cccccc@hotmail.com
dddd@facebook.com
eeeeeeee@hotmail.com
ffff@yahoo.co.in
/*
//SORTOUT DD SYSOUT=*
//SYSIN DD *
INREC PARSE=(%01=(STARTAFT=C'@',FIXLEN=25)),BUILD=(%01)
SORT FIELDS=(1,25,CH,A)
OUTFIL REMOVECC,NODETAIL,
BUILD=(80X),
SECTIONS=(1,25,
TRAILER3=(1,25,X,COUNT=(M10,LENGTH=8)))
/*
|
SORTOUT would have:
Code: |
facebook.com 1
gmail.com 1
hotmail.com 2
yahoo.co.in 2
|
|
|