We help IT Professionals succeed at work.

check for string partial value in formula

metropia
metropia asked
on
how can I check for any part starting with “BT8000” in it on a formula?

please provide example if possible.

thank so much.
Comment
Watch Question

Top Expert 2011

Commented:
BRONZE EXPERT

Commented:
You don't say what you want to happen in that event.

Example..in a formula field.

if {table.field} startswith “BT8000” then
"xxx"
else
"yyy"
Senior Consultant
SILVER EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Another test is

This test is true if the string is there
InStr({table.field} ,“BT8000”) > 0  

You can also use LIKE

{table.field} LIKE  “*BT8000*”

or if you want as the question implies it to start with BT8000
{table.field} LIKE “BT8000*”

mlmcc

Explore More ContentExplore courses, solutions, and other research materials related to this topic.