How to add a space between the quarter and year, for example "Q12023" becomes "Q1 2023"

Hi all, beginner here and I'm striking out here trying to figure out the right RegEx formula to do this. I have a bunch of columns that look like the below example and I want to add a space in between the Q# and YYYY.

I've tried using the Formula tool with "REGEX_Replace([Name], '(\w\d)', '($1) " "') " but that isn't doing anything. Any advice?

Example input:

Q12023

Q22023

Q32023

Desired output:

Q1 2023

Q2 2023

Q3 2023

Regex

Accepted answers

binu_acs

@cslagle005 using the Regex_Replace function

Quarter_300523.yxmd

All comments

binu_acs

@cslagle005 This can be achieved with the help of the Left() and Right() functions

Quarter_300523.yxmd

binu_acs

@cslagle005 using the Regex_Replace function

Quarter_300523.yxmd

alexnajm

@cslagle005 try this RegEx instead: REGEX_Replace([Name], "(\w\d)(\d{4})", "$1 $2")

cslagle005

Thanks all, I really appreciate all your replies!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703