30 Days to 30

[schumi1980]

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

[shiveshsingh · Accepted solution]

Try KeepChar(StrName, Chr you want to extract)

[sasiparupudi1]

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