cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

BILL OF MATTERIAL (BOM)

ptc-2127864
1-Newbie

BILL OF MATTERIAL (BOM)

I have a parametric BOM in the drawing file where in a single row i need to form 2 row of a single sentence. i tried a lot to wrap the sentence in a single row but it didnot work can anyone tell me is there any procedure to wrap it whithin a single row. Regards Abhaya
This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.
7 REPLIES 7

abhaya, What do you mean exactly? If it's some long sentence parameter for each BOM item, I don't think there's any way to easily deal with this, but if you mean some kind of one-time header information, you can easily divide your sentence into two pieces, make a "tall" cell with two lines of entered text, and/or merge cells. Depends on what you are trying to do. You could use string parameter logic to divide a sentence, but that could get pretty cumbersome. David

David, Thanks again for giving answer what i actually wanted is that i want to make 2 sentence in single block of the BOM without merging any other row. (I have a big description of a part )so can i do that. Regards Abhaya

abhaya, I don't see how this can be done automatically for each part in the BOM. Of course, such two-line text can be entered manually into a cell, but I don't think that's what you are looking for. David

Abayha, This seems like a feature that should be available, I am having the same problem I have to shrink the text so small for the description that it can't be read! Regards, Scott

Try something like the following (add as relations to repeat region) :

2Line Bom table.jpg

NUM = rpt_qty

IF EXISTS ("ASM_MBR_BULK_ITEM")

IF EXISTS ("ASM_MBR_DASH")

IF ASM_MBR_DASH == YES

NUM = "-"

ELSE

IF ASM_MBR_BULK_ITEM == YES

NUM = "AR"

else

NUM = rpt_qty

ENDIF

ENDIF

ELSE

IF ASM_MBR_BULK_ITEM == YES

NUM = "AR"

else

NUM = rpt_qty

ENDIF

ENDIF

ELSE

IF EXISTS ("ASM_MBR_DASH")

IF ASM_MBR_DASH == YES

NUM = "-"

else

NUM = rpt_qty

ENDIF

ENDIF

ENDIF

partnox = string_length(asm_mbr_part_no)

partno1= asm_mbr_part_no

partno2= ""

if partnox > 18

endlen1 = ceil(partnox/2)

endlen2 = endlen1 + 1

endlen3 = floor(partnox/2)

partno1 = extract(asm_mbr_part_no,1,endlen1)

partno2 = extract(asm_mbr_part_no,endlen2,endlen3)

endif

spec = string_length(asm_mbr_specification)

spec1= asm_mbr_specification

spec2= ""

if spec > 18

spec_18 = extract(asm_mbr_specification,18,1)

if spec_18 == " "

endlen = spec-18

spec1=extract(asm_mbr_specification,1,17)

spec2=extract(asm_mbr_specification,19,endlen)

else

spec_17 = extract(asm_mbr_specification,17,1)

if spec_17 == " "

endlen = spec-17

spec1=extract(asm_mbr_specification,1,16)

spec2=extract(asm_mbr_specification,18,endlen)

else

spec_16 = extract(asm_mbr_specification,16,1)

if spec_16 == " "

endlen = spec-16

spec1=extract(asm_mbr_specification,1,15)

spec2=extract(asm_mbr_specification,17,endlen)

else

spec_15 = extract(asm_mbr_specification,15,1)

if spec_15 == " "

endlen = spec-15

spec1=extract(asm_mbr_specification,1,14)

spec2=extract(asm_mbr_specification,16,endlen)

else

spec_14 = extract(asm_mbr_specification,14,1)

if spec_14 == " "

endlen = spec-14

spec1=extract(asm_mbr_specification,1,13)

spec2=extract(asm_mbr_specification,15,endlen)

else

spec_13 = extract(asm_mbr_specification,13,1)

if spec_13 == " "

endlen = spec-13

spec1=extract(asm_mbr_specification,1,12)

spec2=extract(asm_mbr_specification,14,endlen)

else

spec_12 = extract(asm_mbr_specification,12,1)

if spec_12 == " "

endlen = spec-12

spec1=extract(asm_mbr_specification,1,11)

spec2=extract(asm_mbr_specification,13,endlen)

else

spec_11 = extract(asm_mbr_specification,11,1)

if spec_11 == " "

endlen = spec-11

spec1=extract(asm_mbr_specification,1,10)

spec2=extract(asm_mbr_specification,12,endlen)

else

spec_10 = extract(asm_mbr_specification,10,1)

if spec_10 == " "

endlen = spec-10

spec1=extract(asm_mbr_specification,1,9)

spec2=extract(asm_mbr_specification,11,endlen)

else

spec_9 = extract(asm_mbr_specification,9,1)

if spec_9 == " "

endlen = spec-9

spec1=extract(asm_mbr_specification,1,8)

spec2=extract(asm_mbr_specification,10,endlen)

