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 be...
Forum Discussion
Can you just use left([Your Field],"Total") or Can you just use notright([Your Field],"Total")?
------------------------------
Mike Tamoush
------------------------------
------------------------------
Mike Tamoush
------------------------------