how to get required data form different criteria?

[#1]

Dear Experts,

                 In my description column, I would like to pick up the ref no: but these are not the same format. I would like to know how to get the required ref: no?

Best Regards,

Kyaw Myo Tun

[qlikmsg4u]

Hi Kyaw,

Try this

LOAD Date,

     ID,

     DESCRIPTION,

     AMOUNT,

     F5,

     KeepChar(DESCRIPTION,'0123456789') as [NEW DESCRIPTION]

FROM Source;

[#3]

Dear K N,

            it work well for the situation but I made a mistake in my excel. The ref no: is not only contain digit but also character. (eg....13050ABC1002). how can i get that data?

Best Regards,

Kyaw Myo Tun

[qlikmsg4u]

Please post sample data containing mixed text

[#5]

Dear K N,

        

Best Regards,

Kyaw Myo Tun

[qlikmsg4u · Accepted solution]

I tried something like this, but this may not the feasible solution and also it will fail if there were symbols other than the used ones in script, i will look into some more solutions

LOAD Date,

     ID,

     DESCRIPTION,

     AMOUNT,

     F5,

     Subfield(Replace(DESCRIPTION,':','-'),'-',2) as [NEW DESCRIPTION]

FROM

Source

[#7]

Hi,

This will help u to complete u r task.

keepchar is a string function it will help to separate text and string values

KeepChar(DESCRIPTION,'0123456789') as Newdata

Thanks and regards,

Balaji.k

[#8]

Dear K N,

             It work correctly for my purpose. Thanks for your help.

Best Regards,

Kyaw Myo Tun