Hi community,
I have a text file that every value is separated by double quotes, as an example the data set is like "A" "B" "C". Is there a way to use the input tool and define a delimiter or should I do it another way?
Thanks a lot!
Hi @binnursev
Can you provide a sample file?
hi @binnursev
is your data is such that every data value is enclosed in double quotes and then each of them separated by space/tab, I suggest that you:
- first, use the Text to Column Tool (https://help.alteryx.com/20213/designer/text-columns-tool) to separate the data fields using the \s as delimiter;
- secondly use either StripQuotes or Trim function (https://help.alteryx.com/20213/designer/string-functions) to remove the double quotes from the data.
Dawn.
It is common for csv files to have double quotes around field values.
The input data tool will remove the quotes if you pick a space as the delimiter.
Example attached.
Hi David,
Thank you for your response. I tried it but I get an error that "A field was missing a closing quote" while all are fine. Also the whole dataset is coming as one field name and one data field when I do the configuration as you sent. I can't use the text to columns because some part of the data is lost if I don't use a proper Input configuration.
Do you think there is another way?
Thank you again!
Best
Could you attach a small sample data file?
Hi Everyone, I am running into the same issue where Alteryx is not reading the CSV file. I am unable to provide a sample file data but does anyone have any suggeestion?
