Stats

  • Locked Locked
  • Replies 0
  • Subscribers 164
  • Views 854
  • Members are here 0
More Content
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Fix BOM output that has multiple [ENTER's]

vicvicvar

Hi Forum,

Exporting the BOM from a project, outputs the file with a lot of spread 'New Lines' 

Attached a portion of the BOM 

How can I fix it without going though each component and build them again?

Bill Of Materials          April 25,2017      20:31:46
Item Description Quantity Reference Value PCB Footprint Option Manufacturer Manufacturer Part Number
______________________________________________
1 CAP SM 1206 100uF 20% 6.3V X5R MONOLITHIC CERAMIC 27 C1,C479,C480,C481,C482,C483,C484,C496,C497,C498,C499,C900,C901,C902,C903,C904,C905,C930,C931,C932,C933,C941,C942,C943,C944,C945,C946 100U 1206 MURATA GRM31CR60J107ME39D
2 CAP SM 0805 10uF 10% 10V X7R MONOLITHIC CERAMIC 5 C8,C442,C443,C456,C457 10U 805 MURATA GRM21BR71A106KE51L
3 CAP SM 0402 2.2nF (2200pF) 10% 50V X7R MONOLITHIC CERAMIC 64 C9,C10,C11,C12,C13,C14,C15,C16,C17,C18,C19,C20,C21,C22,C23,C24,C25,C26,C27,C28,C29,C30,C31,C32,C33,C34,C35,C36,C37,C38,C39,C40,C41,C42,C43,C44,C45,C46,C47,C48,C49,C50,C51,C52,C53,C54,C55,C56,C57,C58,C59,C60,C61,C62,C63,C64,C65,C66,C67,C68,C69,C70,C71,C72 0.22uF 402 Murata GRM155R61A224KE19D
4 CAP SM 0402 0.1uF 10% 16V X7R MONOLITHIC CERAMIC 55 C73,C74,C80,C81,C82,C83,C87,C88,C89,C90,C94,C95,C96,C97,C101,C102,C108,C109,C127,C128,C129,C132,C133,C134,C135,C136,C137,C138,C141,C148,C152,C153,C154,C155,C156,C157,C161,C162,C163,C164,C165,C168,C169,C170,C171,C172,C173,C174,C191,C192,C193,C203,C204,C219,C220 0U1 CS-0402 MURATA GRM155R71C104KA88D
5 CAP SM 0402 0.1uF 10% 16V X7R MONOLITHIC CERAMIC 65 C75,C76,C77,C78,C79,C84,C85,C86,C91,C92,C93,C98,C99,C100,C103,C104,C105,C106,C107,C110,C111,C112,C113,C114,C130,C131,C139,C142,C143,C144,C145,C146,C147,C149,C150,C151,C175,C176,C177,C178,C179,C180,C181,C182,C183,C184,C194,C195,C196,C197,C198,C199,C200,C205,C206,C207,C208,C209,C210,C211,C212,C221,C222,C223,C224 0U1 CS-0402 DNI MURATA GRM155R71C104KA88D
6 CAP SM 1206 100uF 20% 6.3V X5R MONOLITHIC CERAMIC 4 C122,C124,C140,C158 100U CS-1206 MURATA GRM31CR60J107ME39D
7 CAP SM 1206 100uF 20% 6.3V X5R MONOLITHIC CERAMIC 1 C125 100U CS-1206 DNI MURATA GRM31CR60J107ME39D
8 7 C166,C548,C549,C550,C551,C552,C553 CAPACITOR NON-POL CS-1206 DNI
9 CAP, CER, 0.1UF, 16V, X7R, 10%, SMD, 0402 9 C225,C226,C227,C228,C566,C567,C568,C569,C854 100nF CAPC1005X55N
10 Cap 100nF 16VDC 0402 Ceramic\X7R, RoHS 9 C229,C230,C233,C235,C239,C240,C241,C242,C243 100nF CAPC1005X55N Murata GRM155R71C104KA88
16 CAP SM 0402 1.0uF 20% 10V X5R CERAMIC 3 C287,C295,C297 1U0 402 TDK
C1005X5R1A105M
17 CAP SM 0603 10uF 20% 6.3V X5R MONOLITHIC CERAMIC 2 C302,C304 10U 603 MURATA GRM188R60J106ME47D
18 CAP SM 0402 2.2nF (2200pF) 10% 50V X7R MONOLITHIC CERAMIC 4 C311,C490,C922,C963 2N2 402 MURATA GRM155R71H222KA01D
Cadence Guidelines

Community Guidelines

The Cadence Design Communities support Cadence users and technologists interacting to exchange ideas, news, technical information, and best practices to solve problems and get the most from Cadence technology. The community is open to everyone, and to provide the most value, we require participants to follow our Community Guidelines that facilitate a quality exchange of ideas and information. By accessing, contributing, using or downloading any materials from the site, you agree to be bound by the full Community Guidelines.