Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[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?
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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 

View solution in original post

4 Replies
Anonymous
Not applicable
Author

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

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 
Anonymous
Not applicable
Author

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

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