Remove spaces between words, remove special characters

[MaxW]

I am using the Create CSV module in a scenario, I have the following product title:

Gravity Gemstone (Stellar Crown) 137/142
Galarian Mr. Mime (Crown Zenith) 030/159

Which I need to format this as (inside the URL handle):

gravity_gemstone_stellar_crown_137_142
galarian_mr_mime_crown_zenith_030_159

It mirrors the Title cell exactly, but would replace all spaces, brackets, full stops with an underscore.

This is what I have so far (note: I’m starting with col4 first):

This is the scenario:

The email I receive which has the CSV as an attachment has the URL handle cell as:

gravity gemstone
galarian mr. mime

Have I formatted it the right way?

[Stoyan_Vatov]

Hey Max,

you need a regex in the replace formula, right now its looking for the exact match of that patter you have.

You can read more here: How to use Regex in Make?

[samliew]

The second parameter of your replace function should be

/[\s()/.]+/g

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.