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
Solved

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

Posted on 2009-05-06
2
5,528 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
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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying 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

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

808 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