Regex: Replacing space with "-"

[MosesAddai24]

I am trying to replace “ “ and “/” in this column with “_” . How do I frame the regular expression and replacement text?

[JoaoLeiteV]

Hello @MosesAddai24,

The images you posted aren't already doing that? The Original Header(State) seems to have, for example, the text "2 3", and you're replacing the text.

If not, if your data is composed of digits and words, you can use ([\w\d]+)[\s\/]([\w\d]+)

This will:

   1. ([\w\d]+) - Group any combination of words and digits

   2. [\s\/] - Check if theres a spacebar of a slash

   3. ([\w\d]+) - Group again any combination of words and digits

Then for the replacement, just use "$1_$2"

Hope this helps!

[christine_assaad]

Hi @MosesAddai24 

This is a Non-Regex way that uses formula to achieve the same goal. Hope it helps. Cheers!

[MosesAddai24]

I tried it and got an error that says " " cannot be found. How do solve the error?

[MosesAddai24]

When I used that I got **_** throughout that column. Do I have to change something in the code?

[KarolinaRoza · Accepted solution]

hi @MosesAddai24 

I just tried to replace any white space and slash signs using:  [\s\/] in Regular Expression with "_".  It should work.

Karolina

[MosesAddai24]

It worked! Thank you !

[apathetichell]

@JoaoLeiteVFYI - \w includes \d already so no need to check for both...

[JoaoLeiteV]

Thanks for the tip @apathetichell! I'll keep that in mind.

[christine_assaad]

Hi @MosesAddai24 

I'm glad you were able to get your problem solved, from the screenshot, it seems that you did not give your newly created column a name, hence the error. Cheers!