+ Post New Thread
Results 1 to 5 of 5
Office Software Thread, Open Office trouble with csv files in Technical; Hi I am having trouble with open office saving file as csv, I end up with extra commars which corrupts ...
  1. #1

    Join Date
    Mar 2010
    Location
    UK
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Open Office trouble with csv files

    Hi I am having trouble with open office saving file as csv, I end up with extra commars which corrupts the database. It works ok in excell but the machine I am using only has open office. Thanks for any advice

  2. #2

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,156
    Thank Post
    115
    Thanked 528 Times in 451 Posts
    Blog Entries
    2
    Rep Power
    124
    Can you post an example of what you mean? Are you getting extra commas at the end of each line or commas duplicated

    eg
    cat,dog,fish,snake,,,
    or
    cat,,dog,,fish,,snake

    or something completely different?

  3. #3

    Join Date
    Mar 2010
    Location
    UK
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hello Srochford thanks for reply

    eg
    cat,dog,fish,snake,,,

    Thats the problem exactly its inserting extra commars at the end of a line.

    This seems to be where I have text in quotation marks

  4. #4

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,156
    Thank Post
    115
    Thanked 528 Times in 451 Posts
    Blog Entries
    2
    Rep Power
    124
    OK; often this is because the program thinks you have data in columns that are actually empty.

    To confirm this, can you try highlighting just the data you want and copying and pasting it into a new sheet. Save that as CSV and see what you get.

    the thing I've seen cause this before is if I've had stuff in (say) columns A-F and I then highlight columns E and F and press delete. This clears the content but leaves those 2 columns as part of the data set. When you export you get the extra commas because it hitnks that you want the empty cells (perfectly valid to have blank entries in lots of databases!)

  5. #5

    Join Date
    Mar 2010
    Location
    UK
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    OK will try that, thanks for your help

SHARE:
+ Post New Thread

Similar Threads

  1. CMIS/CSV/CTF files
    By jcs808 in forum MIS Systems
    Replies: 12
    Last Post: 11th March 2010, 08:48 AM
  2. CSV to individual text files
    By DanW in forum Scripts
    Replies: 14
    Last Post: 15th September 2009, 11:28 AM
  3. Problem trying to open graphics on an Open Office odt file
    By speckytecky in forum Office Software
    Replies: 2
    Last Post: 15th May 2009, 08:50 PM
  4. Batch convert Open Office to MS Office?
    By adhutton in forum Office Software
    Replies: 5
    Last Post: 25th March 2009, 12:14 PM
  5. [MS Office - 2007] Office '07 Graphics Printing Trouble
    By new-2-this in forum Office Software
    Replies: 2
    Last Post: 16th May 2008, 05:43 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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