Jump to content

Search the Community

Showing results for tags 'concatenate'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Announcements
    • Announcements
    • News You Need
    • Job Board
  • Feedback
    • Roadmap
    • Wishlist - Feature and Content Requests
    • Known Issues
    • Wishes Granted / Issues Resolved
    • Forum Feedback
  • General
    • Troubleshooting
    • General Discussion
    • Architecture
    • Site Design
    • Entertainment
    • Vision and Previsualization
    • Braceworks
    • ConnectCAD
    • Energos
    • Rendering
    • Workflows
    • Buying and Selling Vectorworks Licenses
    • Hardware
  • Customization
    • AI Visualizer
    • Marionette
    • Vectorscript
    • Python Scripting
    • SDK
    • 3rd Party Services, Products and Events
    • Data Tags
  • Solids Modeling and 3D Printing
    • Subdivision
    • Solids Modeling
    • 3D Printing
  • Vectorworks in Action
  • Archive
    • Resource Sharing
    • Machine Design

Calendars

  • Training Events
  • Coffee Breaks
  • Essentials Seminars
  • Webinars
  • Community Groups

Categories

  • Knowledgebase
    • Tech Bulletins
    • Troubleshooting
    • Workflows
    • How To
    • FAQs

Categories

  • Marionette - Objects
  • Marionette - Networks
  • Marionette - Nodes
  • Marionette - Menu Commands

Product Groups

There are no results to display.


Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Occupation


Homepage


Hobbies


Location


Skype

Found 3 results

  1. 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.
  2. 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.
  3. 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...
×
×
  • Create New...