Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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
Hi,
Please refer the below posts which is marked as resolved. I hope they will give you the way forward.
Warm Regards,
Nikhil Thampi
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.
replaceAll("\\p{C}","")