Replace all sub-strings in a string not just first sub-string

Question

I need to replace all instances of a sub-string in a string

I am using

A1.toString().replace(to_replace,replace_with)

But it is only replacing the first instance

Ex

to_replace = ",@"
replace_with = "|"

I get for a cell value

a,@b,@c,@d  >>  a|b,@c,@d

I need

a,@b,@c,@d >> a|b|c|d

I can not figure out if their is a setting to replace all not just the first instance

Thanks

https://stackoverflow.com/questions/2116558/fastest-method-to-replace-all-instances-of-a-character-in-a-string — epascarello, Jan 24 '18 at 22:14
You can use regular expression. Check https://stackoverflow.com/questions/1144783/how-to-replace-all-occurrences-of-a-string-in-javascript — alexkom, Jan 24 '18 at 22:14
`A1.toString().replace(RegExp(to_replace,"g"),replace_with)` — epascarello, Jan 24 '18 at 22:17

score 0 · Accepted Answer · answered Jan 24 '18 at 22:15

0

You can use this trick to do it:

A1.toString().split(to_replace).join(replace_with)

this will divide your string to an array without substring to replace, and then will build it again to a new string with the new substring, acting like a replace all function

answered Jan 24 '18 at 22:15

regev avraham

1,102
1
9
24

Wonderful. thanks regev – Jersy One Jan 24 '18 at 22:23

Replace all sub-strings in a string not just first sub-string

1 Answers1