Check this spec,
[
{
"operation": "shift",
"spec": {
"*": {
"@": "&",
// Shift all the DE nodes to a same named node.
// Here it is moved as TMPDE
"payload": {
"DE|DE61": "&2.payload.TMPDE"
}
}
}
}, {
"operation": "modify-default-beta",
"spec": {
"*": {
"payload": {
"DE61SF1": "=substring(@(1,TMPDE), 2, 4)",
"DE61SF2": "=substring(@(1,TMPDE), 5, 14)",
"DE61SF3": "=substring(@(1,TMPDE), 14, 21)"
}
}
}
}, {
"operation": "shift",
"spec": {
"*": {
"correlationId": "[&1].correlationId",
"payloadFormat": "[&1].payloadFormat",
"payload": {
"DE61SF1": "[&2].DE61SF1",
"DE61SF2": "[&2].DE61SF2",
"DE61SF3": "[&2].DE61SF3",
"location": "[&2].location",
"pop": "[&2].pop",
"name": "[&2].name"
}
}
}
}
]
CLICK HERE to find out more related problems solutions.