The TIBCO Platform is a real-time, composable data platform that will bring together an evolving set of your TIBCO solutions - and it's available now!
A chart showing the TIBCO Platform vision
Jump to content
Forums
Ask questions and gain insight from discussions

Looking for more than one expression in a value


Roger Meili 2

Recommended Posts

I try to find different expressions in a data string. I use the IF, OR and FIND functions. If I am looking for just one expression it works perfectly but if I try with the IF-Formula to find more expressions, it doesn't work. Does any body know why? That's the formula I use:

IF(OR(FIND("KG", Contact.recent_conversion_event_name), FIND("event", Contact.recent_conversion_event_name), FIND("webinar", Contact.recent_conversion_event_name)), NULL, Contact.recent_conversion_date & " - " & Contact.recent_conversion_event_name & " - " & Contact.what_are_your_major_challenges_ & " - " & Contact.open_answer & " - " & Contact.recent_webinar)

By the way, the formula checker shows all correct.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...