Thread: Column delimiter in Excel?

  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
    Chappell Hill, Texas
    Posts
    2,332
    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
    Mainframe assembler programmer by trade. C coder when I can.

  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
    Chappell Hill, Texas
    Posts
    2,332
    Commas and semicolons are the two common default separators for a .csv file.
    Comma-separated values - Wikipedia, the free encyclopedia
    Mainframe assembler programmer by trade. C coder when I can.

  6. #6
    Registered User
    Join Date
    Jun 2009
    Posts
    486
    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, 07:45 PM
  4. Retrieving Multiple inputs with fgets?
    By Axel in forum C Programming
    Replies: 25
    Last Post: 09-13-2005, 04:04 PM
  5. pointers
    By InvariantLoop in forum C Programming
    Replies: 13
    Last Post: 02-04-2005, 09:32 AM