topic Re: Filter Text and Aphanumeric values from a field in QlikView

Filter Text and Aphanumeric values from a field

qlikwiz123 — Sat, 16 Nov 2024 18:20:45 GMT

Hi, I have a field similar to

Data

------

ABC

ABC (V645)

DHFE

Corporate

AWS (A598234)

Stock

BCC (V10)

How do I separate Text and Alphanumeric values into two different fields in the script?

I tried IsNum and Istext but they did not work

Re: Filter Text and Aphanumeric values from a field

Kushal_Chawda — Fri, 17 Jul 2020 22:10:04 GMT

Data: Load *, if(not isnum(if(len(trim(KeepChar(Field,'0123456789')))>0,KeepChar(Field,'0123456789'))) and istext(if(len(trim(KeepChar(Field,'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ')))>0, KeepChar(Field,'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ'))),Field) as Text, if(isnum(if(len(trim(KeepChar(Field,'0123456789')))>0,KeepChar(Field,'0123456789'))) and istext(if(len(trim(KeepChar(Field,'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ')))>0, KeepChar(Field,'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ'))),Field) as AlphaNumeric Inline [ Field ABC ABC (V645) DHFE Corporate AWS (A598234) Stock BCC (V10) ];

Re: Filter Text and Aphanumeric values from a field

Frank_Hartmann — Sat, 18 Jul 2020 08:32:35 GMT

Data: Load *, if(len(TextBetween(Data,'(',')'))>0,Data,null()) as AN, if(len(TextBetween(Data,'(',')'))=0,Data,null()) as Text; Load * Inline [ Data ABC ABC (V645) DHFE Corporate AWS (A598234) Stock BCC (V10) ];

Re: Filter Text and Aphanumeric values from a field

Brett_Bleess — Wed, 29 Jul 2020 12:56:45 GMT

You have received two responses to your post, we would greatly appreciate it if you would close out the thread by using the Accept as Solution button on the post(s) that helped. If neither did help, please leave an update post on what you still need.

Regards,
Brett