How to split a value into multiple fields


Say I have a .csv with the following row:


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”

Thank you in advance.

Izzy Babcock

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.

1 Like

thank you!