topic Re: script in query to script Qlik in Management & Governance

script in query to script Qlik

zied_ahmed1 — Thu, 27 Sep 2018 07:59:21 GMT

Hello ,

I have this in a query and i need to put it in script Qlik :

Words like '%:[^0-9+]%-'

how to write it with scripting Qlik

Thanks

swuehl — Thu, 27 Sep 2018 08:11:25 GMT

What kind of script is your query currently running? Is this script evaluating also the regular expression style pattern?

zied_ahmed1 — Thu, 27 Sep 2018 08:14:27 GMT

If I understand your question i load a simple query from MS SQL

swuehl — Thu, 27 Sep 2018 08:25:49 GMT

Maybe like

Purgechar(Words,'0123456789+') like '*:?*-'

swuehl — Thu, 27 Sep 2018 08:34:32 GMT

Well, I think my previous answer is not correct.

Try with the regular expression connector:

swuehl — Thu, 27 Sep 2018 08:48:46 GMT

Or using a MAP to facilitate the exclusion character filter:

MAP:

MAPPING LOAD In, ':1' as Out INLINE [

];

LOAD *,

not MapSubstring('MAP',Words) like '*:1*-' and Words like '*:?*-' as test

INLINE [

Words

Hi2384-

12:1a-

12:a1-

:a1-

:a-

];

zied_ahmed1 — Thu, 27 Sep 2018 08:52:10 GMT

Thank you for answer ,

The problem there is not just Words there is some other fields so i need something like in MS SQL to do it