Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Search a field and remove the letters

Hi,

I'm trying to remove all the alphabetic characters so that it will leave me with the number from a field.

Eg. field contains "Loaded as of 14/12/2009, status complete" and I am looking for the date.

I have tried using findoneof but I can't seem to be able to get the date from the field.

Am I on the right track here? Does anyone know of a better way to do this?

Any help is much appreciated.
McKay

1 Solution

Accepted Solutions
Not applicable
Author

try

KeepChar( s1 , s2 )

Returns the string s1 less all characters not contained in string s2.

Example:

keepchar ( 'a1b2c3def','1234567890' ) returns '123'

View solution in original post

2 Replies
Not applicable
Author

try

KeepChar( s1 , s2 )

Returns the string s1 less all characters not contained in string s2.

Example:

keepchar ( 'a1b2c3def','1234567890' ) returns '123'

Not applicable
Author

Thanks Alex- got it working