Count digit thru expression

[Anonymous]

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

[rwunderlich · Accepted solution]

if(len(Number) = 4 and IsNum(Number), Number,

if(len(Loc) = 4 and IsNum(Loc), Loc

Null()))

-Rob

[Anonymous]

Hi Rob,

I'm not sure why but it gives me '-' on all records.

[Anonymous]

i've already figured it out. the 'Number' field is a string. i converted it to number format and your expression worked! thank you