script in query to script Qlik

[zied_ahmed1]

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]

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

[zied_ahmed1]

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

[swuehl]

Maybe like

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

[swuehl]

Well, I think my previous answer is not correct.

Try with the regular expression connector:

https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Connectors_QWC/Data-So...

[swuehl]

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]

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