pulling specific rows of data

Hi!

Could someone please help me write out the regex expression to pull the specific rows of data in the attached file below ( highlighted) Basically, I'm trying to pull the data starting with "Total ###( 3 digits) ". There are several rows of data starting with "data" but I just want to get the one following by 3 digits and then -. Thanks so much in advance !

example.xlsx

Datasets

Accepted answers

TomWelgemoed

Hi @Wynn ,

For this case I think you can just use (\d+) in the Regex Parse method.

Regards,

Tom

All comments

TomWelgemoed

Hi @Wynn ,

For this case I think you can just use (\d+) in the Regex Parse method.

Regards,

Tom

Wynn

Hi @TomWelgemoed ,

Thank you so much for your help! The solution is great. However, I just have a question for future for reference. What is really the difference between "+" vs *.

In your expression, you used (\d+) instead of (\d*). I'm aware that * means "zero or more" and + means " one or more". Do you mind providing an example to suggest when I should use * instead of + or vice versa? I found this super confusing some time.

Thanks again for your help! Really appreciate this.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703