Standardize Japanese text

[blairplett]

Hello,  

I am trying to do analytics on Japanese data, but the data contains both full-width and half-width characters. 

Half Width "ｱ", "ｲ", "ｳ", "ｴ", "ｵ",

Full Width＂ア＂，　＂イ＂，　＂ウ＂，　＂エ＂，　＂オ＂，

  
What is the easiest way to convert all half-width to full-width, and full-width to half-width?

Thank you! 

Blair 

[AbhilashR]

Hi @blairplett, how is the Japanese data being read into Alteryx? is it from a csv file or excel? I personally haven't seen this scenario, so not sure if I can be of help, but would certainly like to explore a solution with you.

[ImadZidan]

Hello @blairplett ,

I would explore Nippon package in R. It has two functions that converts half to full and vice versa.

If you want me to give you an example let me know. I would say explore as it may not be the way you want to go.

The idea would be to have an R routine with your data as an input and data frame as an output.

I hope you find this helpful.