Regex

[vorticalbox]

So, I am working on a  script that gets shoes from websites it's all going well but I am trying to get the sizes that are in stock and I have hit a wall

 

I am getting data like this, I only want the 8,8.5 and so on. I just can't get it right

 

 

BLK/BLK/CYEL / 8 - $500.00
BLK/BLK/CYEL / 8.5 - $500.00
BLK/BLK/CYEL / 9 - $500.00
BLK/BLK/CYEL / 9.5 - $500.00
BLK/BLK/CYEL / 10 - $500.00
BLK/BLK/CYEL / 10.5 - $500.00
BLK/BLK/CYEL / 11 - $500.00
BLK/BLK/CYEL / 11.5 - $500.00

I have tried 

 

\b[0-9]{1,2}\.?\b

but this gets all the 00 at the end of the price and catches 10.5 as 10. and 5

[colonel_mortis]

I would recommend a regex with a capturing group, so you can match with the surrounding content but only capture the actual number. Something like

/ (\d{1,2}\.?5?) -

(match "/ ", then capture 1-2 numbers, optionally ".", and optionally "5", then match but don't capture " -").

[zwirek2201]

8 minutes ago, vorticalbox said:

So, I am working on a  script that gets shoes from websites it's all going well but I am trying to get the sizes that are in stock and I have hit a wall

 

I am getting data like this, I only want the 8,8.5 and so on. I just can't get it right

 

 

BLK/BLK/CYEL / 8 - $500.00
BLK/BLK/CYEL / 8.5 - $500.00
BLK/BLK/CYEL / 9 - $500.00
BLK/BLK/CYEL / 9.5 - $500.00
BLK/BLK/CYEL / 10 - $500.00
BLK/BLK/CYEL / 10.5 - $500.00
BLK/BLK/CYEL / 11 - $500.00
BLK/BLK/CYEL / 11.5 - $500.00

I have tried 

 

\b[0-9]{1,2}\.?\b

but this gets all the 00 at the end of the price and catches 10.5 as 10. and 5

Hi,

 

It is going to be quite trickiy distinguishing multiple cases of size formats. I would recommend splitting the string by spaces and just getting the 3rd item. It's not perfect, but the Regex for sizes would be massive. 

[zwirek2201]

26 minutes ago, vorticalbox said:

So, I am working on a  script that gets shoes from websites it's all going well but I am trying to get the sizes that are in stock and I have hit a wall

 

I am getting data like this, I only want the 8,8.5 and so on. I just can't get it right

 

 

BLK/BLK/CYEL / 8 - $500.00
BLK/BLK/CYEL / 8.5 - $500.00
BLK/BLK/CYEL / 9 - $500.00
BLK/BLK/CYEL / 9.5 - $500.00
BLK/BLK/CYEL / 10 - $500.00
BLK/BLK/CYEL / 10.5 - $500.00
BLK/BLK/CYEL / 11 - $500.00
BLK/BLK/CYEL / 11.5 - $500.00

I have tried 

 

\b[0-9]{1,2}\.?\b

but this gets all the 00 at the end of the price and catches 10.5 as 10. and 5

 

5 minutes ago, zwirek2201 said:

Hi,

 

It is going to be quite trickiy distinguishing multiple cases of size formats. I would recommend splitting the string by spaces and just getting the 3rd item. It's not perfect, but the Regex for sizes would be massive. 

Alternatively, you could use following Regex (I completely missed spaces in strings):

 

( \d+.?\d? )

 

Remember to trim spaces at the beggining and end.

[vorticalbox]

1 minute ago, zwirek2201 said:

It is going to be quite trickiy distinguishing multiple cases of size formats. I would recommend splitting the string by spaces and just getting the 3rd item. It's not perfect, but the Regex for sizes would be massive. 

The string is different every time, so it may not by the 3rd item every single time

[leodaniel]

I would use following regex

\/\s(1?\d.?\d?)\s-\s

starts by / followed by space

captures leading 1 (optional) followed by any number, then optional . and optional number

ends with space - space

 

https://repl.it/KUpk/5