Forum Discussion

izzy_babcock's avatar
izzy_babcock
New Contributor II
4 years ago
Solved

How to split a value into multiple fields

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 stuf...
  • j_angelevski's avatar
    j_angelevski
    4 years ago

    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.

j_angelevski's avatar
j_angelevski
Contributor III
4 years ago
Copy Link

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.