ETL and Data Integration tools - Modern ETL software for everyone

I am trying to import data from a .CSV to a SQL db. i have a requirement of doing some string manipulations on the column before insertion. i use the "calulated" option in the mapping section and try using substring or any of the other string functions. But i am not able to get any data into the database. The columns without the manipulation does get inserted fine.

please help.

[quote1164703399=ajit]

I am trying to import data from a .CSV to a SQL db. i have a requirement of doing some string manipulations on the column before insertion. i use the "calulated" option in the mapping section and try using substring or any of the other string functions. But i am not able to get any data into the database. The columns without the manipulation does get inserted fine.

please help.
[/quote1164703399]

I am using Visual Importer Pro 7.3.7 trial version.

Please email us some examples
Mike