element14 Community
element14 Community
    Register Log In
  • Site
  • Search
  • Log In Register
  • Community Hub
    Community Hub
    • What's New on element14
    • Feedback and Support
    • Benefits of Membership
    • Personal Blogs
    • Members Area
    • Achievement Levels
  • Learn
    Learn
    • Ask an Expert
    • eBooks
    • element14 presents
    • Learning Center
    • Tech Spotlight
    • STEM Academy
    • Webinars, Training and Events
    • Learning Groups
  • Technologies
    Technologies
    • 3D Printing
    • FPGA
    • Industrial Automation
    • Internet of Things
    • Power & Energy
    • Sensors
    • Technology Groups
  • Challenges & Projects
    Challenges & Projects
    • Design Challenges
    • element14 presents Projects
    • Project14
    • Arduino Projects
    • Raspberry Pi Projects
    • Project Groups
  • Products
    Products
    • Arduino
    • Avnet Boards Community
    • Dev Tools
    • Manufacturers
    • Multicomp Pro
    • Product Groups
    • Raspberry Pi
    • RoadTests & Reviews
  • Store
    Store
    • Visit Your Store
    • Choose another store...
      • Europe
      •  Austria (German)
      •  Belgium (Dutch, French)
      •  Bulgaria (Bulgarian)
      •  Czech Republic (Czech)
      •  Denmark (Danish)
      •  Estonia (Estonian)
      •  Finland (Finnish)
      •  France (French)
      •  Germany (German)
      •  Hungary (Hungarian)
      •  Ireland
      •  Israel
      •  Italy (Italian)
      •  Latvia (Latvian)
      •  
      •  Lithuania (Lithuanian)
      •  Netherlands (Dutch)
      •  Norway (Norwegian)
      •  Poland (Polish)
      •  Portugal (Portuguese)
      •  Romania (Romanian)
      •  Russia (Russian)
      •  Slovakia (Slovak)
      •  Slovenia (Slovenian)
      •  Spain (Spanish)
      •  Sweden (Swedish)
      •  Switzerland(German, French)
      •  Turkey (Turkish)
      •  United Kingdom
      • Asia Pacific
      •  Australia
      •  China
      •  Hong Kong
      •  India
      •  Korea (Korean)
      •  Malaysia
      •  New Zealand
      •  Philippines
      •  Singapore
      •  Taiwan
      •  Thailand (Thai)
      • Americas
      •  Brazil (Portuguese)
      •  Canada
      •  Mexico (Spanish)
      •  United States
      Can't find the country/region you're looking for? Visit our export site or find a local distributor.
  • Translate
  • Profile
  • Settings
Autodesk EAGLE
  • Products
  • More
Autodesk EAGLE
EAGLE User Chat (English) Why does exporting the BOM as CSV use semi-colons instead of commas?
  • Blog
  • Forum
  • Documents
  • Events
  • Polls
  • Files
  • Members
  • Mentions
  • Sub-Groups
  • Tags
  • More
  • Cancel
  • New
Join Autodesk EAGLE to participate - click to join for free!
Actions
  • Share
  • More
  • Cancel
Forum Thread Details
  • Replies 5 replies
  • Subscribers 174 subscribers
  • Views 1670 views
  • Users 0 members are here
  • eagle
  • bom
Related

Why does exporting the BOM as CSV use semi-colons instead of commas?

Former Member
Former Member over 11 years ago

Unless I'm missing something, it appears cadsoft doesn't understand that CSV stands for "comma-separated values." When I export the BOM choosing the output format as CSV, Eagle outputs a file that uses semi-colons as field separators instead of commas. What the heck?!

 

The problem is that I need to be able to open the BOM in Excel. Currently this means after exporting the BOM, I have to open it in a text editor and use search & replace to change all of the semi-colons to commas.

 

Am I missing something?

  • Sign in to reply
  • Cancel

