I am currently starting with Talend and I am facing a problem.
I use DBVisualizer as database tool and I have no error on it. Then I try the same query into Talend. When I use the 'Guess Schema' button, I face the following error :
Invalid escape sequence (valid ones are \b \t \n \f \\" \' \\)
From what I understand, the problem is in the syntax of my query. I should escape "\" with "\\". Then, the point I don't understand is that I have no "\" into my query and still this error.
You will find in attachment the query I use.
If someone can explain to me the origin of the problem, I would be grateful.
Thank you in advance,
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables