About String Conversion Function
    • PDF

    About String Conversion Function

    • PDF

    Article summary

    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.

    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?