Help with regex please

How to?
#1

I am trying to pull car engine sizes from various websites which is working great but the different websites have the engine sizes in different formats, so 1 website will state the car engine size as "1600 cc" and another will have "1.6L" for the same engine size.

I want the scraped output as cc but I am struggling to find a regex to help me?

For example in my data I need the following:

1 > 1000
1.2 > 1200
1.6 > 1600
2 > 2000

But I've no idea how to do it, I can remove the "." but then I'm left with 1, 12, 16, 2 etc...

#2

@raindrop Hello, you can isolate such values in 2 separate columns(containing a dot (.) and not containing a dot).

Later you can append 2 or 3 additional zeros and replace the dot using the 'Parser' within Web Scraper Cloud.

Learn more: