I am trying to create an IF statement that
IF [Part Prefix] begins with IL**** then "Illustrations" ELSE Null() ENDIF
However, I am not sure how to have the IF Statement look for data that starts with one/two letters and ends with random numbers.
Solved! Go to Solution.
If startswith([part prefix],"Il") then "Illustrations " else null() endif
that should work
cheers,
mark
After messing around with "if contains" and REGEX_MATCH for far too long, this post is the one that got me what I needed. Thanks!