Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
you can use in the script
if(wildmatch(Straße,'*/*','*-*')>0,1,0) As IllegalFlag
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)$]);
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
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.