Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi i would like to run the following script in the backend.
my purpose is to merge the two statements into one field. However my syntax seems to be wrong.
both statements work perfectly fine by themselves.
Any help would be greatly appreciated.
if(len(trim(Orderkund))=9 and isnum(left(trim(Orderkund),4)) and isnum(right(trim(Orderkund),4)),left(Orderkund,4) & '-0000'
or
"Giltig_flagga" = 0, (left("Text 1",9))) as EndCustomer
it is a flag that by default is 0, or Null.
I don´t see how "Giltig_flagga" = 0 can be true, you´re comparing a string to 0, is that?
it is a flag that by default is 0, or Null.
=if(len(trim(Orderkund))=9 and isnum(left(trim(Orderkund),4)) and isnum(right(trim(Orderkund),4)),left(Orderkund,4) & '-0000' or Giltig_flagga = 0, (left('Text 1',9)))
Works here, note that I´m using single quote at 'Text 1' and no quotes at Giltig_flagga