Jump to content
We've recently updated our Privacy Statement, available here. ×

How can I build an expression to find several instances

Carolina Rivera

Recommended Posts

Hi everyone,

I currently have a data set in Spotfire that contains the same instances for various values. For example: I have 3 values (Blue Process End Time, Red Process End Time, Green Process End Time), but I would like to add a statement to my expression that can find all values containing "Process End Time". The expression I currently have accounts for other rows, but they are accounted for using an IF OR statement:

IF(([function_name]="Final Process End Time") OR ([function_name]="Process End Date"), [date_local],null)


Thanks in advance,

Carolina Rivera

Link to comment
Share on other sites

You can use the FIND function. It will return an integer value of the position of a given string. It is case sensitive, be careful. So here's an example from Spotfire help:

Find("el", "Hello") 0, TRUE, FALSE)

Maybe there is also the possibility to word with a regular expression. But I get along with the FIND function pretty well.

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...