JonathanHeuer
5 years agoQrew Cadet
Find position of text string in larger string
I have a long string in my Services table, the result of a Combined Text Summary field, each element takes the pattern V###-#### (where the number parts of the string are arbitrary length). For example :
------------------------------
Jonathan Heuer
------------------------------
V102-136 ; V23-4072 ; V8-25I want to create a formula which extracts correct element in this array, based on the value in another field, and I could do it if I knew the position in the text string of the "V" value. So if there were a function Find which returned the position of a text string, that would do it. Something like
Find([Summary Field", "V" & [Text string to search for])I can't find a function to do this. Functions like left just search for single characters, and I need to search for a longer string. Ideas?
------------------------------
Jonathan Heuer
------------------------------