regex_replace with middle characters

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

Regex

Tips and Tricks

Accepted answers

atcodedog05

Hi @utsarunner981

Try a formula like this.

Workflow:

Hope this helps : )

ABC.yxmd

All comments

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

Hi @utsarunner981

Try a formula like this.

Workflow:

Hope this helps : )

ABC.yxmd

utsarunner981

@atcodedog05 that worked!

atcodedog05

Happy to help : ) @utsarunner981

Cheers and have a nice day!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703