AnsweredAssumed Answered

How to reformat NAICS codes

Question asked by greenecon on Apr 19, 2018
Latest reply on Apr 19, 2018 by beverly

I have imported thousands of records of businesses with NAICS codes. They range in length from 2 to 6 numbers. I have sorted some key info by the codes, but the list is too long. I want to create a new field where all NAICS codes are limited to the first three, and, if there is only two numbers, It should add a 0 to the end, so that it won't read as 011. It should read as 110 if the code is 11.  I have NO idea how to do this. I saw a post for shortening numbers, but can't see how to add the 0 to the end of two digit numbers.

 

If you wonder, why three numbers, two are too broad for the research we're doing, 6 way to narrow.

 

Thanks, Tana

Outcomes