Transliterates Asian script characters from one script form to another. The string can be specified as a column reference or a string literal.


Column reference example:

transliterate(MyJapaneseSentences,HiraganaToKatakana)

Output: Returns the values in the myJapaneseSentences transliterated from Hiragana script form to Katakana script form.

transliterate(column_string,form_enum)


ArgumentRequired?Data TypeDescription
column_stringYstringName of the column or string literal to be applied to the function
form_enumYstring (enumerated value)The transliteration form as an enumerated value. Details below.

column_string

Name of the column or string constant to be transliterated. String values must be in a supported Japanese script form. See below.

Required?Data TypeExample Value
YesString literal or column referencemyColumn

form_enum

Enumerated value to indicate the transliteration to apply to the referenced column:

NOTE: Each width option can be paired with each form option. Four separate options are supported.

Enum valueDescription
HiraganaToKatakanaTransliterates Hiragana to Katagana
KatakanaToHiraganaTransliterates Katagana to Hiragana
FullwidthToHalfwidthTransliterates full-width forms to half-width form
HalfwidthToFullwidthTransliterates half-width forms to full-width form

Required?Data TypeExample Value
YesString (enumerated type)HiraganaToKatakana

Example - TRANSLITERATE Function

Source:

EnglishJapanese_Hiragana
a
i
u
e
o
ka
ki
ku
ke
ko


Transformation:

The following transliterates the above characters into Katakana form:

The generated Katakana form is full-width. The following transliterates that column into half-width form:

Results:

EnglishJapanese_HiraganaJapanese_KatakanaJapanese_Katakana_halfwidth
a
i
u
e
o
ka
ki
ku
ke
ko