Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What kind of script is your query currently running? Is this script evaluating also the regular expression style pattern?
If I understand your question i load a simple query from MS SQL
Maybe like
Purgechar(Words,'0123456789+') like '*:?*-'
Well, I think my previous answer is not correct.
Try with the regular expression connector:
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
];
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