Issue with special characters in delimited file input

[LMontesP]

Hello,

I have a problem with a .csv file (encoding is ISO-8859-15) that I am trying to import using a tFileInputDelimited.

Some of the fields in this file contain special characters such as "=", and the component seems to have a problem with that.

I get this error when executing the job:

org.talend.designer.runprocess.ProcessorException: Job compile errors

At least job "test_job" has a compile errors, please fix and export again.

Error Line: 2565

Detail Message: Syntax error on token "=", Expression expected after this token

The issue is that I can't remove those characters (some are part of email addresses).

So what should I do? Transform the .csv into some other file format?

Or is there a way to escape those characters that I am not aware of? Can you help me, please?

Thank you in advance

[manodwhb]

@Laura Montes​ , this is one way that you read entire file using tFileInputRaw and replace = with empty and then generate the file and read that file using tFileInputDelimited.

Thanks,

Manohar

[LMontesP]

Thank you for your answer. However, my problem is that I can't simply remove those characters with empty because they are part of important fields (for example, I have at least one email that goes something like "example=mail@domain.com").

Do you think there is any way to make the tFileInputDelimited ignore or escape those = characters?

[manodwhb]

@Laura Montes​ , You can try to using escape character.

[LMontesP]

In the end I solved it by using the "Create file delimited" command in the Metadata submenu in the Repository.

When I import the delimited file this way, it works without an issue for some reason...