Text Filtering

building reports webintelligence
1

Hi.

I have an element [Party Name 1] that returns text values. Some of the values contain * and some do not. I am looking for a way to filter out anything that contains the * and only display the records that do not contain the *. I am doing this through text filtering in excel but am looking for something more automated in Business Objects.

If it helps, all records containing the * will have the * at the very beginning.

FYI - I have no access to universe level and the people who do are not willing to make changes at the universe level.

Any ideas/assistance would be greatly appreciated.

BOgohanBO :us: (BOB member since 2015-03-16)

2

Create a variable, let’s call it StarFilter, that looks like:

=IF(Left([My Field],1) = '*';'Out';'In')

Now just apply a filter to your report where StarFilter = ‘In’.

Lugh (BOB member since 2009-07-16)

3

Thank you! This worked perfectly and will save me loads of time!

:+1: :yesnod:

BOgohanBO :us: (BOB member since 2015-03-16)