Is it possible to select the records which contain a '*' mark in webi report

[former_member217667]

Is it possible to select the records which contain a '*' mark in webi report?

Datatype is text.

Eg : I need to distinguish the records like '*Bikash' or 'B*ikash' or 'BIKASH*' or *BiKash* or **BIkasH**"

Thanks

Bikash

[Former Member · Accepted solution]

Yes.

Create a variable, StarFind as:

=If(Pos([Name];"*")>=1;"Y";"N")

Then filter StarFind and keep the Ys

[former_member217667]

Thank u So much for the reply. Now it worked.

[Former Member]

Yes You can...

This can be done using "Matches Pattern" Function.PFB the screen shot for the same