+ Reply to Thread
Results 1 to 2 of 2

Extra commas at the end of a row after saving to .csv format

  1. #1
    Registered User
    Join Date
    07-23-2019
    Location
    Mississauga
    MS-Off Ver
    13
    Posts
    0

    Question Extra commas at the end of a row after saving to .csv format

    Hello Everyone,

    I am doing an extract of data into an .xls format.
    Then I have to save as to a .csv to convert into a format that can be uploaded onto a web site.
    But... as you can see below the first row has only 3 field but when I SAVE AS to a .csv it adds extra commas
    This is affecting the web site we upload to as the parsing tool cannot read first row with the extra commas.
    The other rows with extra commas are ignored and are not an issue.

    First row after save as to a .csv:
    VER,3.0,266XF,,,,,,,

    need it as:
    VER,3.0,266XF

    I have figured out that the number of columns determines the number of commas in EACH row.
    I have 3 rows. 1st has 3 columns, 2nd has 5 columns of data, and the 3rd has 10 columns of data.
    Based on info from Excel Forum since the 3rd column has 10 columns, when you create the .csv ALL rows will have 10 comma's
    Hence that is why the 1st column has 10 columns of comma's but only the first 3 have data.

    Is there a way around this to stop these extra comma's when saving as a .CSV file?

    our Web application that uploads this .csv file will NOT parse the 1st row with the extra comma's

    Don't want to train our staff to edit and delete the comma's if I can get this done beforehand.

    Is there anything I can do in Excel BEFORE I save as a .csv file to prevent the creation of the extra commas?

    Let me know. thank you.
    Last edited by mw24623; 07-24-2019 at 10:19 AM. Reason: review

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello mw24623,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] taking the extra Commas out of a Concatenate formula
    By jomili in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-22-2017, 12:23 PM
  2. CONCATENATE function and extra commas
    By araistrick in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-02-2015, 09:03 AM
  3. [SOLVED] Export to CSV writes extra 130 lines of commas
    By dubcap01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2015, 05:09 AM
  4. [SOLVED] Remote extra commas from Column
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-21-2014, 08:54 AM
  5. Convert to CSV , extra commas displaying
    By yashu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2013, 08:49 PM
  6. Create CSV without extra Commas
    By naveenkharb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2010, 10:56 AM
  7. Extra trailing commas in exported CSV
    By lucidr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-25-2006, 08:40 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1