How to split a value into multiple fields

[izzy_babcock]

Hello,

Say I have a .csv with the following row:

value1_value2_value3_value4_value5

How can I split the string by “_” so each value can be mapped to its own field? I basically need to do stuff with each record, but through the Mapper I can’t seem to figure out how to accomplish this.

Mapping from: “value1_value2_value3_value4_value5”
To:
“value1”
“value2”
“value3”
“value4”
“value5”

Thank you in advance.

Best,
Izzy Babcock

[j_angelevski · Accepted solution]

Hello @izzy.babcock,

You can use .split() method in a mapper like this → $row.split("_"), this will create an array then you can simply map that value to the target path and after that use a JSON Splitter to split on the target path containing the array fields.

[izzy_babcock]

thank you!