I read on a forum how to make a phone number come back in a particular format using the following:
concat("(", substring(translate(., "()-. ", ""), 1, 3), ") ", substring(translate(., "()-. ", ""), 4, 3), "-", substring(translate(., "()-. ", ""), 7, 4))
My problem is that I dont understand this and more so , I need to do it for a zipcode as well. To make a long story short, I want to understand it and I would like some help by explaining how i can do the above from scratch for Zipcodes...and maybe emails. Thanks