Parsing multiple values from FromExtVXML into ICM

[John Ellis]

I am working on trying to parse out multiple data points in the FromExtVXML array in ICM, and am having some syntax issues.

from CVP in Arrays 0 and 1 i am sending back something like this

pv2={Data;pv3={Data};pv4={Data}
pv5={Data};pv6={Data};pv8={Data}

The field lengths are not fixed, so the data could vary from call to call.  is there a way in ICM to set for example

PeripheralVar2 = before("PV4=", after "PV2=" FromExtVXML[0])

What is the best way to break each of the 3 data points out of each array?

Thanks in advance.....

[janinegraves · Accepted solution]

Since your data is returned and key=value; delimited by semicolons, your expression can be simplified to this before(";", after("PV2=",FromExtVXML[0]))
So you can create a Custom Function named parseData in Script Editor (Script > Custom Functions) add 2 params:

Parameters: 2

FunctionDefinition: before(";", after(%1%, %2%)


Then in a SetVariable node go into custom functions and choose the function and fill in the arguments

userparseData("pv2=",Call.user.microapp.FromExtVXML[0])

or

userparseData("pv5=",Call.user.microapp.FromExtVXML[1])

[John Ellis]

Thanks, I'll give this a try.  Appreciate the info!