Simple Search with RegEx Question

Questions & Suggestions
1

Apparel & Fashion · United States · 10001+ employees · $6.20 billion revenue

This is the text I'm working with. It's the same format every time ( ex. Industry · Country · Company Size · Revenue ). The exception is sometimes revenue is not included.

I just want to capture the "10001+" in "10001+ employees". How would I do this?

It's actually never a solid number, it's only ranges ( ex. 50-200, 200-500 etc. ) so i could do a if variable contains function for all of them but that's probably not the best way to do it.

How would I capture this with RegEx?

2

Easy enough:
(\d+\+)\h+employees

image

3

Thanks, this works, still trying to understand what does what but I'm getting there.

May I ask a follow up question? somewhat related, think it involves regEx, do you know how I would set up a variable condition based on whether or not there are 2 periods "." in a variable?

4

Please post your question as a new Topic, since it is a much different subject, and provide more details.

1 Like
5

Open up Regex101.com, and enter the RegEx and the source data to see exactly what it does.

1 Like
6

Wow, that link is super helpful, thankyou, was able to solve a couple more things using that