Webi Variable Help: Extract string

[#1]

Hello,

I have a webi column (INFO) in a report as follows:

xdfgg,sdfgh,Mr Smith, John,

Always 4 "," total.

I need to extract everything between comma 2 and comma 3.

So Result should be : Mr Smith

Any ideas?

Thanks

Chuck

[amitrathi239 · Accepted solution]

follow below steps.

Create Variable V1=Substr([String];Pos([String];",")+1;Length([String]))

Next Variable V2=Substr([V1];Pos([V1];",")+1;Length([V1]))

Final Variable=Substr([V2];1;Pos([V2];",")-1)

[Former Member · Accepted solution]

Thank you Sir