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.

[Former Member · Accepted solution]

Hi,

if output format is always same then string function can be used to get the desired result.

ccombination of stringindexof, stringpart and stringlength can also give the desired result. Let me know if u need sample example

[Former Member · Accepted solution]

output format is always same in this case.Can you give one sample example?

[Former Member · Accepted solution]

Transaction.Sample : Deepali,B1993,January

stringpart(stringpart(Transaction.Sample,stringindexof(Transaction.Sample,",")+1,stringlength(Transaction.Sample)-stringindexof(Transaction.Sample,",")),1,stringindexof(stringpart(Transaction.Sample,stringindexof(Transaction.Sample,",")+1,stringlength(Transaction.Sample)-stringindexof(Transaction.Sample,",")),",")-1)

[former_member185280]

Deepali,

Depending on your version another option you can try is using the stringtolist function to put the values into a local list type property. You can then get values by index using syntax like Local.mylist{1} etc.

Regards,
Christian

p.s. please mark answers helpful or correct. It helps others find solutions to similar problems easier. 

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