Sponsored Content
Top Forums UNIX for Dummies Questions & Answers File need to send to xls as one complete cell Post 302327214 by Scott on Saturday 20th of June 2009 07:17:30 AM
Old 06-20-2009
Hi.

Is your file a CSV file?

If so I tried this (and it worked with OpenOffice - don't know about MS Office)

Code:
cat rest | sed -e "s/.*/'&'/" | uuencode rest.xls | mailx ....

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Unique cell vaules in a file

I have a file in which I have records as follows -------------------------------------------------------------------------- 2-sister-birmbb-s0005.ftip002590790.vpn-nte.bt.net BRI0 0 0 0 aber-con-dyce-s0006.ftip002732992.vpn-nte.bt.net ATM0 0 0 0... (3 Replies)
Discussion started by: rahulrathod
3 Replies

2. UNIX for Dummies Questions & Answers

BASH complete-filename & menu-complete together

Hi, Does anyone know how to make BASH provide a list of possible completions on the first tab, and then start cycling through the possibilites on the next tab? Right now this is what I have in my .bashrc: bind "set show-all-if-ambiguous on" bind \\C-o:menu-complete This allows... (0 Replies)
Discussion started by: Mithu
0 Replies

3. Shell Programming and Scripting

converting xls file to txt file and xls to csv

I need to convert an excel file into a text file and an excel file into a CSV file.. any code to do that is appreciated thanks (6 Replies)
Discussion started by: bandar007
6 Replies

4. UNIX for Advanced & Expert Users

Converting .csv file into .xls file and send it to inbox

Hi All, I wrote a script to extract data from Oracle DB and place it in a text file , and I have coverted .txt file into comma seperated .csv file and I sent it to my mail box . I can get .xls file in my inbox.I am getting all data in same column and in different rows , without column... (1 Reply)
Discussion started by: krthkmuthu
1 Replies

5. Shell Programming and Scripting

how to extract the data from database (oracle) and send the output as an .xls file?

Hi, How to extract the data from Oracle database and sent the output data to mails using mailx command with .xls attachement? Here i know how to connect the database using unix shell script and how to use the mailx command in UNIX script But i don't know how to use the .xls format file (i... (1 Reply)
Discussion started by: psiva_arul
1 Replies

6. UNIX for Advanced & Expert Users

How to add two values in the same cell of CSV file

I need help to create a csv file with Unix command. In csv file, i need to put two values in the same cell. Rite now, whts happening is, if i put 2 values in the same cell, its comming as " asd, zxc" but i want it in different line but in same cell. asd zxc Please reply me ASAP. (1 Reply)
Discussion started by: Prashant Jain
1 Replies

7. Shell Programming and Scripting

Extract last cell of csv file

How do I extract the last cell in a column of a csv file using linux shell scripting? Or alternatively, how do I get the number of cells of a csv file? (2 Replies)
Discussion started by: locoroco
2 Replies

8. Shell Programming and Scripting

Parse excel file with html on each cell

<DIV><P>Pré-condição aceder ao ecrã Home do MRS.</P></DIV><DIV><P>OK.</P></DIV><DIV><P>Seleccionar Pesquisa de Recepção Directa.</P></DIV><DIV><P>Confirmar que abriu ecrã de Recepção Directa.</P></DIV><DIV> (6 Replies)
Discussion started by: oliveiraum
6 Replies

9. Shell Programming and Scripting

Merging Multiple XLS into Different tabs in xls/ xlsx

HI, I have multiple files per dept in folder for eg : In a folder File1_Dept100.xls File2_Dept100.xls File3_Dept100.xls File1_Dept200.xls File2_Dept200.xls File3_Dept200.xls Output should be : Dept100.xls which has File1, File2, File3 in different tabs Dept200.xls which has... (1 Reply)
Discussion started by: venkyzrocks
1 Replies

10. UNIX for Beginners Questions & Answers

Merge Text with space into once cell and send email out

Please help!! This code works perfect but the only problem I am having is that is treats eg SQL Developer as separate cell/column which makes the formatting bad. I want to put SQL Developer in one cell. I attached a sample of how the output looks like. report.txt USERNAME OSUSER ... (5 Replies)
Discussion started by: lpoolfc
5 Replies
uuencode(1c)															      uuencode(1c)

Name
       uuencode, uudecode - encode/decode a binary file for transmission via mail

Syntax
       uuencode [file] remotedest | mail sys1!sys2!..!decode
       uudecode [file]

Description
       The  and  commands are used to send a binary file by uucp (or other) mail.  This combination can be used over indirect mail links even when
       is not available.

       The command takes the named source file (default standard input) and produces an encoded version on the standard output.  The encoding uses
       only printing ASCII characters, and includes the mode of the file and the remotedest for recreation on the remote system.

       The  command  reads  an	encoded file, strips off any leading and trailing lines added by mailers, and recreates the original file with the
       specified mode and name.

       The intent is that all mail to the user ``decode'' should be filtered through the program.  This way  the  file	is  created  automatically
       without	human  intervention.   This  is possible on the uucp network by either using or by making be a link to instead of In each case, an
       alias must be created in a master file to get the automatic invocation of

       If these facilities are not available, the file can be sent to a user on the remote machine who can uudecode it manually.

       The encode file has an ordinary text form and can be edited by any text editor to change the mode or remote name.

Restrictions
       The file is expanded by 35% (3 bytes become 4 plus control information) causing it to take longer to transmit.

       The user on the remote system who is invoking (often must have write permission on the specified file.

See Also
       mail(1), uucp(1c), uusend(1c), uux(1c), uuencode(5)

																      uuencode(1c)
All times are GMT -4. The time now is 04:15 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy