AnsweredAssumed Answered

Multi-line in BoM table ?

Question asked by Jose Manuel Lozano on Sep 29, 2020
Latest reply on Oct 5, 2020 by Glenn Schroeder

Like • Show 2 Likes2
Comment • 8

Hello everyone!

I have been searching the forum, without any success. I have parts with two custom properties, description in English and in Spanish. I would like to create a BoM table which shows multiline cells, first line with one language and second one with the other, for each component of an assembly. I have tried concatenating both description within a equation, but it results in a single line.

Is there a way insert a new line (that is, a line break) in a equation in tables? If not, there is another way to get this work?

Thanks.

JOHN GEORGE Sep 29, 2020 8:53 AM

Correct Answer

You could use this macro to create a multi line property with "Description" and that will show in your BOM

Check this Macro

You may modify this macro to suit your requirements.

Like this...

Desc1 & Desc2

See the reply in context

No one else had this question

Outcomes

Thomas Voetmann Sep 29, 2020 8:01 AM

How do you make an equation concatenate tow text properties?

Anyway if you put in a chr(13) in your concatenated string it might be interpreted as a new line.

Actions

Jose Manuel Lozano @ Thomas Voetmann on Oct 5, 2020 2:13 AM

It doesn't work, neither char(10),<br>, ALT+010, ALT+0010.

Actions

Kevin Chandler Sep 29, 2020 8:09 AM

Hello,

I don't believe 2 lines is possible.

Perhaps a unique delimiter, such as space-pipe-space ( | ), will suffice:

Kevin

Actions

Wayne Schafer Sep 29, 2020 8:22 AM

You could insert two BOM. One in English and one in Spanish. You just need to setup a bom template for each language.

Actions

Kevin Chandler @ Wayne Schafer on Sep 29, 2020 10:48 AM

Wayne Schafer wrote:

You could insert two BOM. One in English and one in Spanish. You just need to setup a bom template for each language.

Or just another Description column.

Actions

JOHN GEORGE Sep 29, 2020 8:53 AM

You could use this macro to create a multi line property with "Description" and that will show in your BOM

Check this Macro

You may modify this macro to suit your requirements.

Like this...

Desc1 & Desc2

Actions

Jose Manuel Lozano @ JOHN GEORGE on Oct 5, 2020 2:24 AM

Thanks, it worked (I was looking for an easier solution, something input directly in the table, but haven't found anything).

Actions

Glenn Schroeder Oct 5, 2020 7:18 AM

I saw this last week, and vaguely remembered looking into it a while ago, but couldn't figure it out. I just remembered (if you don't want to use a macro for whatever reason).

Enter the two lines of text in a single cell in an Excel table (type the first line, then hit Enter while holding down Alt and type the second line).
Copy this text.
Go to the Properties dialog box in the model and paste the text in the appropriate box. Only the second line will show up. Ignore that.
When this property is referenced in the BOM the text will show as two lines.

Actions

8 Replies

Thomas Voetmann Sep 29, 2020 8:01 AM
Mark Correct
Correct Answer
How do you make an equation concatenate tow text properties?
Anyway if you put in a chr(13) in your concatenated string it might be interpreted as a new line.
Like • Show 1 Like1
Actions
- Jose Manuel Lozano @ Thomas Voetmann on Oct 5, 2020 2:13 AM
  Mark Correct
  Correct Answer
  It doesn't work, neither char(10),<br>, ALT+010, ALT+0010.
  Like • Show 0 Likes0
  Actions
Kevin Chandler Sep 29, 2020 8:09 AM
Mark Correct
Correct Answer
Hello,

I don't believe 2 lines is possible.
Perhaps a unique delimiter, such as space-pipe-space ( | ), will suffice:

Kevin
Like • Show 1 Like1
Actions
Wayne Schafer Sep 29, 2020 8:22 AM
Mark Correct
Correct Answer
You could insert two BOM. One in English and one in Spanish. You just need to setup a bom template for each language.
Like • Show 3 Likes3
Actions
- Kevin Chandler @ Wayne Schafer on Sep 29, 2020 10:48 AM
  Mark Correct
  Correct Answer
  Wayne Schafer wrote:
  
  You could insert two BOM. One in English and one in Spanish. You just need to setup a bom template for each language.
  Or just another Description column.
  Like • Show 2 Likes2
  Actions
JOHN GEORGE Sep 29, 2020 8:53 AM
Unmark Correct
Correct Answer
You could use this macro to create a multi line property with "Description" and that will show in your BOM
Check this Macro
You may modify this macro to suit your requirements.

Like this...
Desc1 & Desc2
Like • Show 3 Likes3
Actions
- Jose Manuel Lozano @ JOHN GEORGE on Oct 5, 2020 2:24 AM
  Mark Correct
  Correct Answer
  Thanks, it worked (I was looking for an easier solution, something input directly in the table, but haven't found anything).
  Like • Show 0 Likes0
  Actions
Glenn Schroeder Oct 5, 2020 7:18 AM
Mark Correct
Correct Answer
I saw this last week, and vaguely remembered looking into it a while ago, but couldn't figure it out. I just remembered (if you don't want to use a macro for whatever reason).
1. Enter the two lines of text in a single cell in an Excel table (type the first line, then hit Enter while holding down Alt and type the second line).
2. Copy this text.
3. Go to the Properties dialog box in the model and paste the text in the appropriate box. Only the second line will show up. Ignore that.
4. When this property is referenced in the BOM the text will show as two lines.
Like • Show 0 Likes0
Actions

Multi-line in BoM table ?

Outcomes

Related Content

Recommended Content