+6How 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.
REGEX_REPLACE({Email Roll Up from Educator}, “([^,])(.)”, “$2”)
Again, thank you for any help on this.
Best answer by Kirsten_Kern
I would try SUBSTITUTE. REGEX could work too but I’m lazy
SUBSTITUTE({Field with Comma In It}, ",", "")
Kamille,
Lazy is good for me! I just needed something so that I could configure a softr.io field and this will do it! Thank you! :partying_face:
+27I would try SUBSTITUTE. REGEX could work too but I’m lazy
SUBSTITUTE({Field with Comma In It}, ",", "")
I would try SUBSTITUTE. REGEX could work too but I’m lazy
SUBSTITUTE({Field with Comma In It}, ",", "")
Kamille,
Lazy is good for me! I just needed something so that I could configure a softr.io field and this will do it! Thank you! :partying_face:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.