Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I want to mark with a flag if my field "DESC" contain one or more of the next words:
PALABRA |
PRE CORTADA |
PRECORTADA |
CORTE |
DESPERDICIO |
SALDO |
FALLA |
DEFECT |
REPARA |
RETRABAJO |
RE TRABAJO |
COMPOSTURA |
PARTE |
For this im trying to set the next "IF" function:
if("DESC"='%PRE CORTADA%' or "DESC"='%PRECORTADA%' or "DESC"='%CORTE%' or "DESC"='%DESPERDICIO%' or "DESC"='%SALDO%' or "DESC"='%FALLA%'
or "DESC"='%DEFECT%' or "DESC"='%REPARA%' or "DESC"='%RETRABAJO%' or "DESC"='%RE TRABAJO%' or "DESC"='%COMPOSTURA%' or "DESC"='%PARTE%',1,0
) as Recorte
But this is not working 😞
Did someone already did something like this before?
I would appreciate a lot if someone could help me with this.
Regards.
JAAM.
the operator you want is "like". And you probably want to use "*" as the wildcard. So...
"DESC" like '*PRE CORTADA*'
-Rob
the operator you want is "like". And you probably want to use "*" as the wildcard. So...
"DESC" like '*PRE CORTADA*'
-Rob
Thanks for your help Rob, it works too good.
Regards.