Importing CSV files

[GAVIN.RUDLING]

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

[steven.boggs]

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: