Adding White Space after the second character - Help

[Dpharr]

I have a list of international phone numbers and the formatting is different with each. The only thing I need to do is add white space after the second character - For example

if the phone number is +916xxxxxxx - I need to insert a space so it reads +91 6xxxxxxx. Some numbers in my table are formatted in this fashion while others are not. Even though we are working with phone numbers the data type is V_WString. 

I'm running into a mental roadblock with something that should be simple. 

Thank you

[JosephSerpis · Accepted solution]

Hi @Dpharr I came up with one approach on how to tackle this. Let me know what you think?

[Dpharr]

Perfect!

Thank your help

[HomesickSurfer]

Hi @Dpharr 

If you wish to conserve canvas space, runtime...or merely uncomfortable with RegEx, you may wish to use 2 formulas:

1)  Remove all whitespace

2)  Insert single space at 4th character position in the string