i have a problem reading a csv, in fact, a column contains an amount with a comma(like the separator). The encoding is UTF-16, otherwise the data is correct, how can i retrieve this values with the comma?
could you please share a file? I assume that it’s taking too much separate columns because of additional commas?
Hi @sokon73234 ,
Could you try using Tab as a delimiter and see if that works out for you?
We can manipulate the two columns that you get in the end and convert them into one column. (If all numbers inside this column contain a comma)