Solved

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

Posted on 2009-05-06
2
5,018 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
2 Comments
 
LVL 1

Accepted Solution

by:
by6738 earned 500 total points
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

762 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now