Database Software

Hello,

I have a very simple map which contains one Flat File mapping component which reads an excel file saved as a .cvs file and then a Mapping Table component which takes it’s inputs from the Flat File component and loads the data into a staging table.

The problem is that the Comments column in the Flat File component is not able to read the data file when the data file’s Comments column contains an extra line feed character.

I can see two choices here: Either fix the flat file manually (not a great choice), or secondly, some how either shell out of the map or kick off some nightly cleaning script to grep and cut out the extra line-feeds from the flat file before the map’s Flat File component starts it’s loading process.

Thoughts?

Cheers and thanks in advance.

Sasha Froyland