cancel
Showing results for 
Search instead for 
Did you mean: 

Problem in File Sender Adapter in File with quotes

Former Member
0 Kudos

Hi experts.

We're having a problem in File Sender Adpapter.

We've configured the adapter with FCC. We use the fieldSeparator = ; to convert the file to xml.

The problem arises when between two ; appears a quote. For insantce in this line:

HUMALVAL MASCOTAS S.L.;"AV/DE EUROPA SN;P.IND.ALCORCO;28922;ALCORCON;40.349968;-3.847452;

The adapter shows this error:

More elements in file csv structure than field names specified.

If the line was (without "):

HUMALVAL MASCOTAS S.L.;AV/DE EUROPA SN;P.IND.ALCORCO;28922;ALCORCON;40.349968;-3.847452;

everything would work correctly.

How could we solve this?

Thanks in advance.

Regards.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks everybody.

The problem wasn't the ", the problem was that in the file travel more ; it has to be.

Former Member
0 Kudos

Use

Record.enclosureSign: ''

Thanks

Amit

former_member463616
Contributor
0 Kudos

Hi,

Please use xml.enclosureSign=u201C in your sender FCC.

Hopes this helps to you.

Regards,

P.Rajesh