Data extraction of multiple line attributes

[RevJim1]

Hi,

I have created a simple block library, the vast majority of these blocks have a "Part number" attribute, I then use the data extraction wizard to create a sort of parts list. Generally this works fine.

However, I have a couple of blocks that consist of 3 part numbers, I made the "Part_Number" attribute multi-line so I could add the 3 part numbers.

When these are extracted, the excel cell contains the 3 part numbers separated by "/P"

I would like the general format of the data to be :-

12345 qty 6

23456 qty 6

34567 qty 6

Instead of the 12345/P23456/P34567 qty 6 I am currently getting.

Is there a way to do this within Autocad, or do I have to resort to an Excel macro? (I have little experience in this).

Thanks,Rev

[vinodkl]

Hello @RevJim1 

I haven't extracted multiple lines attributes using data extraction until now and now I do see it doesn't add up \P. But a workaround would be to first place the table in AutoCAD and then export the table using the command "TABLEEXPORT ". I tested it on my end and it came up as expected. I hope this helps you 🙂

Excel exported directly from dataextraction

Table exported using the command "TABLEEXPORT"