Nested if Script Syntax

[#1]

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

[Clever_Anjos]

I don´t see how "Giltig_flagga" = 0 can be true, you´re comparing  a string to 0, is that?

[#3 · Accepted solution]

it is a flag that by default is 0, or Null.

[Clever_Anjos]

=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