This section contains reference documentation for the arrayRemoveString function.
Last updated 2 years ago
Was this helpful?
Removes value from array of strings.
arrayRemoveString('colName', value)
These examples are based on the .
select RandomAirports, arrayRemoveString(RandomAirports, 'SEA') AS value from airlineStats WHERE arraylength(RandomAirports) BETWEEN 2 AND 4 limit 5
SEA,PSC
PSC
SEA,PSC,PHX,MSY
PSC,PHX,MSY