Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Problem in creating CSV file

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Problem in creating CSV file
# 1  
Old 05-05-2012
Problem in creating CSV file
Hi guys,

I am not experienced with Unix, so please dont mind if the question seem to be irrelevant.

I have written a simple script, that connects DB & fetches few records from a table. I wanted to get those details as file in .CSV format via mail.
-I stored the query o/p in a file.
-I squeezed all space character, then translated all space character into ',' (by help of 'tr' command only) [I know by this we can create .csv file]
-And finally I renamed the file into .CSV format (by mv command)
-But when I mailed that file as attachment (uuencode & mailx command), I am getting the data in strange format, some box symbols are appearing, though the data are OK but they are not readable properly.When I copy/paste those content in textpad, they are again visible fine.

Can someone please help me to view those data in .CSV file (or excel) in proper tabular format.

Thanks in adv.
Last edited by sumitburnwal88; 05-05-2012 at 09:56 AM.. Reason: Tried to insert an image file that did not happen
# 2  
Old 05-05-2012
are you using MS Outlook to view your email attachment ?
# 3  
Old 05-05-2012
yes I am using MS outlook...does it make any difference...!Smilie
After all the attachment (.csv file) will be opened in MS Excel...
Last edited by sumitburnwal88; 05-05-2012 at 04:00 PM.. Reason: reply update
# 4  
Old 05-05-2012
MS outlook has problems with decoding messages which are encoded using uuencode.

You can use -a option of mailx to send attachments instead of using uuencode.
# 5  
Old 05-05-2012
Hi,

Is there any other way to send attachment except 'uuencode' ? Where do I need to use the '-a' option (in 'uuencode' or 'mailx') ?

Can you please give an example here ? If I want to send a file say "Report.csv" to "sumit@yahoo.com", then what would be the command ?

Thanks for the help.
Last edited by sumitburnwal88; 05-05-2012 at 05:47 PM.. Reason: reply update
# 6  
Old 05-05-2012
Code:
mailx -s "subject" -a Report.csv sumit@yahoo.com < mail_body

# 7  
Old 05-06-2012
Hi,

When I am using that command, I am getting the below error -

mailx: illegal option -- a
Usage: mailx -eiIUdFntBNHvV~ -T FILE -u USER -h hops -r address
-s SUBJECT -f FILE users

-Please help me out.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Creating a csv file with header in UNIX

I have a flat file that contains dynamic list of variables like a=1 b=2 c=3 . .. z=26 I need to convert the above into a csv file having the format below: a,b,c,..,z 1,2,3,..,26 Please note, I do not want a comma separating the last variable. I tried to refer the post... (4 Replies)
Discussion started by: vkumbhakarna
4 Replies

2. Shell Programming and Scripting

reading a csv file and creating a flat file

hi i have written a script for reading a csv file and creating a flat file, suggest if this script can be optimized #---------------- FILENAME="$1" SCRIPT=$(basename $0) #-----------------------------------------// function usage { echo "\nUSAGE: $THIS_SCRIPT file_to_process\n"... (3 Replies)
Discussion started by: mprakasheee
3 Replies

3. Shell Programming and Scripting

creating a csv file from this 1 liner?

I'm trying to create a csv file by running awk and sed on a number of xml files in a directory; I'm using this below: hostname; grep "BuildDate" /dir/ABCD/configuration/*/*.xml | awk -F"/" '{ print $5 }' > /tmp/tempfile.txt; grep "BuildDate" /dir/ABCD/configuration/*/*.xml | awk -F\" '{ print $2... (2 Replies)
Discussion started by: rich@ardz
2 Replies

4. Shell Programming and Scripting

Problem creating file with awk

Hello, I don't understand why the script below doesn't act the way it should : #!/bin/sh awk 'BEGIN{printf("Entrez la date : "); getline date < "-"} $0 ~ date {f=1;print;next} /^{2}\//{f=0} f' Planning.csv > planning.txt It doesn't create file planning.txt with only the result of... (14 Replies)
Discussion started by: freyr
14 Replies

5. UNIX for Dummies Questions & Answers

Creating a report from csv file.

Hi Gurus, I need your help in transforming the CSV file into some what a report format. My source file looks like below Date,ProdID,TimeID,LevelID 2010-08-31,200,M,1 2010-08-31,201,Q,2 2010-08-31,202,Y,1 2010-08-31,203,M,5 Output required is ... (9 Replies)
Discussion started by: naveen.kuppili
9 Replies

6. UNIX for Advanced & Expert Users

Problem in converting password protected excel file to csv file in unix

I need to convert a password protected excel file which will be in UNIX server to a comma separated file. For this I need to open the excel file in UNIX box but the UNIX box doesn't prompt for password instead it is opened in an encrypted manner. I could manually ftp the excel file to local... (2 Replies)
Discussion started by: Devivish
2 Replies

7. UNIX for Dummies Questions & Answers

creating a CSV file for past 7 days

I have a requirement which will select the files with a specific naming convention which got created in past 7 days in a specific directory.Lets say the directory is /data/XYZ and the file names follow the below nomenclature like Daily_File*.txt I just need to create one CSV file which will... (12 Replies)
Discussion started by: dr46014
12 Replies

8. UNIX for Advanced & Expert Users

Creating multiple worksheets in CSV file

Hello, I've been tasked with sending 3 types of data (file size, row count, and file name) to a csv file every month for various vendors. I have been asked to put this in one csv or xls file with each vendor being a different tab (or worksheet). Until now, we have been finding and emailing... (4 Replies)
Discussion started by: tekster757
4 Replies

9. Shell Programming and Scripting

creating a csv file in awk

Hi All I am trying to create a csv file in the korn shell and the script segment is as follows: if then # NEED TO ADD INFO TO THE EMAIL FILE ABOUT THE DRIVE THAT'S FILLING UP echo "$drive $percent% $space "|\ awk '{printf("%d/t"|"%d/t"|"%d/t\n",... (6 Replies)
Discussion started by: Segwar
6 Replies

10. Shell Programming and Scripting

Creating a csv file based on Existing file

Hi I am Newbie to Unix.Appreciate Help from forum user would loada b.Csv File(Below example) in /data/m/ directory.Program need to read the b.csc to extract certain column and create a new file /data/d/ directory as csv file with new name. User File Format 1232,samshouston,12345... (3 Replies)
Discussion started by: skywayterrace
3 Replies
Login or Register to Ask a Question