Import CSV: textfield imports as number error

MODH · June 23, 2020, 12:45pm

Hi,
We try to import a CSV file with data and text, separted by semicolon. In CSV file the data we want to import is between double quotes, but after import the data(text) is set to number.
Changing setting comma/point as groupseperator is noit the solution.

Help is appreciated?

dgudkov · June 23, 2020, 1:13pm

Hi @MODH and welcome to the Community!

Try changing the decimal separator to comma. See below:

MODH · June 23, 2020, 5:23pm

Hi @dgudkov ,
this option only change the comma to a point and we need the text as a comma for validation in a database in a complete other process.
We also thought about this and than change the point into a comma again, but then it destroys all other textfields in this column.
We also tried all other options like changing the encoding.
I think this is a bug in the import action. In the csv it is marked as text and should be handled like that.

Is it a possibility to add the feature ‘change column setting at import’ ? in this action?

dgudkov · June 23, 2020, 7:43pm

We’ll see if we can offer a fix.

Meanwhile, you can use multiple conditions to preserve other values from being broken while replacing the dot with comma, for instance:

if(isnumber([Data]) and contains(astext([Data]), '.'), replace([Data], '.', ','), [Data])

MODH · June 24, 2020, 7:54am

@dgudkov Thank you for the response.
The provided (temporarily) solution does not work for us, since we have more data that needs to stay as is and no replacing.
Hopefully development can fix the import issue

dgudkov · June 27, 2020, 4:11pm

@MODH,

we’ve added a new option in v4.4 that regulates how numeric values should be imported in the “Import from delimited files” action. Version 4.4 will be released in a few days.

MODH · June 30, 2020, 6:55am

Thanx, that is a great solution

Marco_Ferraresi · January 17, 2025, 11:57am

Hi, today I have the same error also if I use the "treat numeric values as text when quoted". A single line of a huge csv file show a field as number instead of text when the csv has that number inside quotes like all the other rows.
v5.8.2.8. Here attached the screenshots.

vlad_dzhos · January 17, 2025, 4:58pm

Hello @Marco_Ferraresi,

Thank you for your bug report. We have identified the issue and are currently preparing a fix, which should be available soon.
In the meantime, you can switch the CSV parser to legacy mode in the application preferences. While this mode is slower, it does not exhibit the issue.

Thank you

dgudkov · January 18, 2025, 12:13am

@Marco_Ferraresi This bug has been fixed. You can download the updated version from our website.