haroldlbgrx.com Posted October 22, 2008 Share Posted October 22, 2008 Hello There, I'm running an addressing job. I have the data file as an excel file. When I started doing the imposition, there was an error coming out relative to bar code. I realized in the zip code column (on the data file) most of the zip codes are composed with a dash sign in between (xxxx-xxx) but there are some zip codes that are missing the dash (xxxx xxxx). How can I fix that error or tell FP to add the dash automatically? Thank You! Link to comment Share on other sites More sharing options...
jshobar Posted October 22, 2008 Share Posted October 22, 2008 hey there... The easiest way might be to fix it in excel, baring that, I would use a function to check the length of the sting. If it's 10 digits, it's zip dash 4. If, it's 5, then let it go through just as the zip. If it's 9 then add the dash into the string (look under string functions). If it's anything else, the zip may be incomplete. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.