Split Fields

    Below are examples of split fields:

    SALES_VALUES field containing: “500,300,200,100”

    Use these settings to split the field into four new fields:

    • Delimiter: ,

    • Field: SALES1, SALES2, SALES3, SALES4

    • remove ID no, no, no, no

    • type: Number, Number, Number, Number

    • format: ., ., ., .

    • group:

    • decimal: .

    • currency:

    • precision: 0, 0, 0, 0

    Example 2

    SALES_VALUES field containing “Sales2=310.50, Sales4=150.23”

    Use these settings to split the field into four new fields:

    • Field: SALES1, SALES2, SALES3, SALES4

    • Id: Sales1=, Sales2=, Sales3=, Sales4=

    • remove ID yes, yes, yes, yes

    • type: Number, Number, Number, Number

    • format: ., ., ., .

    • group:

    • decimal: .

    • currency:

    • precision: 2, 2, 2, 2