About String Conversion Function
- Print
- PDF
About String Conversion Function
- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
How to use
Data Settings in STEP.2 Preview and Advanced Settings in ETL Configuration.
After Data Setting, save and preview the data, and you will see the applied column data in the preview window.
Conversion Specifications
It can only be applied to String types.
Multiple replacement settings can be applied to a single column.
The following conversion methods are supported
- Normalization (full-width alphanumeric characters to half-width characters, half-width kana to full-width characters, etc.)
Normalization (full-width alphanumeric characters to half-width characters, half-width kana to full-width characters, etc.)
NFKC is used for the conversion method.
- Reference: https://www.unicode.org/reports/tr15/
half-width kana to full-width kana
Full-width alphanumeric character to half-width alphanumeric character
Special characters in half-size and full-size shapes (example)
Half-width → Full-width
Punctuation (.→。)
Reading marks (, →, )
Full-width → Half-width
Dollar ($ → $)
Yen (from ³ to ³)
Minus (-→-)
For more information and other conversions, please click here.
Was this article helpful?