RegEx not working as wanted

Hi

I am trying to get the following RegEx output

I have tried the RegEX tool using following expression: \u{3}_(\w+)_(\d{8})\.*\s\w+_\w{2}:\s(\d{5})\.*. Unfortunately, unsuccessful. Can someone pls help?

Many thanks,

RegEx Query.xlsx

Regex

Accepted answers

You can use the following regex expression.

\u{3}_([^_]+).*?(\d{8}).*?(\d{5})

The ? is a lazy character that means it will form the smallest string until it finds \d{8} or \d{5}. The second case guarantees it will get the first 5 numbers from your string.

Best,

Fernando V.

All comments

You can use the following regex expression.

\u{3}_([^_]+).*?(\d{8}).*?(\d{5})

The ? is a lazy character that means it will form the smallest string until it finds \d{8} or \d{5}. The second case guarantees it will get the first 5 numbers from your string.

Best,

Fernando V.

Beautiful! It works. can you please explain this expression: ([^_]+)

Many thanks.

Quick Links

Tags

This months top contributors

AkimasaKajitani 389

Hollingsworth 335