script in query to script Qlik - Qlik Community

zied_ahmed1 · ‎2018-09-27

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 · ‎2018-09-27

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

zied_ahmed1 · ‎2018-09-27

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

swuehl · ‎2018-09-27

Maybe like

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

swuehl · ‎2018-09-27

Well, I think my previous answer is not correct.

Try with the regular expression connector:

swuehl · ‎2018-09-27

Or using a MAP to facilitate the exclusion character filter:

MAP:

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

In

:0

:1

:2

:3

:4

:5

:6

:7

:8

:9

:+

];

LOAD *,

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

INLINE [

Words

Hi2384-

12:1a-

12:a1-

:a1-

:a-

:a

];

zied_ahmed1 · ‎2018-09-27

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