Josh Verne replied to Josh Verne's discussion Parse and dedupe in Mainframe
"I think I figured it out.  Was to caught up i thinking I had to use ENDBEFR and ENDAT

INREC PARSE=(%1=(ENDBEFR=C'|',FIXLEN=100)),       BUILD=(01:%1,SQZ=(SHIFT=LEFT,PREBLANK=C'"'))SORT FIELDS=(1,100,CH,A)   DUPKEYS FIRSTDUP,NODUPS,XDUP"
Feb 16
Josh Verne posted a discussion in Mainframe
I receive a delimited file from a client that I parse the first field which is an email address and then I dedupe the file.  My problem is that some of the data they are sending me is quote surrounded.  I am not sure how I can parse the file on two…
Feb 16
Josh Verne is now a member of Mainframe
Nov 23, 2016
Josh Verne is now a member of Syncsort Community
Nov 23, 2016