1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: excel file to .csv, trailing comma issue

Discussion in 'Business Applications' started by Akuller, Apr 11, 2006.

Thread Status:
Not open for further replies.
Advertisement
  1. Akuller

    Akuller Thread Starter

    Joined:
    Feb 12, 2004
    Messages:
    117
    Hi,

    I have a spreadsheet that I have linked values to another excel file which is then saved in a .csv format for upload into a price engine. Most all values are correct, except some that have trailing commas. The data contains all the same formatting and I cannot figure out why this is happening. Here's a snapshot of the .csv file. As you can see some have the commas and some don't. Any ideas?

    Thanks
    ak

    JA106LP-L,30,7.000,-2.375
    JA106LP-L,30,6.875,-2.000
    JA106LP-L,30,6.750,-1.750
    JA106LP-L,30,6.625,-1.375
    JA106LP-L,30,6.500,-0.875
    JA106LP-L,30,6.375,-0.375
    JA106LP-L,30,6.250,0.125,,,,,,
    JA106L-L,30,7.000,-1.875,,,,,,
    JA106L-L,31,6.875,-1.500,,,,,,
    JA106L-L,32,6.750,-1.250,,,,,,
    JA106L-L,33,6.625,-0.875,,,,,,
    JA106L-L,34,6.500,-0.375,,,,,,
    JA106L-L,35,6.375,-0.000,,,,,,
    JA106L-L,36,6.250,0.375,,,,,,
    JF30-S,15,6.625,-1.000,,,,,,
    JF30-S,15,6.750,-1.375,,,,,,
    JF30-S,15,6.875,-1.625,,,,,,
    JF30-S,15,7.000,-2.000,,,,,,
    JF30-S,15,7.125,-2.250,,,,,,
    JF30-S,15,7.250,-2.500,,,,,,
     
  2. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
    So for (e.g.)

    JA106LP-L,30,6.250,0.125,,,,,,

    JA106LP-L is in one cell -- 30 is in the next cell, 6.250 in the next, etc?

    Have you tried physically deleting the columns to the right of the four required?
     
  3. Akuller

    Akuller Thread Starter

    Joined:
    Feb 12, 2004
    Messages:
    117
    It worked!!! Any idea why those got placed on certain rows and not on others?

    Thanks so much...

    AK
     
  4. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
    Err ... maybe some cells looked blank but actually had spaces in ... or ... used to have data in & Excel got confused ... or ... err, if it works, don't ask! :D
     
  5. Akuller

    Akuller Thread Starter

    Joined:
    Feb 12, 2004
    Messages:
    117
    I'm with ya, thanks again!
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/458183

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice