Skip to main content
Question

Split a Text Field on a particular word

  • February 18, 2021
  • 0 replies
  • 134 views
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
------------------------------
This topic has been closed for replies.

  • BlakeHarrison
  • Registered
  • February 18, 2021
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/
------------------------------
Forum|alt.badge.img+14
Can you just use left([Your Field],"Total") or Can you just use notright([Your Field],"Total")?

------------------------------
Mike Tamoush
------------------------------
Terms & ConditionsAccessibility statement