I need to transform special characters like "á" . Whenever i read these characters and create a output file it shows "" . Please help how these characters can be handled and it should be loaded into the output. I am stuck badly with this .
Solved! Go to Solution.
Try using regex:
Which means, replace any non-word characters (any character outside from [a-zA-Z_0-9]).
If it doesn't matches with your requirements, you can specifiy the characters to replaced bt yourself:
Which means, replace these characters (àâäéèêëîïôöùûü) by nothing.
You just have to complete the list of characters you want to remove.
Thanks for the reply.
But my requirement is not to replace special character with empty string. It is to load the special characters to output file/table with same size as input file and data should not get trimmed.
In my case, it is populating special characters as empty string but I want to know how Talend handles special characters.
I had encountered a similiar issue.
make sure your source and target files are with the same encoding.
If you use UTF-8 character encoding this should not occur.
I had a similar issue.
I was sending a message to a soap endpoint and Köln was converted as K?ln. This issue didn't occur from the studio but only when I scheduled the standalone job as a scheduled task.
This is how I fixed it: http://talendhowto.com/2017/09/02/add-encoding-batch-file/
Usin utf-8 as encodin gpage will solve the problem and in case of latin characters to be existed u have to override the JVM parameters with utf parameter also.
Could you please give details on how did you resolve it. I am still getting ? mark if I get any ' mark in my excel source
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Find out how to migrate from one database to another using the Dynamic schema
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences