Data Extraction - Don't want to have suffix and width factor in the result

[Anonymous]

I'm facing the problem  when data extracting. Suffix and width factor appear in the result and then the information becomes harder to process. I have created blocks with attributes and fields containing a suffix.(mm, cm, m .. etc)

Also I have added a width factor to some of the attributes.  My question is - is there a way to extract the results as only numbers - no additional information and how I can make this happen?

Please see attached screenshots.

[cadffm]

" I have created blocks with attributes "

You have created blocks with MULTILINEattributes..

But you don't need the multiline-feature, or? Why are you using multiline attributes?

You can to nothing, it is the matt textvalue, dataextract is not designed to do what you want,

but it would be a great idea to fix this issue (hello AutoDESK).

If you don't need matts, re-define your Block and use single-line attributes,

one property of single line attributes are the width also single line text.

[Anonymous]

I use multiline attributes because there are some places I need to use a background fill so the result is visible and easy to read. See attached screenshot.

If this will solve my problem I may change them to single-line attributes. 

And what about the suffix? Can I somehow omit it from the result?

[cadffm]

For suffix the same rule: Is it part of the attribut value...

Dataextract extract the attribut value.

If you don't like the suffix in your result list, remove them from your attribut value.

If we talking about "standard drawings", i mean you need that for many files, many times over the next years and you know all blockames where you like to remove them:

You need that as xls?

In dataextraction you can add more columns from an external excel sheet, so it is possible to get an excelfile with a column with suffix and one column without the suffix.

By using excel formula.

Remove the suffix on excel side as post process looks easier, a short vba macro will do that.

[Anonymous]

Got it. I was just thinking that I might be able to modify the column - like there's an option - don't show the suffix/only number. 

I practically wanted to use it as I need it visually to be there in the drawing. Just wanted to reduce the attributes in one block. 

Yes, I need this in xls so  I can count quantities. I don't need the suffix in xls at all - just in the drawing, I might replace it with simpla annotative text. 

Thank you for your help.