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?
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.