Selecting/Extracting Text Before a Certain Character

Questions and Help
1

Hi TB Community!

Through "read from website" -- What is the correct way to only pick up the characters before the parentheses for these two fields? I am wanting to get rid of my "advice" when sending this to data to Datablaze

And/or what is the way to eliminate whatever is in the parentheses?

image

Thank you :grinning:

2

Hi @ajduna7

You can use the replaceregex function in your formula, for example:

{=replaceregex({site: ...}, "\s+\([^\)]+\)", "")}

Please replace {site: ...} with your site command in your snippet in the above example. I hope that helps you.

1 Like
3

Amazing! That worked perfectly, I had a feeling it had to do with some sort of "regex" command but never would have figured out the rest, Thank you!!

1 Like