Solved

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

Posted on 2009-05-06
2
5,685 Views
Last Modified: 2013-11-15
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
Comment
Question by:dking_wri
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Accepted Solution

by:
by6738 earned 500 total points
ID: 24319903
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
 

Author Comment

by:dking_wri
ID: 24320481
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to increase the row limit in Jasper Server.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question