Altium BOM CSV Export: Remove Double Quotes and Change Separator to Pipe (|)

[electronx]

Hi everyone,

When I export a BOM (Bill of Materials) as a CSV file from Altium Designer, all the values are enclosed in double quotation marks (" "), and the separator is a comma (,).

I would like to export the BOM CSV without double quotes around the values, and use a pipe (|) as the separator instead of a comma.

Is there a way to configure these export options directly in Altium Designer?

If not, what’s the most efficient way to convert the exported BOM CSV to my desired format?

Any tips, scripts, or recommended tools would be greatly appreciated!

Thanks in advance.

[thm_w]

CSV format is comma separated, so I don't think Altium is going to change that.

A python script or excel script is probably the easiest way, ask AI to generate:
- remove any " character
- replace any , symbol with |

[HumbleDeer]

The above, with regex ^

Although I'm super curious whatfor you need this data in said format.

[Relaxe]

Get Notepad++
https://notepad-plus-plus.org/downloads/

Under Search -> Find (CTRL-F) -> Replace, you have all the imaginable options.

[free_electron]

CSV : Comma separated value. It has commas .
The reason for the double quotes is to enabled nested commas.

Example : 5,"Top,Bottom","0805Y2k2R,TMP08052rt","R1,R2,R9,R11,R14"

- 5 resistors ( no quotes )
- nested block layers : "top,bottom"
- nested block  manufacturer part numbers "mpn1,mpn2,...mpnx"
- nested block designators. "x,y,...,z"

That is how CSV works. Has nothing to do with Altium.

[kite31]

I am also curious to know why you want to do this, and how you plan to handle nesting?

To do it, for a one off use regex or an editor with adequate replace tools. If this sort of thing is a general requirement look at Easy Data Transform, which will also expand nesting easily.