Tab delimited import stripping leading zeros

4121
10
Jump to solution
06-15-2021 12:39 PM
TychoGranville
Occasional Contributor II

Hi All,

I have a tab delimited file that I am the using table-to-table tool to bring into Pro. I change one of the fields  to type "text" (since all the records in that field are numbers) before running the tool. Opening the new table in Pro show the field as type text but all the leading zeros have been stripped. Just checked, and I get the same error with ArcMap. I can import the file into Excel and get the correct formatting, I'd like to skip the extra step. Am I doing it wrong, or is this a bug that didn't get fixed in Pro?

Thanks,

Tycho

0 Kudos
10 Replies
JoeBryant1
Occasional Contributor III

Very helpful - I'll have to give it a try. Thanks!

Edit: This worked perfectly. I'll be using and recommending this method going forward.