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
Right Function:
Right (Text t, Text d)
Description: Returns the right part of a text value starting at the character after the last occurrence of a delimiter character. The first argument, t, is the value to be searched. The second argument, d, is a text value containing all the possible delimiter characters.
Example: Right("abc/def",";/,") returns "def"
Right("Michael Wissner", " ") returns "Wissner"
Something like this:
That should catch the entire email
Right (Text t, Text d)
Description: Returns the right part of a text value starting at the character after the last occurrence of a delimiter character. The first argument, t, is the value to be searched. The second argument, d, is a text value containing all the possible delimiter characters.
Example: Right("abc/def",";/,") returns "def"
Right("Michael Wissner", " ") returns "Wissner"
Something like this:
Right([Subject], "Letter sent to ")
That should catch the entire email