Skip to main content
Question

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

  • August 25, 2015
  • 0 replies
  • 254 views

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 exists in quickbase, but any work arounds?

With this formula I can then add logic for left/notleft/right/mid to extract specific text elements.

This topic has been closed for replies.

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
Note that if your goal is to parse out a section of text up to a character, that the Left and Right functions in Quickbase will do that for you.  You can do this

Left([My string],6)

But as you can see above, you can also do Left([My String],"x") which gives all the text up to the first x.
Terms & ConditionsAccessibility statement