Top Replies

  • autodeskguest
    autodeskguest over 11 years ago +1
    Am 16.05.2014 00:46, schrieb RoboticsGuy: Unless I'm missing something, it appears cadsoft doesn't understand that CSV stands for "comma-separated values." When I export the BOM choosing the output format…
  • autodeskguest
    autodeskguest over 11 years ago

    On 15/05/14 23:46, RoboticsGuy wrote:

    Unless I'm missing something, it appears cadsoft doesn't understand that

    CSV stands for "comma-separated values." When I export the BOM choosing

    the output format as CSV, Eagle outputs a file that uses semi-colons as

    field separators instead of commas. What the heck?!

     

    This is normal and correct. The CSV format is actually "character

    separated" where the character can be one of a number of common

    punctuation symbols. In many European locales, for example, the comma

    character is used as the decimal point, so it couldn't possibly be a

    field separator. Thus semicolon is the commonly used separator. A lot of

    software will do this depending on your OS locale settings.

     

    The problem is that I need to be able to open the BOM in Excel.

     

    That's not a problem

     

    Currently this means after exporting the BOM, I have to open it in a

    text editor and use search & replace to change all of the semi-colons to

    commas.

     

    No, it doesn't. Excel is quite capable of opening a semicolon-separated

    file, provided you employ the necessary runes. Not being a regular Excel

    user I can't remember the details (and in any case Microsoft insist on

    changing those sort of things with every version). I know how to do it

    in OpenOffice, which basically just offers the dialog box every time -

    you untick "comma" and tick "semicolon" instead.

     

     

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • autodeskguest
    autodeskguest over 11 years ago

    Am 16.05.2014 00:46, schrieb RoboticsGuy:

    Unless I'm missing something, it appears cadsoft doesn't understand that

    CSV stands for "comma-separated values." When I export the BOM choosing

    the output format as CSV, Eagle outputs a file that uses semi-colons as

    field separators instead of commas. What the heck?!

     

    The problem is that I need to be able to open the BOM in Excel.

    Currently this means after exporting the BOM, I have to open it in a

    text editor and use search & replace to change all of the semi-colons to

    commas.

     

    Am I missing something?

     

    --

    Hello

    if you open the Bom.ulp in a texteditor, you find in the line 45

     

    char   Separator = ';'; // 2012-12-04

     

    so you can chose your own character.

    May be '\t' as Tab or ',' as your favorite.

     

    HTH

    Werner

     

     

    • Cancel
    • Vote Up +1 Vote Down
    • Sign in to reply
    • Cancel
  • Former Member
    Former Member over 11 years ago in reply to autodeskguest

    Thanks, I'll give that a try!

     

    Also, just for the record, it is not easy to import a semi-colon delimited file into Excel (at least not the North America version). If you Google it, you'll find lots of people asking how to do it and the answers are never simple (almost all that I read involved opening the file in a text editor and adding something like delimiter=; to the top).

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • audiomodder
    audiomodder over 7 years ago in reply to autodeskguest

    "Hello

    if you open the Bom.ulp in a texteditor, you find in the line 45

     

    char   Separator = ';'; // 2012-12-04

     

    so you can chose your own character.

    May be '\t' as Tab or ',' as your favorite.

     

    HTH

    Werner"

     

    You, sir, saved my life and I love you for it image

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • thommaughan
    thommaughan over 6 years ago in reply to audiomodder

    Just a note to autodesk - google sheets has the same import problem as excel.   i've been manually creating the BOM for the generated csv and text file for years.     the mod to the bom.ulp shown above is great, thanks!

     

    I don't know if I did the mod correctly on the BOM.ulp as the import was still quite broken.  Playing around in the latest (Sep 2018) excel, there is a box that says "tell me what you want to do"  and I put import text/csv and it and some weird magic happened, a new dialog popped up that looked good on columns! I then hit load and the import looked good!

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
element14 Community

element14 is the first online community specifically for engineers. Connect with your peers and get expert answers to your questions.

  • Members
  • Learn
  • Technologies
  • Challenges & Projects
  • Products
  • Store
  • About Us
  • Feedback & Support
  • FAQs
  • Terms of Use
  • Privacy Policy
  • Legal and Copyright Notices
  • Sitemap
  • Cookies

An Avnet Company © 2025 Premier Farnell Limited. All Rights Reserved.

Premier Farnell Ltd, registered in England and Wales (no 00876412), registered office: Farnell House, Forge Lane, Leeds LS12 2NE.

ICP 备案号 10220084.

Follow element14

  • X
  • Facebook
  • linkedin
  • YouTube