Forum Discussion

JensDeveloper's avatar
JensDeveloper
Contributor II
4 years ago
Solved

Change array to object and extract certain characters from it

Hi, I am trying to change the array to an object and after that only get the value between the () Example: Input [ { “Systems” : [“Ardoq (431)”, “SnapLogic (780)”] } { “Systems” : [...
expression
expression_language
nsingam's avatar
nsingam
Employee
4 years ago

Hi,

Use the below expression in a mapper. After that use the Splitter snap to get the details.

$Systems.map(x => {“Systems” : x.substring(x.indexOf(“(”)+1, x.indexOf(“)”))})