I have a rich area text field that I need to be able to trim using a formula so that I can display the first line of text from it.
For example, this is what the text field looks like:
TEST TEXT 1, TEST TEXT 2, TEST TEXT 3, ETC,.
I need to be able to take that first line (TEST TEXT 1) before the comma and display only that text in a normal text field, I tried using a combination of find, trim, and left in my formula but it didn't produce the desired result. Anyone have any idea how to accomplish this?