Encontrar en cadena valor numerico

[marisolacostah]

Hello,

I have the following string:

 

'check 1258956  dfrrdd'

'check ssergtt  1258797 '

'1258956  dfrfttf'


I require the numbers that I can find in the string

[jduenyas]

Try this

=PurgeChar(String_name,'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ ')

This will purge all letters and spaces that are in the String_Name.

[MindaugasBacius]

I would you the opposite function:
=KeepChar(FieldName, 0123456789)

Read more about it in:
https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/St...

[jduenyas]

Indeed better solution.

Shorter too...

Thanks