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)