I just finished migration some Land Desktop Desc Keys into Civil 3D 2007. I went to test it, and the file that I tried to import had the raw descriptions in mixed case. Some caps, some not....
That causes problems since Desc Keys are case sensitive.
A quick way to change the case of any list is to open the file in Excel. Excel will open a .txt file and it understands delimiting by comma or space.
Make a column next to the mixed case column and use this formula :
For example, to turn the code "ep" into "EP" and "ep" lives in cell A1, I would make a formula that said
=UPPER(A1) and it will return "EP"
Great way to fix those accidental field errors.
Sunday, June 04, 2006
Posted by Dana at 8:50:00 PM