generate code in BOM based on the component's properties

[Guest]

hello all,

As a question,
I need to generate a code for each component based on the value, footrpint and part number in BOM. for example, for the resistance 10 ohm , case 0805 and part number 6620, the code is R.10R.0805.6620 or for the capacitance 220pf case 0603 and part number 65489 the code is C.220p.0603.65489.

Is it possible to define a variable in the BOM to generate this code automatically from the properties of the components?

[robertferanec]

I am not sure if you can do it in BOM, but it should be possible to make this directly in excel - as an additional column created based on existing columns.