Hi guys! Need help with the saved search formula. We have customers that are missing a leading zero in their zip code. Their zip codes were accidently uploaded with 4 digits instead of 5 because the zero-s got erased when the Excel file was closed during the CSV update. What saved search formula can I use to find customers whose zip codes consist of 4 digits?

message has been deleted

Thank you so much, Gregory! This is super helpful and the formula worked!

No problem!

@Gregory Jones if it's not too much to ask, would you happen to know what formula to use now to add a zero "0" in front of the zip code via NetSuite saved search?

Sure thing - Formula (Text)

'0'||{zipcode}

Wow, that was quick! This worked as well. You are amazing, thanks again!

I had to do these exact same things when we migrated, so I was able to dig up my old saved search. Luckily I didn't delete it.

That makes sense. I also keep all of my saved searches even when I think I will never-ever use them.

Yeah, it's good way to recall tricks and such for current needs!