Add white space using RegEx

[Access]

I have a string: 1,2,3,4,5
I need it to look like this: 1, 2, 3, 4, 5

How can i do it with Regex?

Thank you

[cosmicbdog]

\s ?

[Rakuli]

If you know it will be as simple as that you have a couple of options. You can use Split to split on the commas.

Code: Select all

var str = '1,2,3,4,5';

str = str.split(',');
var newstr = '';
for (i=0; i< str.length; i++)
{
       newstr += str[i] + ' ';
       if (i < str.length -1)
        newstr += ',';
}

Or use the replace and catch the patterns

Code: Select all

var str = '1,2,3,4,5';

str = str.replace(/([1-9])([,])+/g, '$1$2 ');