Formula To Truncate Text Field
I need to write a formula for a text field titled "subject" that consistently removes the text "Confirmation Copy of Welcome Letter sent to" from the subject heading "Confirmation Copy of Welcome L...
Forum Discussion
Sure, the Trim was just insurance to insure that we were trimming off any trailing spaces.
It will have probably worked just as well like this.
Right([Subject]," ")
That says
Start from the right side of the string and keep going to the left until you hit any of the characters in the list of delimiters in the quotes. Since the only delimiter in the quotes was a space, it will stop at the first space.
Here is a link to all the formula functions.
https://login.quickbase.com/db/6ewwzuuj?a=q&qid=1000080
It will have probably worked just as well like this.
Right([Subject]," ")
That says
Start from the right side of the string and keep going to the left until you hit any of the characters in the list of delimiters in the quotes. Since the only delimiter in the quotes was a space, it will stop at the first space.
Here is a link to all the formula functions.
https://login.quickbase.com/db/6ewwzuuj?a=q&qid=1000080