Forum Discussion

UrsulaLlaveria's avatar
UrsulaLlaveria
Qrew Assistant Captain
5 years ago

Split a Text Field on a particular word

I have a text field that ends with " - TOTAL". However, in some cases, it will end with "- TOTAL_xxxxx".
Ex: location-xxxxx-name - TOTAL 
Ex: location-xxx-name - TOTAL_xxxxx

I need everything before the "Total" and am trying to find a way to split the text field to get just that. I thought I could use Part(), but that will recognize each character, not the entire word. I also did notRight and counted out the characters, but that won't work with the TOTAL_xxxxx. Any ideas??

------------------------------
Ursula
------------------------------
Formulas and functions
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    How about using an IF statement in conjunction with the NotRight function?

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
  • MichaelTamoush's avatar
    MichaelTamoush
    Qrew Captain
    5 years ago
    Can you just use left([Your Field],"Total") or Can you just use notright([Your Field],"Total")?

    ------------------------------
    Mike Tamoush
    ------------------------------