topic Re: [resolved] Invalid Escape character in Talend Studio

[resolved] Invalid Escape character

Anonymous — Sat, 16 Nov 2024 11:14:57 GMT

Hi
I'm trying to make my first Job in talend via this tutorial.
I have my own *.csv

3,Text3
2,Text2
1,Text1

When I try to execute my job I get error Invalid Escape character(proper are \b, \n,....)
I opened my *.csv with hexeditor and saw normal CRLF on each line.
Why it happened and how can I solve it?

Re: [resolved] Invalid Escape character

Anonymous — Fri, 17 Apr 2015 13:16:43 GMT

check your row separator as "\r\n" and filed separator as "," including double quotes.

Re: [resolved] Invalid Escape character

Anonymous — Fri, 17 Apr 2015 13:55:07 GMT

All was changed to suit my *.csv.
And I solved it.
Problem was in tFileInputDelimited properties:
I entered path to *.csv manually. But when I tried to select the same file with "select dialog" I saw that file name has lost first letter:
Dataname was C:\file.csv
Is file Select dialog C:\ile.csv

Re: [resolved] Invalid Escape character

Anonymous — Fri, 17 Apr 2015 14:12:40 GMT

Thank you for sharing solution, but question is why error was for escape character instead file not found?

Re: [resolved] Invalid Escape character

Anonymous — Fri, 17 Apr 2015 14:40:53 GMT

I don't know.
But i'm sure that i don't have ile.csv in working folder.