Wondering if it is possible to toggle off the " (and I assume ') in generate report. With the " mark in my widths and lengths I cannot easily manipulate the information in my materials estimating spreadsheets (would be nice to copy paste into other spreadsheets for take offs - but math functions ar…

I don’t know as this will be of help to you, but you might want to at least give it a quick read to determine that. Text Import Wizard Although you can’t export to Excel directly from a text file or Word document, you can use the Text Import Wizard in Excel to import data from a text f…

you could nominate a custom attribute say aLenX = lenx and report that.

I found a way to set up a formula to delete characters - so I can somewhat automate this upon importing the CSV into a template - but it is one extra step.

I hoped it might respond to unchecking the checkbox Display Units Format in Model Info/Units. But it doesn’t. And I found it hard to change the Units used. Worked ok if I close the report and restart it when changing from cm to inches, but even doing that didn’t change units from decimal to fractio…

I have looked at building dynamic components with formulas - but there seems to be a glitch - if I push pull a width or a length (timbers, framing members, etc.) - the attributes don’t always update in real time - I have to ‘redraw’ the components - which could create an issue where I don’t get the…

For curiosities sake what did you use to do that? I’d not tried it but assumed I could use “find and replace” in Excel to eliminate the “inches”. But upon trying it some of my fractions convert to dates.

[image] c_j_ryan: But upon trying it some of my fractions convert to dates. Change the formatting of the cells to either numbers or text to avoid them being converted into dates. “Yessir. I’d like a 2x6 that is May 3rd, 1882 long.” :smiley:

I’d actually done that, with formatting the cells before I imported the report, and it didn’t seem to help. But I’ll give it another go because it seems like it should work! Thanks

[image] c_j_ryan: I’d actually done that, with formatting the cells before I imported the report, Do it after you import the report. Otherwise the report changes the formatting of the cells. Proabably best to use Text as the category.

The import comes in fine, whole numbers and fractions, it’s when I try to eliminate the " " ", denotation is when it converts single fractions to dates. I even tried formatting to # ??/??, with no luck.

Generate Report -Turn of " and ' in lengths and widths

SketchUp Pro

MikeWayzovski March 5, 2019, 4:54pm 12

I find that scaling gives you more control then actually editing the geometry.

Scaling an instance makes it a unique component

Splitting fixed sized wood timber frame, into component parts

Topic		Replies	Views
Generate Report - remove inch symbol from output Feature Requests	5	599	April 25, 2021
Text format in .csv report file for Len attribute instead of number Feature Requests sketchup-pro	7	1544	January 12, 2017
Generate report to XLS Dynamic Components generate_report	10	591	June 19, 2024
Generated Reports - CSV format to Integers Only SketchUp	6	1211	September 11, 2017
Generate Report .csv export - remove/separate units from the data Feature Requests export , generate_report , csv	0	978	April 26, 2017

Generate Report -Turn of " and ' in lengths and widths

Related topics