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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
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.