Formatting Formula or Regex

[Christion5]

Trying to figure out a formula or regex that will add a space to an ID number before a certain letter/ letter pattern.

Example: 1234AABC -> 1234 AABC

                      1234567AABC -> 1234567 AABC

(Where a space is put before every "AA")

[atcodedog05 · Accepted solution]

Hi @Christion5 

The normal replace function like below should work.

Replace([Field],"AA"," AA")

Replace "AA" to " AA" with space in before. Regex method would be just complicating it.

Hope this helps : )

[Christina_H]

With the field named ID you can use:

Replace([ID], "AA", " AA")

[Christion5]

Thanks! I forgot all about the replace function.