How to get string between comma's

[Former Member]

Hi All,

I am working on one transaction and output is  "Deepali,B1993,January".But,I want only "B1993" as output.

How can I get it by using functions in expression editor?

Please help me in this.

[saivellanki]

Hi Deepali,

Not sure whether there is any expression editor function available. But, one way of doing it is,

• Create a local variable 'sample'. (In the screenshot I named it as 'Name')
• Assign output value - Deepali,B1993,January to sample variable.
• Then use 'StringListToXML' action block which is present under XML functions.
• In the incoming action, map sample variable to input of StringListToXML and use "," as delimiter.

         

• Now using XPath - StringListToXML.Output{/Rowsets/Rowset/Row[2]/Item} you can get the value

         

     

Regards,

Sai Vellanki.