Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
schumi1980
Contributor III
Contributor III

30 Days to 30

Hi All

I have data, "PaymentPeriod" coded as '30 days' or '43 days'.

How can I load this data so that I only get 30 or 43.

If I know the content I would do it like this:

if(Wildmatch(PaymentPeriod,'*30*'),30, if(...))

However, I will have many payment periods. The approach above is not feasible. Is there a function that recognizes the number part of the data element which helps me to extract this part?

Many thanks.

Jan

1 Solution

Accepted Solutions
shiveshsingh
Master
Master

Try KeepChar(StrName, Chr you want to extract)

View solution in original post

2 Replies
shiveshsingh
Master
Master

Try KeepChar(StrName, Chr you want to extract)

sasiparupudi1
Master III
Master III

If(Keepchar(PaymentPeriod,'0123456789')=30