Help

Formula for removing a comma from an email that has been extracted from a rollup

Topic Labels: Formulas
Solved
Jump to Solution
710 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kirsten_Kern
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

  1. How do I do that?
  2. 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.

1 Solution

Accepted Solutions
Kirsten_Kern
5 - Automation Enthusiast
5 - Automation Enthusiast

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:

See Solution in Thread

2 Replies 2

I would try SUBSTITUTE. REGEX could work too but I’m lazy

SUBSTITUTE({Field with Comma In It}, ",", "")
Kirsten_Kern
5 - Automation Enthusiast
5 - Automation Enthusiast

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: