I have jobs, where the datatype is unicode string, that I can handle in ab initio DML having string as data type and unicode as character set, but I don't see any such datatype handling situation in talend, can someone suggest to handle it.
It seems data has space in between letter but it is actually not space, so can't replace space with blank in it. below is one example.
8 7 7 2 5 0 5 8 2 3
Please refer the below posts which is marked as resolved. I hope they will give you the way forward.
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)
Thanks Nikhil. but it doesn't have my answer.
I found below command on net to remove unprintable unicode letters and it is working on current dataset, which has less data, but I am not sure if this is correct and will work on everything.
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