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
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.
  • AdamKrzyzanek's avatar
    AdamKrzyzanek
    Qrew Captain
    6 years ago
    I know it is old Post but Was looking for this solution and did not find in Community.
    Come up with such solutions posted HERE

    ------------------------------
    Adam Krzyzanek
    ------------------------------