DeepTalk

How to ensure correct handling of commas in text

Sometimes it seems that text is lost when uploading a file to our platform. We help you to avoid a specific issue with single-column files

We have noticed that sometimes there are import problems with .csv files that contain only one column and the text itself contains commas.

For example, here is a file that fulfills these two conditions:

When we upload this file to the platform, we see that the text has not been detected correctly:

This is because the comma of the text is interpreted as a column separator from the .csv file (reminder: .csv stands for "comma-separated values").

As a workaround, we can add a dummy column to our file and fill it with any value.

When saving the sheet as a .csv file now, a different separator will be used (usually a semicolon) and our platform can read the file correctly.

We hope this article can help you to correctly upload files to our platform. If you have any further issues, please do not hesitate to contact us through the chat!

Was this article helpful?

Still puzzling over something?

The agent has read this article — and everything around it. Ask a follow-up and it answers in seconds.