Hello, I have a CSV file that every value is separated by quotes but alteryx is reading the file weird and recognizing it all as one field. See the snippet attached.
i cannot provide sample data.
thank you very much in advance!
Solved! Go to Solution.
CSV file data comes in one column only,
you have use regex expression to separate the data
try this regex formula REGEX_Replace([Field_1], "\s{2,}","|")
it will add | for every 2 spaces and you can use text to columns
Your example image doesn't seem to have a delimiter specified.
If the data is split by quotes, set that as your delimiter and it should split it for you.
Sorry, forgot a bit. Scroll down in the file input and change the ignore delimiters in quotes to be single quotes or auto and give that a shot.
We must be missing something here. I know you said you cant provide sample data, but can you upload a sample file with just the headers? A screenshot of the first few lines of data from notepad or notepad++ or a mock file with a few lines of fake data?
As a check, if you import the file using \0 to use no delimiter, indicate that the first row contains data, and a formula tool to count the number of quotes REGEX_CountMatches([header],'"') does every line have the same number of quotes or are there extras in some lines?