ImportCSV
Hi Folks,
Importing data using python from XYZ Database.
Some columns contains values with ,(commas).
While importing using importfromcsv string is split up and data is then incorrectly mapped.
Any guidance?
Forum Discussion
3 Replies
try to have " around your text wit commas or change the csv delimiter in the api.
Tried having "" around the text it has solved the comma issue but some strings have " in the string which are now getting clipped.
Example Description : Rod OD 3.5"
AS suggested , you can use Python to give output with
QuoteALL , which change data from .2025-12-23,Hello,my friend,hope you are fine
"2025-12-23","Hello,my friend,hope you are fine"
You will not need to change your delimiter .
df.to_csv('output.csv', index=False, quoting=csv.QUOTE_ALL, encoding='utf-8')
