Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2008
    Posts
    8

    Unanswered: how to copy data using shell script to a excel file

    Hi,

    Can any one tell me how to copy data using shell script to a excel file from text file to other columns of excel file,leaving first column unaffected i.e it should not overwrite data in first column.

    Say my text file data is:

    15-dec-2008 15-dec-2009
    16-dec-2008 16-dec-2009


    say my first excel column is:

    column1 column2 column3
    server1
    server2


    I want output as below:

    column1 | column2 | column3
    server1 | 15-dec-2008 | 15-dec-2009
    server2 | 16-dec-2008 | 16-dec-2009

    Thanks in advance........

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Thumbs down Not *nix

    This has nothing to do with Unix, try posting in one of the WinDoze "excel" forums.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Dec 2008
    Posts
    8
    Hey man...Its related to Unix only.....and I got the solution as well.....

  4. #4
    Join Date
    Jan 2009
    Posts
    1
    Hi,

    Can any one tell me how to copy data using shell script to a excel file from text file to other columns of excel file,leaving first column unaffected i.e it should not overwrite data in first column.

    Please help..

    Thakx,
    Amin

  5. #5
    Join Date
    Mar 2008
    Posts
    89
    Quote Originally Posted by LKBrwn_DBA
    This has nothing to do with Unix, try posting in one of the WinDoze "excel" forums.
    well if his output example is meant literally, we can create a shell script that produces a pipe-delimited flat file as a result, easily importable in excel.

    But the solution is apparently already found. Would be nice to actually post it here too.
    "My brain is just no good at being a relational Database - my relations suck real bad!"

Posting Permissions

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