AnsweredAssumed Answered

And statment in bom equations

Question asked by Michael McMillan on Oct 3, 2011
Latest reply on Oct 4, 2011 by Deepak Gupta

Like • Show 1 Like1
Comment • 4

Hey you all

I am trying to figure out how to combine two custom properties in one column of the bom. In excel you use an & symbol. I have tried this in SolidWorks and it does not work.

=`DESCRIPTION`&`GRADE`

Thanks in advance for any help

Michael McMillan Oct 4, 2011 9:48 AM

Correct Answer

I got some help on another forum and here is the answer. thank you every one for your help though.

"Quote"

For putting words together, do the same thing but replace the "+" sign with {}. Like this.

`Description`{}`DesignerName`

If you want to add some regular text, just use "".

`Description`{}"Designed By "`DesignerName'

"Quote"

See the reply in context

No one else had this question

Outcomes

Ryan Brumund Oct 3, 2011 3:24 PM

The long hand function for the & symbol is CONCATENATE. You could try =CONCATENATE('DESCRIPTION','GRADE'). Works in Excel and I believe it is a VBA function, haven't actually tried to use it in Solidworks though.

Actions

Michael McMillan @ Ryan Brumund on Oct 3, 2011 3:27 PM

Tryed it, no Go, Thanks for the try though

Actions

Michael McMillan Oct 4, 2011 9:48 AM

I got some help on another forum and here is the answer. thank you every one for your help though.

"Quote"

For putting words together, do the same thing but replace the "+" sign with {}. Like this.

`Description`{}`DesignerName`

If you want to add some regular text, just use "".

`Description`{}"Designed By "`DesignerName'

"Quote"

Actions

Deepak Gupta @ Michael McMillan on Oct 4, 2011 10:15 AM

Thanks for sharing it Michael

Actions

4 Replies

Ryan Brumund Oct 3, 2011 3:24 PM
Mark Correct
Correct Answer
The long hand function for the & symbol is CONCATENATE. You could try =CONCATENATE('DESCRIPTION','GRADE'). Works in Excel and I believe it is a VBA function, haven't actually tried to use it in Solidworks though.
Like • Show 0 Likes0
Actions
- Michael McMillan @ Ryan Brumund on Oct 3, 2011 3:27 PM
  Mark Correct
  Correct Answer
  Tryed it, no Go, Thanks for the try though
  Like • Show 0 Likes0
  Actions
Michael McMillan Oct 4, 2011 9:48 AM
Unmark Correct
Correct Answer
I got some help on another forum and here is the answer. thank you every one for your help though.

"Quote"

For putting words together, do the same thing but replace the "+" sign with {}. Like this.

`Description`{}`DesignerName`

If you want to add some regular text, just use "".

`Description`{}"Designed By "`DesignerName'

"Quote"
Like • Show 0 Likes0
Actions
- Deepak Gupta @ Michael McMillan on Oct 4, 2011 10:15 AM
  Mark Correct
  Correct Answer
  Thanks for sharing it Michael
  Like • Show 0 Likes0
  Actions

And statment in bom equations

Outcomes

Related Content

Recommended Content