Hi bro @bcorrea, I have seen many of your answers which are really good and helpful. Could you please help me. I have to write the unstructured data from a txt file to excel file. here Im sharing the image of the unstructured data in txt file.
and there are few conditions which has to be followed
- Ignore any line numbers that starts with ZERO ‘0’
- Read line which starts with ‘2’. If the next character is not ‘U’, Reject the message
- Read each line which starts with ‘3’ which will have flight numbers.
- Stop when line number starts with ‘5’