else

spec_8 = extract(asm_mbr_specification,8,1)

if spec_8 == " "

endlen = spec-8

spec1=extract(asm_mbr_specification,1,7)

spec2=extract(asm_mbr_specification,9,endlen)

else

spec_7 = extract(asm_mbr_specification,7,1)

if spec_7 == " "

endlen = spec-7

spec1=extract(asm_mbr_specification,1,6)

spec2=extract(asm_mbr_specification,8,endlen)

else

spec_6 = extract(asm_mbr_specification,6,1)

if spec_6 == " "

endlen = spec-6

spec1=extract(asm_mbr_specification,1,5)

spec2=extract(asm_mbr_specification,7,endlen)

else

spec_5 = extract(asm_mbr_specification,5,1)

if spec_5 == " "

endlen = spec-5

spec1=extract(asm_mbr_specification,1,4)

spec2=extract(asm_mbr_specification,6,endlen)

else

spec_4 = extract(asm_mbr_specification,4,1)

if spec_4 == " "

endlen = spec-4

spec1=extract(asm_mbr_specification,1,3)

spec2=extract(asm_mbr_specification,5,endlen)

else

spec_3 = extract(asm_mbr_specification,3,1)

if spec_3 == " "

endlen = spec-3

spec1=extract(asm_mbr_specification,1,2)

spec2=extract(asm_mbr_specification,4,endlen)

else

spec_2 = extract(asm_mbr_specification,2,1)

if spec_2 == " "

endlen = spec-2

spec1=extract(asm_mbr_specification,1,1)

spec2=extract(asm_mbr_specification,3,endlen)

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

desc = string_length(asm_mbr_description)

desc1 = asm_mbr_description

desc2 = ""

if desc > 20

desc_20 = extract(asm_mbr_description,20,1)

if desc_20 == " "

endleng =desc-20

desc1=extract(asm_mbr_description,1,19)

desc2=extract(asm_mbr_description,21,endleng)

else

desc_19 = extract(asm_mbr_description,19,1)

if desc_19 == " "

endleng =desc-19

desc1=extract(asm_mbr_description,1,18)

desc2=extract(asm_mbr_description,20,endleng)

else

desc_18 = extract(asm_mbr_description,18,1)

if desc_18 == " "

endleng =desc-18

desc1=extract(asm_mbr_description,1,17)

desc2=extract(asm_mbr_description,19,endleng)

else

desc_17 = extract(asm_mbr_description,17,1)

if desc_17 == " "

endleng =desc-17

desc1=extract(asm_mbr_description,1,16)

desc2=extract(asm_mbr_description,18,endleng)

else

desc_16 = extract(asm_mbr_description,16,1)

if desc_16 == " "

endleng =desc-16

desc1=extract(asm_mbr_description,1,15)

desc2=extract(asm_mbr_description,17,endleng)

else

desc_15 = extract(asm_mbr_description,15,1)

if desc_15 == " "

endleng =desc-15

desc1=extract(asm_mbr_description,1,14)

desc2=extract(asm_mbr_description,16,endleng)

else

desc_14 = extract(asm_mbr_description,14,1)

if desc_14 == " "

endleng =desc-14

desc1=extract(asm_mbr_description,1,13)

desc2=extract(asm_mbr_description,15,endleng)

else

desc_13 = extract(asm_mbr_description,13,1)

if desc_13 == " "

endleng =desc-13

desc1=extract(asm_mbr_description,1,12)

desc2=extract(asm_mbr_description,14,endleng)

else

desc_12 = extract(asm_mbr_description,12,1)

if desc_12 == " "

endleng =desc-12

desc1=extract(asm_mbr_description,1,11)

desc2=extract(asm_mbr_description,13,endleng)

else

desc_11 = extract(asm_mbr_description,11,1)

if desc_11 == " "

endleng =desc-11

desc1=extract(asm_mbr_description,1,10)

desc2=extract(asm_mbr_description,12,endleng)

else

desc_10 = extract(asm_mbr_description,10,1)

if desc_10 == " "

endleng =desc-10

desc1=extract(asm_mbr_description,1,9)

desc2=extract(asm_mbr_description,11,endleng)

else

desc_9 = extract(asm_mbr_description,9,1)

if desc_9 == " "

endleng =desc-9

desc1=extract(asm_mbr_description,1,8)

desc2=extract(asm_mbr_description,10,endleng)

else

desc_8 = extract(asm_mbr_description,8,1)

if desc_8 == " "

endleng =desc-8

desc1=extract(asm_mbr_description,1,7)

desc2=extract(asm_mbr_description,9,endleng)

else

desc_7 = extract(asm_mbr_description,7,1)

if desc_7 == " "

endleng =desc-7

desc1=extract(asm_mbr_description,1,6)

desc2=extract(asm_mbr_description,8,endleng)

