topic Importing CSV files in Product Forum

Importing CSV files

GAVIN.RUDLING — Wed, 17 Jul 2024 10:05:50 GMT

Good Day Team,

I am experiencing an issue when importing data from a CSV, Comma delimited file.

In the CSV file I can see values like:

,05.78, ,20.00, ,07.50,

How ever when the import is done the collection shows values like:

5.78 20 and 7.5

I seem to be losing the leading and Trailing 0's.

Does, anyone have any suggestions?

Regards

Gavin

Re: Importing CSV files

steven.boggs — Wed, 17 Jul 2024 13:47:23 GMT

This issue usually occurs due to the CSV format, as Excel tries to "correct" the format of the data. To get around this, we've recommended in the past to use a combination of the 'Utility - File Management' ('Read All Text from File' stage) and 'Utility - Strings' ('Get CSV As Collection' stage) VBOs to bring in all the data from the CSV input file and then output it to a collection with all columns formatted as text - meaning the leading zeros in mixed columns remain intact.

See example below: