I have a use case where I have read below file and extract certain tag values and create a new output file
Example: Basically the file beings with a header then data and ends with footer. The columns tags are separated by a ":". My requirement is to extract the TAG 86 (:86) from each record and extract only values for the keyword "ACC_NUM". Each record is separated by "-"
:86:/PT/PY/BROKER: 6805 MERILY
:86:/PT/PY/ACH CREDIT RECEIVED /CO CALAMOS
My expected output:
note: ACC_NUM is a non mandatory field
Solved! Go to Solution.
Please provide more details regarding requirement.
as you mentioned, columns are separated by ":", the data you provided is like below or each tag you will get in different line?
:MT:HGT:CI:CASH:ND::20:01876529:61:30986,28NF5678//21812367 1:86:/BROKER:MERILYEN/PO/1112/BNT/789647/ACC_NUM/89543209865/USNML/9762:61:15678,50NMS89//21830877 1:86:/PT/PY/BROKER: 6805 MERILYIDD_CLEARING/PO/1112/ACC_NUM/018765432975678/USNML/9388115278
Are you looking for following output?
Here i assumed that for every account number there will be "USNML" entry.
Thanks Veeru..yes that is the expected result I was looking for.
What is the file input delimiter and record separator you used to build the below program?