Skip to main content
Question

ImportCSV

  • February 20, 2025
  • 0 replies
  • 71 views
Forum|alt.badge.img+1

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|alt.badge.img+2
  • SouheilKaram1
  • Quickbase Alumni
  • February 22, 2025

try to have " around your text wit commas or change the csv delimiter in the api.

Forum|alt.badge.img+11

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')

Terms & ConditionsAccessibility statement