What filter can I use to convert "$ 60,000 USD" into "60000"?

pachocastillosr

Hi,

I'm receiving some prices through an external api and need to extract the price number.

What is the best way to to convert "$ 60,000 USD" into "60000"?

Thanks!

Pawel Magdanski

So your regex pattern should be in a place of variant_in_clinet_catalog.price

replacement should be left empty

subject should be your variant_in_clinet_catalog.price

Pawel Magdanski

From the top of my head I think I would go with regex_replace and build a regex for everything except numbers and then replace is with nothing.

pachocastillosr

Thanks for replying @Pawel Magdanski , I've tried this (see images below) without success.

What am I doing wrong?

This is the object where I am getting the price from:

This is the regex:

Any help would be appreciated!

Pawel Magdanski

I think there is something wrong with your filter logic, see here:

pachocastillosr

@Pawel Magdanski I saw that but, to be honest, I don't understand it.
I just want to delete every non numeric character, so I left the replacement blank.

Perhaps you could give me a hand here @Michael Udinski?

pachocastillosr

@Pawel Magdanski that worked! Thanks!

Pawel Magdanski

@pachocastillosr Great, happy to help!