finding the word order in a string of words
Is there a function to give me the order of a word in a string
like I have a sting "LT_CMB_GR_FR"
And I need to know the order of the word GR which would be 3 in this case
This is no built in function for that, but this calculation will work:
Let ( [ T = Substitute ( "LT_CMB_GR_FR" ; "_" ; ¶ ) ;
p = Position ( T ; "GR" ; 1 ; 1 ) ] ;
If ( p ; ValueCount ( Left ( T ; p - 1 ) ) + 1 )
Where I have used quoted text, you can substitute fields or variables.
Retrieving data ...