Contents:
Contents:
Wrangle vs. SQL: This function is part of Wrangle, a proprietary data transformation language. Wrangle is not SQL. For more information, see Wrangle Language.
Basic Usage
Column reference example:
transliterate(MyJapaneseSentences,HiraganaToKatakana)
Output: Returns the values in the myJapaneseSentences transliterated from Hiragana script form to Katakana script form.
Syntax and Arguments
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. |
For more information on syntax standards, see Language Documentation Syntax Notes.
column_string
Name of the column or string constant to be transliterated. String values must be in a supported Japanese script form. See below.
- Missing string or column values generate missing string results.
- String constants must be quoted (
'Hello, World'). - Multiple columns and wildcards are not supported.
Usage Notes:
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | String literal or column reference | myColumn |
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 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 |
Usage Notes:
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | String (enumerated type) | HiraganaToKatakana |
Tip: For additional examples, see Common Tasks.
Examples
Example - TRANSLITERATE Function
Source:
| English | Japanese_Hiragana |
|---|---|
| a | あ |
| i | い |
| u | う |
| e | え |
| o | お |
| ka | か |
| ki | き |
| ku | く |
| ke | け |
| ko | こ |
Transformation:
The following transliterates the above characters into Katakana form:
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | transliterate(Japanese_Hiragana, HiraganaToKatakana) |
| Parameter: New column name | 'Japanese_Katakana' |
The generated Katakana form is full-width. The following transliterates that column into half-width form:
| Transformation Name | New formula |
|---|---|
| Parameter: Formula type | Single row formula |
| Parameter: Formula | transliterate(Japanese_Katakana, FullwidthToHalfwidth) |
| Parameter: New column name | 'Japanese_Katakana_halfwidth' |
Results:
| English | Japanese_Hiragana | Japanese_Katakana | Japanese_Katakana_halfwidth |
|---|---|---|---|
| a | あ | ア | ｧ |
| i | い | イ | ｨ |
| u | う | ウ | ｩ |
| e | え | エ | ｪ |
| o | お | オ | ｫ |
| ka | か | カ | ｶ |
| ki | き | キ | ｷ |
| ku | く | ク | ｸ |
| ke | け | ケ | ｹ |
| ko | こ | コ | ｺ |
This page has no comments.