I have two files with a text field set up the same. File A’s field has alphanumeric data, sometimes contains letters, always containing numbers.
When I import the data from File A into File B using:
If the data in File A leads with a zero and has no letters, the leading zero is removed. If the data contains a letter and has a leading zero, the zero is saved.
ie: 028130 imports as 28130
02290P imports as 02290P
I’ve been using this procedure for a year now, and this is the first I’ve noticed this happening. Is this expected behavior and is there a workaround?