Join this group to access featured content and participate in discussions related to all Syncsort Mainframe Products.
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 separate ENDBEFR. I am thinking I have to use a combination of ENDBEFR and ENDAT but have not figured out the correct logic.
firstname.lastname@example.org|John Doe|123 Maple St....
"email@example.com"|"John Doe"|"123 Maple St"....
Here is my current SYSIN I am using.