Add Space After First 9 Characters

[Mike_at_CG]

Hi Alteryx Community

Wanted to see if there was a way to add a space after the first 9 characters of a string?  

So for example the first line item would read 450737911 (SPACE) A000830OO

Thank you

[DataNath · Accepted solution]

Hey @Mike_at_CG, there's a bunch of ways to go about this but here's one way I can think of:

The Left() function just takes the first N characters (9 here of course), and then right does the same, except we need this to be dynamic to different record lengths and so we feed it the Length() function and take 9 away from that to account for those on the first side of the space.

[Sebastiaandb · Accepted solution]

Hi @Mike_at_CG ,

Sure, just make a formula in the formula tool like: 

REGEX_Replace([Field1], "(.{9})(.*)", "$1 $2")

Greetings,

Seb

[Luke_C · Accepted solution]

Hi @Mike_at_CG 

Here's two options: