How to remove text qualifiers in MDM 5.5sp6 Import Manager

[ivan_thoelen]

Hi,

I'm trying to import some text files using the import manager.

This text files have double quotes (") as text qualifier. Is there a way in MDM to remove these?

I cannot first load these text files to Excel because there are much more then 65000 lines.

Regards

Ivan.

[Former Member · Accepted solution]

Hi Ivan,

You can remove the double quotes once you have imported the file successfully.

In the import manager, go to that particular source field.

Right click to get the option Value Conversion Filters.

Try with normalize or replace.

Hope it helps.

Thanks,

Minaz