Column delimiter in Excel?

This is a discussion on Column delimiter in Excel? within the C Programming forums, part of the General Programming Boards category; Perhaps an odd question, but I am trying to get my .csv output be separated by columns, and I thought ...

  1. #1
    Registered User
    Join Date
    Oct 2010
    Posts
    15

    Column delimiter in Excel?

    Perhaps an odd question, but I am trying to get my .csv output be separated by columns, and I thought this would be done be a simple Tab ( /t ), but that just leaves a strange ? sign instead and everything will be lumped into the same column.

    The spaces are separated with Tab...
    Code:
     A	  B	  C	 D
    0,0 	-0,0 	23,8 	23,0 
    0,5	-0,0 	23,8 	23,0 
    1,0 	-0,0 	23,7 	23,0
    This is how I am trying to make the output look and I can't find any information on how I can accomplish this. Does anyone have any ideas? Thanks in advance!

  2. #2
    Registered User
    Join Date
    May 2010
    Location
    Naypyidaw
    Posts
    1,314
    Where's the code?

  3. #3
    Jack of many languages Dino's Avatar
    Join Date
    Nov 2007
    Location
    Katy, Texas
    Posts
    2,309
    What file type are you using to store your output data.

    IIRC, I think you can tell Excel what the field delimiters are when importing your data.
    ...
    Yes, I am correct: How to Import a Delimited File into Excel | eHow.com
    Mac and Windows cross platform programmer. Ruby lover.

    Quote of the Day
    12/20: Mario F.:I never was, am not, and never will be, one to shut up in the face of something I think is fundamentally wrong.

    Amen brother!

  4. #4
    Registered User
    Join Date
    Oct 2010
    Posts
    15
    Quote Originally Posted by Dino View Post
    What file type are you using to store your output data.

    IIRC, I think you can tell Excel what the field delimiters are when importing your data.
    ...
    Yes, I am correct: How to Import a Delimited File into Excel | eHow.com
    I just use a .csv filetype to store my output, but I am guessing that I should use .txt and then import it. Thought there was some universal column delimiter for the .csv filetype.

  5. #5
    Jack of many languages Dino's Avatar
    Join Date
    Nov 2007
    Location
    Katy, Texas
    Posts
    2,309
    Commas and semicolons are the two common default separators for a .csv file.
    Comma-separated values - Wikipedia, the free encyclopedia
    Mac and Windows cross platform programmer. Ruby lover.

    Quote of the Day
    12/20: Mario F.:I never was, am not, and never will be, one to shut up in the face of something I think is fundamentally wrong.

    Amen brother!

  6. #6
    Registered User
    Join Date
    Jun 2009
    Posts
    452
    tab is \t not /t

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Programatically setting excel column/header names
    By cStudy in forum C# Programming
    Replies: 10
    Last Post: 03-03-2011, 08:07 AM
  2. Trouble with two two dimensional arrays
    By scmurphy64 in forum C Programming
    Replies: 5
    Last Post: 12-06-2009, 06:57 PM
  3. C++ delete excel column
    By yongzai in forum Windows Programming
    Replies: 0
    Last Post: 06-18-2006, 08:45 PM
  4. Retrieving Multiple inputs with fgets?
    By Axel in forum C Programming
    Replies: 25
    Last Post: 09-13-2005, 05:04 PM
  5. pointers
    By InvariantLoop in forum C Programming
    Replies: 13
    Last Post: 02-04-2005, 09:32 AM

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21