Is there an equivalent of Instr() in Formula Language? @explode didn’t seem to be what I’m looking for…
Subject: Is there an equivalent of Instr() in Formula Language?
@contains says it’s there or it’s not. It doesn’t give you the position of the first occurrence.
The designer help file gives all the string handling functions under “Locating and extracting substrings”.
Notice that functions for @left and @right can use STRINGS as well as numbers. Often in script you use instr because you then want to extract a sub string based on the position of a character. With formula language you don’t need to work out the position first: just tell it the substring to cut left or right from.
Subject: Is there an equivalent of Instr() in Formula Language?
@Contains