Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7455
  • Last Modified:

Is there an equivalent to the "Like" operator in Business Objects XI

I have a table in a Desktop Intelligence report which pulls from multiple data providers. I want to add a column to the report table which uses an IF...THEN statement to test for a value in one of the report objects. For example: IF <Operating As Name> like "%OCC%" then 0 else 1

I get an error message with this syntax. I've also tried using the MATCH function but I'm not getting the results I expect. I appreciate any ideas!

Thanks!
David
0
dking_wri
Asked:
dking_wri
1 Solution
 
by6738Commented:
you'll want to use MATCH.  Perhaps your syntax was incorrect?  It should be similiar to:

if Match("asdf","%sd%") Then "Match Found" else "No Match Found"
0
 
dking_wriAuthor Commented:
Thanks for your tip. I'm not sure why I can't get MATCH() to work. This is the syntax I'm using but it isn't returning 0 for the record that contains the string "OCC". It returns the defaul value of 1
=if match( <Operating As Name(Annual Rents)> , "%OCC%")  then 0 else 1


I found that the POS() function does work for me. I used the syntax:  =if pos(<Operating As Name(Annual Rents)>, "OCC") = 0 then 0 else 1

If the Position function doesn't find the input string then it return 0 else it returns 1.  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now