How do I remove a comma from in front of an email that has been extracted from a rollup. I am very new to this formula writing.
I have a rollup field that has two emails in it. I have extracted the first email by itself. However, the second email alway has a comma in front of it. I need to remove that comma.
- How do I do that?
- Can I do it by altering this formula in any way?
REGEX_REPLACE({Email Roll Up from Educator}, ā(^,])(.)ā, ā$2ā)
Again, thank you for any help on this.