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) |
| Argument | Required? | Data Type | Description |
|---|---|---|---|
| column_string | Y | string | Name of the column or string literal to be applied to the function |
| form_enum | Y | string (enumerated value) | The transliteration form as an enumerated value. Details below. |
Name of the column or string constant to be transliterated. String values must be in a supported Japanese script form. See below.
'Hello, World').
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | String literal or column reference | myColumn |
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 value | Description |
|---|---|
HiraganaToKatakana | Transliterates Hiragana to Katagana |
KatakanaToHiragana | Transliterates Katagana to Hiragana |
FullwidthToHalfwidth | Transliterates full-width forms to half-width form |
HalfwidthToFullwidth | Transliterates half-width forms to full-width form |
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | String (enumerated type) | HiraganaToKatakana |
Source:
| English | Japanese_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:
| English | Japanese_Hiragana | Japanese_Katakana | Japanese_Katakana_halfwidth |
|---|---|---|---|
| a | あ | ア | ｧ |
| i | い | イ | ｨ |
| u | う | ウ | ｩ |
| e | え | エ | ｪ |
| o | お | オ | ｫ |
| ka | か | カ | ｶ |
| ki | き | キ | ｷ |
| ku | く | ク | ｸ |
| ke | け | ケ | ｹ |
| ko | こ | コ | ｺ |