Search the Community

I want to shorten and join strings like this 'Coprosma hawera ' that are in a single cell to CopHaw and have them in another worksheet cell. The case would be nice but it's not a must-have. Has anyone solved this. VW screenshot of what I want to see. Excel example enclosed below, but I wouldn't have a clue how to do this in vectorworks.

A big thank you to whomever engineered the Data Tag in Vectorworks 2022. Sitting in a tutorial today and the dreaded question... how do we tag Window Symbols when we have modelled a custom window? It's easy with the data tag! Create a custom 2D/3D Symbol, assign IFC catagory to the Symbol via the Resource Manager, and use the 'IFC Classification' Data Tag - symbol variant. A couple of tweaks and the Data Tag is picking up the 'Tag' value entered into the IfcWindow property set; the same one used by window styles. To demonstrate how the Data Manager works, we then map the 'tag' to 'reference' in Pset_WindowCommon, using a concatentation to floor level (layer) and window tag, via the data manager, set up a data sheet to see only the fields we are interested in in the ifc data structure, thereby streamlining the whole process, and export an IFC to show where the value ends up in an IFC via BIM Collab. The way the Data Manager now helps you define custom values is extraordinarily useful. The fact it tells you off when you get an 'invalid expression' is great! =concat(substring(L,'-'4),'-',IFC.'IfcWindow'.'Tag') ellicites a response of 'Comma expected'! =concat(substring(L,-,4),'-',IFC.'IfcWindow'.'Tag') and it says 'Invalid factor'! With wrist slapped, I try again. Bingo! =concat(substring(L,'-',4),'-',IFC.'IfcWindow'.'Tag') results in '00-W1' and is automatically entered into the 'Reference' field now visible in our 'Window Data Sheet'. All our data is now driven through IFC. Amazing! Things like this makes me happy.

Have looked all over for this to no avail. How do I add manually text to a cell which has data from a function call? So I have a cell B65 that has text in it In cell B91 I have =B$65, which gives me my text: Planting poly How_do_I_add_text_to_the_cell_? update - I've just found that =concat(B$65, ref_to_text_in_Another_Cell) works, but if that cell has nothing in it function returns 0, and adds that to the result Planting poly0 - oh and you've got to put a leading space in your other cell or it joins the result! So does one avoid that 0? Haven't found any manual entry solutions though...