pvision
Well-known member
Quite a few BOMs here are text files, not spreadsheets. I don't know why
I am looking for a way to convert the variable-size columns from the text files to a tab-delimited file suitable for import into a spreadsheet. I think this can be done with Grep in something like BBEdit, but my brain can't wrap itself round the logic of Grep. IMHO this kind of thing is what the GUI and the Macintosh were invented for
Any suggestions for turning this kind of file into something useful?
1 1N914 DIODE CR1
2 FDH333 DIODE HIGH CONDUCTANCE CR2,CR3 DO NOT SUBSTITUTE
1 1N4740A ZENER CR6 10V
4 1N4003 RECTIFIER CR7,CR8,CR9,CR10
2 2N5457 TRANSISTOR FET Q1,Q11
4 2N3391 TRANSISTOR BIPOLAR Q2,Q3,Q4,Q14
7 2N3707 TRANSISTOR BIPOLAR Q5,Q7,Q8,Q9,Q10,Q12,Q13 Q7-Q10 HFE >250;Q12-Q13 MATCHED
1 2N3053 TRANSISTOR BIPOLAR Q6 USE TO-5 HEATSINK
1 270R RESISTOR 1/4 WATT R4
2 27k RESISTOR 1/4 WATT R5,R28
2 2.2M RESISTOR 1/4 WATT R6,R7
3 1k RESISTOR 1/4 WATT R8,R81,R82
1 560k RESISTOR 1/4 WATT R9
4 10k RESISTOR 1/4 WATT R10,R31,R35,R66
1 82 RESISTOR 1/4 WATT R11
1 920 RESISTOR 1/4 WATT R12
2 1M RESISTOR 1/4 WATT R13,R36
1 22k RESISTOR 1/4 WATT R14
2 6.8k RESISTOR 1/4 WATT R15,R17
1 3.6k RESISTOR 1/4 WATT R16 ON METER BOARD
3 180 RESISTOR 1/4 WATT R18,R50,R84
2 68k RESISTOR 1/4 WATT R19,R26 R19 RATIO BOARD
3 56k RESISTOR 1/4 WATT R20,R21,R78 R78 RATIO BOARD
5 47k RESISTOR 1/4 WATT R22,R38,R46,R52,R53
1 250k POTENTIOMETER R23 AUDIO TAPER
3 2.7M RESISTOR 1/4 WATT R24,R25,R74
6 1.5k RESISTOR 1/4 WATT R27,R63,R64,R68,R69,R72 R63 RATIO BOARD
1 1.2M RESISTOR 1/4 WATT R29
1 150k RESISTOR 1/4 WATT R30
1 39R RESISTOR 1/4 WATT R32
2 560R RESISTOR 1/4 WATT R33,R62
3 8.2k RESISTOR 1/4 WATT R34,R76,R77
1 470k RESISTOR 1/4 WATT R37
Bonus points, of course, for recognising the BOM
Nick Froome
I am looking for a way to convert the variable-size columns from the text files to a tab-delimited file suitable for import into a spreadsheet. I think this can be done with Grep in something like BBEdit, but my brain can't wrap itself round the logic of Grep. IMHO this kind of thing is what the GUI and the Macintosh were invented for
Any suggestions for turning this kind of file into something useful?
1 1N914 DIODE CR1
2 FDH333 DIODE HIGH CONDUCTANCE CR2,CR3 DO NOT SUBSTITUTE
1 1N4740A ZENER CR6 10V
4 1N4003 RECTIFIER CR7,CR8,CR9,CR10
2 2N5457 TRANSISTOR FET Q1,Q11
4 2N3391 TRANSISTOR BIPOLAR Q2,Q3,Q4,Q14
7 2N3707 TRANSISTOR BIPOLAR Q5,Q7,Q8,Q9,Q10,Q12,Q13 Q7-Q10 HFE >250;Q12-Q13 MATCHED
1 2N3053 TRANSISTOR BIPOLAR Q6 USE TO-5 HEATSINK
1 270R RESISTOR 1/4 WATT R4
2 27k RESISTOR 1/4 WATT R5,R28
2 2.2M RESISTOR 1/4 WATT R6,R7
3 1k RESISTOR 1/4 WATT R8,R81,R82
1 560k RESISTOR 1/4 WATT R9
4 10k RESISTOR 1/4 WATT R10,R31,R35,R66
1 82 RESISTOR 1/4 WATT R11
1 920 RESISTOR 1/4 WATT R12
2 1M RESISTOR 1/4 WATT R13,R36
1 22k RESISTOR 1/4 WATT R14
2 6.8k RESISTOR 1/4 WATT R15,R17
1 3.6k RESISTOR 1/4 WATT R16 ON METER BOARD
3 180 RESISTOR 1/4 WATT R18,R50,R84
2 68k RESISTOR 1/4 WATT R19,R26 R19 RATIO BOARD
3 56k RESISTOR 1/4 WATT R20,R21,R78 R78 RATIO BOARD
5 47k RESISTOR 1/4 WATT R22,R38,R46,R52,R53
1 250k POTENTIOMETER R23 AUDIO TAPER
3 2.7M RESISTOR 1/4 WATT R24,R25,R74
6 1.5k RESISTOR 1/4 WATT R27,R63,R64,R68,R69,R72 R63 RATIO BOARD
1 1.2M RESISTOR 1/4 WATT R29
1 150k RESISTOR 1/4 WATT R30
1 39R RESISTOR 1/4 WATT R32
2 560R RESISTOR 1/4 WATT R33,R62
3 8.2k RESISTOR 1/4 WATT R34,R76,R77
1 470k RESISTOR 1/4 WATT R37
Bonus points, of course, for recognising the BOM
Nick Froome