How to extract only number from string

Question

I try to extract the prices from these page as text in USD from this site

I used an locator //span[@data-originalprice] with get text of selenium but still no only numbers, tried also split on \\$ and nothing came tried some regex text.split("^-?\\d*(\\.\\d+)?$") and still nothing. looking for any idea?

Try xpath as ("//span[@data-originalprice]/span[2]")[20] – Rakesh Sep 22 '20 at 18:18 — Rakesh, Sep 22 '20 at 18:18

undetected Selenium · Accepted Answer · 2020-09-22T19:31:57.147

0

To extract and print the prices trimming the non-ASCII characters you can use replaceAll("[^\\p{ASCII}]", "") and using Java8's stream() and map() you can use either of the following Locator Strategies:

cssSelector:

driver.get("https://www.wooloverslondon.com/new-styles?page=1&gender=161&style=77");
System.out.println(new WebDriverWait(driver, 20).until(ExpectedConditions.visibilityOfAllElementsLocatedBy(By.cssSelector("div.associated-product__price p>span"))).stream().map(element->element.getText().replaceAll("[^\\p{ASCII}]", "")).collect(Collectors.toList()));

xpath:

driver.get("https://www.wooloverslondon.com/new-styles?page=1&gender=161&style=77");
System.out.println(new WebDriverWait(driver, 20).until(ExpectedConditions.visibilityOfAllElementsLocatedBy(By.xpath("//div[@class='associated-product__price']//p/span"))).stream().map(element->element.getText().replaceAll("[^\\p{ASCII}]", "")).collect(Collectors.toList()));

Console Output:

[7,035.00, 6,015.00, 6,015.00, 6,015.00, 6,015.00, 6,015.00, 6,015.00, 5,607.00, 5,607.00, 5,607.00, 4,996.00, 7,646.00]

References

You can find a couple of relevant discussions in:

edited Sep 22 '20 at 19:31

answered Sep 22 '20 at 18:56

undetected Selenium

183,867
41
278
352

Thank you, but the problem is that each element text contains non-ASCII charcters so i asked how to extract only the numbers without those non-ASCII charcters – nuzooo Sep 22 '20 at 19:22
@nuzooo Checkout the updated answer and let me know the status. – undetected Selenium Sep 22 '20 at 19:32
1

Thank you , just one more question: i see you reduced all non printable ASCII characters but how did you replace the rupy sign? – nuzooo Sep 22 '20 at 19:39
@nuzooo The rupy sign is a non-ASCII character as well which you wanted to get rid of. – undetected Selenium Sep 22 '20 at 19:42
1

Thank you again you are great – nuzooo Sep 22 '20 at 19:44
@nuzooo Feel free to visit [Selenium Chat Room](https://chat.stackoverflow.com/rooms/223360/selenium) and help other users. – undetected Selenium Oct 20 '20 at 18:24

How to extract only number from string

1 Answers1

References