Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gino2780
Contributor

How to identify additional charakters?

Hello,

in my excel-data i have a field (Straße) that contains charakters like: ,  /  +  (  )  =  ^ which are illegit charakters for the specific field (Straße).

The spreadsheet looks like this:

Straße.JPG

Yellow entries are those which i want to identify with my app. So i need a script command that searches in the field (Straße) for those additional characters (row-wise) with an OR-combination: find field entries that have '/' or ',' or '=' etc. ...

How would the complete LOAD script look like?

With kind regards,

Giacinto Abbruzzese

4 Replies
lironbaram
Honored Contributor II

Re: How to identify additional charakters?

you can use in the script

if(wildmatch(Straße,'*/*','*-*')>0,1,0) As IllegalFlag

gino2780
Contributor

Re: How to identify additional charakters?

How would the whole script command look like?

For example, this variant is not working:

LOAD

if(wildmatch(Straße,'*/*','*-*')>0,1,0) as IllegalFlag,

FROM [lib://DQM/20150925_Auszug DQM-Sicht.xls]
(biff, embedded labels, table is [owssvr (9)$]);

MVP
MVP

Re: How to identify additional charakters?

You can also use some other string functions:

If( Len(KeepChar( [Straße], ',/+()=^'), 1,0 ) as IllegalFlag

If (FindOneOf( [Straße], ',/+()=^'), 1,0 ) as IllegalFlag

MVP
MVP

Re: How to identify additional charakters?

Giacinto Abbruzzese wrote:

How would the whole script command look like?

For example, this variant is not working:

LOAD

if(wildmatch(Straße,'*/*','*-*')>0,1,0) as IllegalFlag,

FROM [lib://DQM/20150925_Auszug DQM-Sicht.xls]
(biff, embedded labels, table is [owssvr (9)$]);

Remove the comma after the last field name in your LOAD statement, IllegalFlag.