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