Identify text wildcard

Question

Hello,

I would like to identify text in my raw data as a wildcard that will match text in a find replace. Please see example below:

Raw Text 1*/buildsamplesite.com/*/locator*

Raw Text 2samplesite.com/sample/buildsamplesite.com/page1/locator/nysamplesite.com/web/build samplesite.com/build samplesite.com/web/locator/njsamplesite.com/load/locator/pa

Output

*/build samplesite.com/sample/build*/build samplesite.com/web/build */build samplesite.com/build samplesite.com/*/locator*samplesite.com/page1/locator/nysamplesite.com/*/locator*samplesite.com/web/locator/njsamplesite.com/*/locator*samplesite.com/load/locator/pa

Thanks for the help!

grossal · Accepted Answer

Hi @SergioWW,

that's a nice problem and here is a way to solve it!

Let's explain what happens:

1) Select Tool

You probably won't need this, but the Text Input tool reduces the Data length of the text to the minimal length.

2) Formula Tool

We need to make this a proper Regex-Expression, that's why we replace the * with .*

3) Append Fields

Let's build all possible combinations of both rows

4) Filter

We filter the data with a Regex_Match expression saying "[Raw Text 2] needs to fulfill the regex from [Raw Text 1]".

I'll attach the workflow. Let me know if this is what you are looking for 😃

Best

Alex