Test_File.txt (4.2 KB)
I am having the attached text file which has contents of tabular information, PFA.
Now, I have the fields separated by | (pipes), and I want to conclude one line to be with respect to some ending regex match.
Something …|0535E000|Interco Bureau Europe|000000|100700914268|30-APR-19|I/C-BUREAU ITALY|1050.33|XC-B ITALY frm
No matter how many lines are there,all I know is that last charecters are to be |000
I am having the for loop to iterate through the attached text file and I was able to split with respect to new line, but problem is that some fields are moving down to next line so I have to use some end line regex to assume that the one liners are accurate.
I dont know how to use regex. All I need is to find the regex (|000) in the end , and till that I not comming, I need to keep iterating and appending the data into the single row.
Please help, it is urgent.
Thanks and Regards,