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?
Hi @JDaviesInch
Take a look at this thread. Looks like people have had luck swapping in another character or adding an apostrophe.
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
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