Forum Discussion

MikeGerrity2's avatar
MikeGerrity2
Qrew Member
10 years ago

Is there a formula that will tell tell you the position of a specficic character in a text string

I'm looking for the equivalent of the "Find" function in excel.   find("x","I am x years old") would equal return 6.  Since x is the 6th character in the string.   I don't think this formula exis...
Data import and export
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
10 years ago
Try this. I will use formula variables to break the formula into smaller pieces.

var text Temp = Left([my text field],"x");

Length($Temp) +1
Jan-WillemSpeck's avatar
Jan-WillemSpeck
Qrew Assistant Captain
8 years ago
I would like to go one step further with this function.

1) find a specific chararter combination
ie
var text Temp = Left([my text field],"#%");
Length($Temp) +1
2) from the position where "#%" is located I like to read the next 5 characters
ie Mid([field], <start position>, 5)

if I replace <start position> with the two lines in 1) it doesn't work. I assume it has the do with the variable, the code in 1) or with the ;
Is there a better way to get this?

In an even better scenarion I should perhaps first check if the text string contains the value "#%"  at all to avoid wrong output of 1). Currently if it can't find it seems to result in the sting length