This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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:
Hard to understand without seeing an actual example of what you're talking about, but it sounds to me like you can filter on that 2nd field (using a substring formula) equaling 1 or not. And then have the T node of the filter tool going to one Dynamic Input tool, and the F node going to another Dynamic Input tool (both of which will have their respective flat file configs).