Regex: find only numbers in a string

Question

I have a string

K9908098F, G2342D34324/ 234234323, 234-234-234; R324234

How to catch only 234234323 and 234-234-234 in VBA?

This [\d-]+ pattern grabs extra pieces

Rahul Desai · Accepted Answer · 2018-04-20 04:32:34Z

1

You are pretty close, just need to add borders: \b[\d-]+\b

Regex demo and explanation

edited Apr 20, 2018 at 4:32

answered Apr 20, 2018 at 4:26

Rahul Desai

15.5k20 gold badges89 silver badges146 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

builder-7000 · Accepted Answer · 2018-04-20 04:23:38Z

0

Give this a try:

(\w+),\s+([\w-]+);

This will capture 234234323 in group 1 and 234-234-234 in group 2.

answered Apr 20, 2018 at 4:23

builder-7000

7,7183 gold badges26 silver badges45 bronze badges

Comments

Reck · Accepted Answer · 2018-04-20 04:29:18Z

0

Not too elegant though but would work. Just a small addition to your regex.

[\d-]+[,;]

answered Apr 20, 2018 at 4:29

Reck

1,43612 silver badges20 bronze badges

Comments

Thm Lee · Accepted Answer · 2018-04-20 04:31:41Z

0

You can try this too,

[-\d]+(?=[;,. ])

Demo

answered Apr 20, 2018 at 4:31

Thm Lee

1,2361 gold badge9 silver badges12 bronze badges

Collectives™ on Stack Overflow

Regex: find only numbers in a string

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related