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, You could try inputting using CSV and then changing the delimiter from a comma to \0. This will read each row of your txt file into a single column (so you might also want to make the field length really long). Once you have the file in Alteryx, you can use a variety of functions to figure out how to "fix" the input file. A few that have proven useful to me: REGEX_CountMatches -- to count the number of expected delimiters to see if each row has the same number REGEX_Replace/REPLACE/REPLACECHAR -- to fix identified cases of 'bad' delimiters Once you've made your fixes, you can either use the Text To Columns parsing tool to split your fields apart or you can save the single modified field to CSV, once again setting the delimiter to \0. Then input it with a standard input tool. Good Luck!