how to get number from text field?

[#1]

Hello all

I'm new in QV.

here's question. I have field contains country and postal code. Like this:

country:
Japan
Algeria
Mongolia
France Postal 1100-1500 to/from
France Postal 5200-8000 to/from

so on. I need just number where country contains postal code. Is there any function to do this?

Regards
Muncho

[#2 · Accepted solution]

Well that was simple.

keepchar(country,1234567890) as country_postal

Sorry for keep posting newbie questions.