[resolved] Invalid Escape character

One Star

[resolved] Invalid Escape character

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?

Accepted Solutions
One Star

Re: [resolved] Invalid Escape character

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 

All Replies
Five Stars

Re: [resolved] Invalid Escape character

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

Re: [resolved] Invalid Escape character

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 
Five Stars

Re: [resolved] Invalid Escape character

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

Re: [resolved] Invalid Escape character

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