cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
247
Views
1
Helpful
2
Replies

Parsing multiple values from FromExtVXML into ICM

John Ellis
Level 1
Level 1

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.....

1 Accepted Solution

Accepted Solutions

janinegraves
Spotlight
Spotlight
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])

View solution in original post

2 Replies 2

janinegraves
Spotlight
Spotlight
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
Level 1
Level 1

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