Hi, I'm looking for a solution for this problem. I've got a .txt file where the first 3 fields are all the same length (9 characters,1 character, 9 characters), if the second field is equal to 1 then I should use a .flat file to map the field otherwise I should use another .flat file. I was wondering if using a filter tool on 2nd field and then apply a regex to map the field could be a solution to my problem. The file does not contain punctuation only letters, numbers and space:
00001CA LNP11850F00000000000000000000000030400 00000000000 TJGJIEE EGEGES 5P11I850F00000000000
Many thanks!