Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I write this thru expression?
if 'number' has 4 digit, copy 'number'
if 'number' is not 4 digit, copy 'Loc' that is 4 digit else nul()
Number Loc Desired result
0021 AU 0021
35697 NZ -
PH 1234 1234
if(len(Number) = 4 and IsNum(Number), Number,
if(len(Loc) = 4 and IsNum(Loc), Loc
Null()))
-Rob
if(len(Number) = 4 and IsNum(Number), Number,
if(len(Loc) = 4 and IsNum(Loc), Loc
Null()))
-Rob
Hi Rob,
I'm not sure why but it gives me '-' on all records.
i've already figured it out. the 'Number' field is a string. i converted it to number format and your expression worked! thank you