Hello,
I cannot figure out why this is not working… Can anyone figure out what I’m doing wrong? Trying to only get the first 5 characters of a zip code, not the remaining -xxxx.
Hello,
I cannot figure out why this is not working… Can anyone figure out what I’m doing wrong? Trying to only get the first 5 characters of a zip code, not the remaining -xxxx.
If you need first five then you need to do substring and not pad
Str.Trim.SubString(0,5)
Cheers
Hi,
Can you try this?
Left(strZip,5)
Regards,
Hi @Anil_G , thank you! This worked!
Hello @Yoichi , thank you! This also worked!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.