Author Topic: Question for Lee Mac - Global Attribute Extractor & Editor  (Read 1590 times)

0 Members and 1 Guest are viewing this topic.

notredave

  • Newt
  • Posts: 140
Question for Lee Mac - Global Attribute Extractor & Editor
« on: January 23, 2020, 02:40:33 PM »
Good afternoon all,

I have a question for Lee Mac or if anyone else can help, it would be appreciated. I just love Lee's Global Attribute Extractor & Editor. But there is a problem I am encountering. I am using the extractor portion of program. I have a lot of drawings that have a 0 (zero) in front of revision attribute tag and when it extracts to excel, the leading 0 (zero) does not display. I am doing a huge drawing index and have extracted the line titles of description, which works perfect but when it comes to putting the revision on drawing index, I have to open each drawing because I don't know if the true revision is "01" or "1" in drawing's title block, for an example. Excel on displays "1". Is there a setting in excel that will show the leading zero if it was in the drawing attribute tag that I was exporting? Any help would be greatly appreciated.

Thank you,
David

MP

  • Seagull
  • Posts: 17750
  • Have thousands of dwgs to process? Contact me.
Re: Question for Lee Mac - Global Attribute Extractor & Editor
« Reply #1 on: January 23, 2020, 02:55:23 PM »
Concatenate applicable strings with a leading single quote (ascii code 39).
Engineering Technologist • CAD Automation Practitioner
Automation ▸ Design ▸ Drafting ▸ Document Control ▸ Client
cadanalyst@gmail.comhttp://cadanalyst.slack.comhttp://linkedin.com/in/cadanalyst

notredave

  • Newt
  • Posts: 140
Re: Question for Lee Mac - Global Attribute Extractor & Editor
« Reply #2 on: January 23, 2020, 03:13:50 PM »
Thank you for the reply MP but I don't have a clue what you said or meant, lol....sorry

MP

  • Seagull
  • Posts: 17750
  • Have thousands of dwgs to process? Contact me.
Re: Question for Lee Mac - Global Attribute Extractor & Editor
« Reply #3 on: January 23, 2020, 03:23:47 PM »
When in excel if you prefix any numerical value with a single quote, e.g. '01, it will interpret it as left justified text rather than a number.

If you import a csv file into excel (data -> import from text file -> select csv file) you can specify the data format for any or all fields (columns). If you select the "TEXT" type for a given field it will accept the values as is, e.g. 01 rather than converting to an integer.

Other fires abound; cheers.
Engineering Technologist • CAD Automation Practitioner
Automation ▸ Design ▸ Drafting ▸ Document Control ▸ Client
cadanalyst@gmail.comhttp://cadanalyst.slack.comhttp://linkedin.com/in/cadanalyst