Extracting Specifc data from string

Question

Hi,

I am trying to extract specific values from string, is there

any way to get specific word + preceeding and following characters from a string?

Eg: Column 1:- thisisthebestcommunity

Column 2:- best

Column 3 (Output/answer) :- thebestcomm

Here I am looking out to extract the word 'best' from the string + preceeding 3 letters (the) and following 4 letters (comm) giving me the output as "thebestcomm"

Thanks!!

flying008 · Answer

Hi, @arfaatmemon

FYI.

Spoiler

REGEX_Replace([Txt], '^.*([a-z]{3}' + [Key] + '[a-z]{4}).*$', '$1')

DataNath · Answer

Hey @arfaatmemon, there's a few ways to do this. One of them is using a RegEx tool in Parse mode, with the following expression:

(\w{3}best\w{4})