This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 61%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi We have a sample data coming in a csv file as in the attached picture'.
Because comma and double quotes are there in same text its failing to import it.
Please see in attached pic for the settings i followed but still it failed.
'Plaese let me know if anything to be changed.
Hi @AP ,
Would you please provide some sample data from the csv file. Thanks.
HI @Nasreen Akter Please see attached. (Modified few columns for data security reasons)
Hi @Nasreen Akter , I am sorry using tab is changing the data format. I would need to read it as columns and rows with headers.
Hi @AP , would you please tell us what is the expected output from the test-file.txt file? What is the delimiter you used while creating this file? Thanks!
Hi, I just fixed it the isuse, Using " as escape character as well as Quote chanracter fixed the issue. Outcome i needed is simply not having to fail and keep the text as is.
Hi, I just fixed it the issue, Using " as escape character as well as Quote character fixed the issue. Outcome i needed is simply not having to fail and keep the text as is.
Hi @AP ,
Would you please use Tab as a column delimiter instead of Comma and try again. Hope this will help. Thanks
--please mark the answer as accepted if was helpful. Thanks--