regex_replace with middle characters

[utsarunner981]

hi! i've been trying to find something similar in the discussion but have not been successful. im playing with the regex replace formula tool and want to see if i can only get the middle part of a string. 

for example remove the 'DEF'

sample data	output data
ABCDEFG	ABCG
ABCDEFGH	ABCGH
ABCDEFGHI	ABCGHI

thank you

[atcodedog05]

Hi @utsarunner981 

How are you defining it as middle chars?

[utsarunner981]

hi @atcodedog05 - this is the formula i wrote and giving a null. 

REGEX_Replace([Field1], "\w{3}*(\w*)", " ")

[atcodedog05 · Accepted solution]

Hi @utsarunner981 

Try a formula like this.

Workflow:

Hope this helps : )

[utsarunner981]

@atcodedog05  that worked!

[atcodedog05]

Happy to help : ) @utsarunner981 

Cheers and have a nice day!