Adding a space at the beginning of each string that has a number at the start

[JDaviesInch]

I'm trying to add a space in front of any text string that has a number to begin with.

EG. 

1 Series

 1 Series

Is this possible? I've exhausted all of my knowledge!

I've tried using the formula tool but no luck.

Thanks

[Luke_C]

Hi @JDaviesInch 

Give this a shot, I'm using regex match to check for a pattern that starts with 0-9

[mceleavey]

Hi @JDaviesInch ,

Just a cheeky bit of regex:

No doubt @MarqueeCrew will slap me around again...

M.

[JDaviesInch]

Hi,

This works exactly what I need it to do. However, When I output to an excel file the spaces are lost. Any idea why this would be?

[Luke_C]

Hi @JDaviesInch 

Take a look at this thread. Looks like people have had luck swapping in another character or adding an apostrophe. 

[mceleavey]

@JDaviesInch ,

yeah, as @Luke_C  points out, this is not an Alteryx problem but an Excel problem.

Yet another reason why friends don't let friends Excel.

The reverse apostrophe ` is the hidden character to retain a leading space.

Try the following in the regex tool:

M

[danilang]

Hi @JDaviesInch 

If you're using the non-breaking space from the post that @Luke_C mentioned, the replace field that you should in the regex tool is \xA0\d.  "A0" is the hex value for the ASCII 160

Dan