else

desc_6 = extract(asm_mbr_description,6,1)

if desc_6 == " "

endleng =desc-6

desc1=extract(asm_mbr_description,1,5)

desc2=extract(asm_mbr_description,7,endleng)

else

desc_5 = extract(asm_mbr_description,5,1)

if desc_5 == " "

endleng =desc-5

desc1=extract(asm_mbr_description,1,4)

desc2=extract(asm_mbr_description,6,endleng)

else

desc_4 = extract(asm_mbr_description,4,1)

if desc_4 == " "

endleng =desc-4

desc1=extract(asm_mbr_description,1,3)

desc2=extract(asm_mbr_description,5,endleng)

else

desc_3 = extract(asm_mbr_description,3,1)

if desc_3 == " "

endleng =desc-3

desc1=extract(asm_mbr_description,1,2)

desc2=extract(asm_mbr_description,4,endleng)

else

desc_2 = extract(asm_mbr_description,2,1)

if desc_2 == " "

endleng =desc-2

desc1=extract(asm_mbr_description,1,1)

desc2=extract(asm_mbr_description,3,endleng)

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

matl = string_length(asm_mbr_material)

matl1 = asm_mbr_material

matl2 = ""

if matl > 16

matl_16 = extract(asm_mbr_material,16,1)

if matl_16 == " "

endleng =matl-16

matl1=extract(asm_mbr_material,1,15)

matl2=extract(asm_mbr_material,17,endleng)

else

matl_15 = extract(asm_mbr_material,15,1)

if matl_15 == " "

endleng =matl-15

matl1=extract(asm_mbr_material,1,14)

matl2=extract(asm_mbr_material,16,endleng)

else

matl_14 = extract(asm_mbr_material,14,1)

if matl_14 == " "

endleng =matl-14

matl1=extract(asm_mbr_material,1,13)

matl2=extract(asm_mbr_material,15,endleng)

else

matl_13 = extract(asm_mbr_material,13,1)

if matl_13 == " "

endleng =matl-13

matl1=extract(asm_mbr_material,1,12)

matl2=extract(asm_mbr_material,14,endleng)

else

matl_12 = extract(asm_mbr_material,12,1)

if matl_12 == " "

endleng =matl-12

matl1=extract(asm_mbr_material,1,11)

matl2=extract(asm_mbr_material,13,endleng)

else

matl_11 = extract(asm_mbr_material,11,1)

if matl_11 == " "

endleng =matl-11

matl1=extract(asm_mbr_material,1,10)

matl2=extract(asm_mbr_material,12,endleng)

else

matl_10 = extract(asm_mbr_material,10,1)

if matl_10 == " "

endleng =matl-10

matl1=extract(asm_mbr_material,1,9)

matl2=extract(asm_mbr_material,11,endleng)

else

matl_9 = extract(asm_mbr_material,9,1)

if matl_9 == " "

endleng =matl-9

matl1=extract(asm_mbr_material,1,8)

matl2=extract(asm_mbr_material,10,endleng)

else

matl_8 = extract(asm_mbr_material,8,1)

if matl_8 == " "

endleng =matl-8

matl1=extract(asm_mbr_material,1,7)

matl2=extract(asm_mbr_material,9,endleng)

else

matl_7 = extract(asm_mbr_material,7,1)

if matl_7 == " "

endleng =matl-7

matl1=extract(asm_mbr_material,1,6)

matl2=extract(asm_mbr_material,8,endleng)

else

matl_6 = extract(asm_mbr_description,6,1)

if matl_6 == " "

endleng =matl-6

matl1=extract(asm_mbr_material,1,5)

matl2=extract(asm_mbr_material,7,endleng)

else

matl_5 = extract(asm_mbr_material,5,1)

if matl_5 == " "

endleng =matl-5

matl1=extract(asm_mbr_material,1,4)

matl2=extract(asm_mbr_material,6,endleng)

else

matl_4 = extract(asm_mbr_material,4,1)

if desc_4 == " "

endleng =matl-4

matl1=extract(asm_mbr_material,1,3)

desc2=extract(asm_mbr_material,5,endleng)

else

matl_3 = extract(asm_mbr_material,3,1)

if matl_3 == " "

endleng =matl-3

matl1=extract(asm_mbr_material,1,2)

matl2=extract(asm_mbr_material,4,endleng)

else

matl_2 = extract(asm_mbr_material,2,1)

if matl_2 == " "

endleng =matl-2

matl1=extract(asm_mbr_material,1,1)

matl2=extract(asm_mbr_material,3,endleng)

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

endif

One can only wrap the Title. The repeat region parameters cannot be wrapped. I have not tried with relations. I normally export as csv file and then paste it as an Excel file. This is a long standing request, I believe is available in Creo 2.0.

It is available in Creo 2.0 !

Announcements