My data arrives is two different formats:
9999-99-999-9999
and/or
9999999999999
1. How can I check to see which format it is arriving in?
2. Based off the format that it arrives in, be able to appen 0's to those particular records that dont fill all the way (i.e. 123456, or 1234-56)
Thanks in Advance.
J. Turner