LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: sree

Hi Team,

in my source some of the records are Non English letters,but need to load those in English in output file.
Please help me how to convert Non English to English Letters.
Firstname Lastname
胡 兵
张 兵
帅 兵
罗 兴玲
刘 兵
欧 兴生
谢 兴芬
谢 其祥
武 兴生
龚 兴达
马 冀
Can you please help me how to get it using Filter node.

Regards,
Sree.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ejones

Not knowing much, if anything, about the Chinese language, I asked another Lavastorm employee about this question and received the following answer:

---
Each Chinese character has its own English letters. Please find the translated content below. Hope it helps!

Firstname Lastname
胡 (Hu) 兵 (Bing)
张 (Zhang) 兵 (Bing)
帅 (Shuai) 兵(Bing)
罗 (Luo) 兴玲 (Xingling)
刘 (Liu) 兵 (Bing)
欧 (Ou) 兴生 (Xingsheng)
谢 (Xie) 兴芬 (Xingfen)
谢 (Xie) 其祥 (Qixiang)
武 (Wu) 兴生 (Xingsheng)
龚 (Gong) 兴达 (Xingda)
马 (Ma) 冀 (Ji)

Let me know if you need any further help.
---
So each of these characters should be able to be held in a Unicode datatype field. And this conversion could be done using a Filter node. Or better yet, this can be put into a Static Data node and a Lookup node used to do the conversion.