Tab delimited import stripping leading zeros

[TychoGranville]

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

[Samuel_Firmenich]

Thank you for providing this. Exactly what I needed when using Python.

[JoeBryant1]

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.