Integration Manager and text qualifiers

[Luvsql]

We have a text file that was exported out of an application. The text qualifier was already determined upon export. Our string column contains -, " and ' in their descriptions. When we view the text file in notepad, it appears properly ie:

210 - 4' X 4 KINO
210 - 15" KINO
210 - 2ND 10K FRESNEL210 - 9" KINO KIT

However, when this data is viewed within Integration Manager, it views it as:

210 - 4' X 4 KINO
210 - 15
210 - 2ND 10K FRESNEL210 - 9

and all remaining columns are blank for fields containing the ". How can we control the text qualifiers within IM if it appears properly in every other app??

 

[curtman]

Hi - Have you checked that IM is recognizing those fields as text datatypes? In IM with the integration open, you can right click the data source and go to properties. The Columns tab will show the datatypes which you can change as needed.

 

[Luvsql]

IM sees this field as String type.