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

Question

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

EG.

1 Series

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

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

Thanks

danilang · Answer

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

mceleavey · Answer

@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

Luke_C · Answer

Hi @JDaviesInch

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