I have a zip code data in text file coming from conversion of excel to text file, and I want to check if the country is USA then add trailing zeros in the zip code if it is less than 5 digits.
FYI - you can’t take the length as a criteria, as according to the requirements the zip code is hard coded to take 6 spaces(rest goes blank if the code is less than 6)
Example : In excel -
Country : USA
zip : 457
Result in text file:
Country : USA
Zip : 00457(space)