Extract numbers before and after a string

[astro90]

Hi,

I am sitting with thousands of descriptions, and I am trying to extract a certain attribute value of the descriptions. 

The problem is that they are very long, and are not identical.. so the attribute value will either come in the end or beginning of the description.

Example: 

Inkl. AVM FRITZ!Powerline 1240E Starter SetGeschwindigkeit: 450 Mbit/sWLAN: 802.11 a/b/g/nLAN: 4x 10/100 Mbit/s EthernetSicherheit: WPS, WPA2

I am looking to get all Mbit numerical values out.

They differentiate in the way they are written.. so it could be Mb M/bit, Mbit/s etc.

I am having a hard time trying to get the data.. more simple? If that makes sense.

I have been looking abit at RegEx.. and also tried to see if Text to Columns would be a way out.

Any ideas? Or maybe which direction I could take with this? 

Sorry if it sounds like a stupid question.

Thank you in advance! 🙂 

[ChrisTX · Accepted solution]

If you want multiple matches on separate rows, try RegEx with Output Method = Tokenize

This RegEx seems to work with your sample data

.?([0-9]*\/?[0-9]*)\s*Mbit\/s|Mbit|Mb

The web site https://regex101.com/ is helpful to test regular expressions.

Chris

[astro90]

Hi Chris,

That was exactly what I was looking for! Thank you so much!!!