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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mani1304
Creator
Creator

Handle Unicode String datatype

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

 

 

Labels (2)
2 Replies
Anonymous
Not applicable

Hi,

 

    Please refer the below posts which is marked as resolved. I hope they will give you the way forward.

 

https://community.talend.com/t5/Design-and-Development/resolved-Encoding-to-UTF-8-miss-all-latin-spe...

 

https://community.talend.com/t5/Design-and-Development/resolved-problem-with-tMysqlOutput-and-Encodi...

 

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 🙂

mani1304
Creator
Creator
Author

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}","")