AnsweredAssumed Answered

Combining custom property strings in SW BOM

Question asked by Tony Brodie on Apr 24, 2007
Latest reply on Apr 29, 2008 by Bob Anderson

Like • Show 0 Likes0
Comment • 7

Hi,

Is it possible to combine two custom property strings so they are shown in the same column in a SW BOM? i.e. Custom Property 1 = "Bearing" and Custom Property 2 = "Roller, 6101". Can these be shown in the one column as "Bearing Roller,6101"?

Looked through SW help regarding equations and BOMs. Found information on creating equations for numeric values but not strings. Tried a few ways such as using & and + to combine strings with no luck.

Cheers,

Tony Brodie

No one else has this question

Outcomes

7 Replies

Sven-Erik Nilsson Apr 24, 2007 5:27 AM
Mark Correct
Correct Answer
For Column properties, select Equation and in the Equation box type
$PRP:"Property1" $PRP:"Property2"
Don't use the equation editor.
Like • Show 0 Likes0
Actions
- Tony Brodie @ Sven-Erik Nilsson on Apr 24, 2007 6:08 AM
  Mark Correct
  Correct Answer
  Thanks it worked a treat...very well.
  Like • Show 0 Likes0
  Actions
  - Greg Van Arsdale @ Tony Brodie on May 16, 2007 4:20 PM
    Mark Correct
    Correct Answer
    Here's how we do it, and we don't get bothered with word potential wrapping issues:
    
    1. create a custom file property called Combined_Description
    
    2. Create a BOM template that has a column labeled description, but actually calls for the Combined_Description.
    
    3. Create a text file (wordpad) that simply lists the 2 parent custom file properties on the first 2 lines....
    
    $PRP:"Description_1"
    $PRP:"Description_2"
    
    I keep mine on my desktop, and it is the first file I open each morning, I highlight the text, edit-copy, then minimize the file.
    
    4. Back in SW, add the Combined_Description custom file property, and click in the Value/Text Expression cell, and Control+V. It will look like there is only one line of text in there, but they are both present.
    
    5. Insert your BOM template into your assembly drawing, and there it is !
    
    Have fun !
    
    Greg
    Like • Show 0 Likes0
    Actions
    - Francis Tanguay @ Greg Van Arsdale on Feb 28, 2008 7:25 PM
      Mark Correct
      Correct Answer
      Hi,
      
      Can you see what's wrong here ?
      I dont want to see the "=" in the equation result.
      Is it possible ?
      
      Im using SW2008 SP3.
      
      Thank you
      
      Francis
      Attachments
      BOM3.jpg40.6 KB
      Like • Show 0 Likes0
      Actions
      - Greg Van Arsdale @ Francis Tanguay on Feb 29, 2008 11:46 AM
        Mark Correct
        Correct Answer
        Hi Francis,
        Don't use an equation unless you need to perform mathmatical operations.
        Just create a custom property that strings together 2 or more other existing properties.
        Then set your BOM column to call for the combined custom property.
        We do this because we have an MRP/ERP coded description, and a human language description that our customers can understand.
        This method works nicely.
        Have FUN!
        Greg
        Like • Show 0 Likes0
        Actions
Alessandro Frattini Mar 6, 2008 9:43 PM
Mark Correct
Correct Answer
See this post
https://forum.solidworks.com/forum/messageview.cfm?catid=21&threadid=6973&highlight_key=y

Alessandro
Like • Show 0 Likes0
Actions
Bob Anderson Apr 29, 2008 1:28 PM
Mark Correct
Correct Answer
Just use the equation editor selecting the field names, using {} in the middle to join the fields.

Ex: `Description_1` {} `Description_2`
Like • Show 0 Likes0
Actions

Combining custom property strings in SW BOM

Outcomes

Attachments

Related Content

Recommended Content