Import Manager Delimiter Issue "|

[Former Member]

Hi,

We are facing a issue in during Import...We are loading Pipe Delimited file. Whenever we get "after |(Pipe) MDM is throwing an exception stating that 'Number of field values does not match the field columns'...Please let me know any body faced these kind of issues and solution. The format used here is UTF-8...

Example : |TEST123"EEE|TEST|A| - Here " comes after the Pipe and MDM Import Manager Accepting

|"TEST123 EEE|TEST|A| - MDM Import Manager is throwing an error stating that 'Number of field values does not match the field columns' because " comes immediately after pipe....

Thanks

Ganesh Kotti

[former_member982226 · Accepted solution]

Ganesh, please see [Note 1346052 - Connecting to source Import Manager error message|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1346052].

The " has special meanings in import manager and can only be used in pairs. If the first character of a field is a ", then there has to be another one in the same field. Or you can remove it alltogether.

[Former Member]

Hello Ganesh Kotti

I mean in that case Import Manager(IM) used normalization for that field

You should change you source file format for loading through IM

Regards

Kanstantsin