String Conversion
  • 07 Dec 2022
  • Dark
    Light
  • PDF

String Conversion

  • Dark
    Light
  • PDF

Article Summary

Note

This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.

How it works

You can use it by setting it in Data settings in STEP.2 Preview / Advanced settings of Transfer Settings.
If you save and preview after setting, you can check the column data after application on the preview screen.

Conversion Specifications

It can only be applied to the String type.
It is also possible to apply multiple replacement settings to a single column.
The following conversion methods are supported:

  • Normalization (full-width alphanumeric→ half-width, half-width kana→ full-width, etc.)

Normalization (full-width alphanumeric→ half-width, half-width kana→ full-width, etc.)

NFKC is used as the conversion method.

Half-width kana → full-width kana
Full-width alphanumeric →half-width alphanumeric
Special half-width and full-width characters (example)
Half-width → full-width
Punctuation (。 →。 )
Commas (, →,)
Full-width → half-width
Dollar ($→$)
JPY(¥→\)
Minus (−→-)

Learn more and find out more about other conversions.


Was this article helpful?