How to identify additional charakters?

[gino2780]

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:

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

[lironbaram]

you can use in the script

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

[gino2780]

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)$]);

[swuehl]

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

[swuehl]

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.