Convert hiragana and katakana to Roman alphabets in the specified fields.
Convert the hiragana and katakana parts contained in the source value to Hepburn-style romaji. The parts that are not in hiragana or katakana will remain unchanged.
The conversion result can also be obtained using expressions such as “= $1”.
Set Field, Upper or Lower case, and Target Field (Optional).
Select the field to convert.
This parameter accepts the following field types:
If you select a field that is inside a table, the Do will process all rows of that table. See *1 for exceptions to this behavior.
*1: If you set a Condition that only applies to some table rows (such as the Condition “When Fields Value Changed”), the value will be set only for those affected by that Condition.
You can choose whether to convert the alphabet part to uppercase or lowercase. All characters in the string will be converted to either uppercase or lowercase.
“Uppercase only first letter” capitalizes the first letter of each word. It will convert all non-alphanumeric characters and underscores in the letters of each word to uppercase. Below are examples of the results converted with “Uppercase only first letter.”
Use this parameter to set the results to another field. You can omit this parameter if you do not set the results directly in the field but use it in another action.
You can specify the same field as the source field selected in “Field.”
This parameter accepts the following field types:
If the “Field” parameter is a field in the table, the “Target Field (Optional)” must also be selected from the same table.
This action is designed to work seamlessly with krewSheet.
Fields retrieved through a Lookup are not supported.
The following field types can be supported only at the timing of record saving (e.g. “Before Record Saved Excluding Deleted”): If you want to gain more technical knowledge, refer to the krewSheet documentation .
Conversion to Kunrei-shiki romaji is not supported.
The conversion result does not include long vowel marks like “ō”. For example, the conversion result of “とうきょう” is not “Tōkyō” but “Tokyo”.
It is not possible to convert only hiragana while leaving katakana, or to convert only katakana while leaving hiragana.