Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

FORMAT OF CSV FILE under unix environment.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting FORMAT OF CSV FILE under unix environment.
# 8  
Old 06-20-2007
If this is all you need, then add a new line to the beginning
of the file with your specification.
# 9  
Old 06-20-2007
Quote:
Originally Posted by raosurya
NO.
what is my problem is i sent this CSV FILE to excel spread sheet.
when open the csv file, i could not see whole column width. it showing excel default column width. so, i cannot see whole column. i need to manually darg he column to see column result. so, i want to increase the column width before sening to e-mail attachment.
that is my problem.

thx for your help. pl write the script

thx.N.
Dear raosurya, (as someone used to say)
Pls do a little experiment:
  1. take your .csv file
  2. hand edit one of the fields - increase the 'padding' to the desired length
  3. save the .csv file
  4. bring the .csv file in Excell
  5. see if your columns have adjusted their 'width'
  6. if they did - it's worth writing a 'script'. if they ain't - it ain't. It's got nothing to do with padding, but rather the Excell way of adjusting the width.
my $.02
Last edited by vgersh99; 06-20-2007 at 08:59 PM..
# 10  
Old 06-20-2007
I am desparate to fix the problem.
Need help.

replied:
awk -F"," '{printf "%-20s %-20s %-20s %-20s %-20s\n",$1,$2,$3,$4,$5}' <file-name>


how to add spaces for the above script towards right of each column about 15 position and aslo save into new file

i think it will work. i need to test it now.help me.
thx. N.
# 11  
Old 06-20-2007
Raosurya,
As you know, we are all unix volunteers here and we are here
to help people solve their problems.
But under no circunstances we work under pressure.
You have to give members a chance to work on your issue keeping
in mind the following:
"Lack of planing on your side does not constitute emergency on our side"

In any event, here is your solution:
Code:
while read mLine
do
  set -- `echo $mLine | sed 's/,/ /g'`
  printf "%-15s %-5s %-4s %-2s %-2s\n" $1 $2 $3 $4 $5
done < input_file

# 12  
Old 06-20-2007
I am sorry about that.

Thanks for your reply.
N.
# 13  
Old 06-21-2007
I don't think that padding with spaces will help, since Excel will still use a default column width when opening a csv file. You could convert your csv file to html, which Excel will try to render properly, e.g....
Code:
awk 'BEGIN{
        FS=","
        print "<HTML><BODY><TABLE>"
     }
     {
        printf "<TR>"
        for(i=1;i<=NF;i++)
          printf "<TD>%s</TD>", $i
        print "</TR>"
     }
     END{
        print "</TABLE></BODY></HTML>"
     }
     ' file1.csv > file2.xls

# 14  
Old 06-21-2007
In Excel click the gray box at the top left hand corner to highlight the whole table, then double click one of the divider bars.

Excel will then magically readjust all the column widths to fit the data.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Change date format in am/pm in csv files using UNIX

Hi All, I'm new to forum good to hear all. I stuck in converting date format in csv file using unix csv file contains as below ,750,0000000000000000GCJR, ,06/22/2016 14:48:44 I want to convert into as below ,750,0000000000000000GCJR, ,06/22/2016 02:48:44 PM Please reply asap..... (22 Replies)
Discussion started by: Raghureds
22 Replies

2. Shell Programming and Scripting

UNIX command output in csv format

I'm just wondering is there any way to capture the output of a unix command in a csv format. df -h gives the result of filesystem,free space,Used space, use %,mounted on. Is there a way to capture the command output and format it as comma sparated or fixed length file. (3 Replies)
Discussion started by: anita81
3 Replies

3. Shell Programming and Scripting

Match list of strings in File A and compare with File B, C and write to a output file in CSV format

Hi Friends, I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving... File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Discussion started by: asnandhakumar
6 Replies

4. Shell Programming and Scripting

Format csv file

Hi, I need to make some changes in a csv file using awk or perl. Unfortunately, all my attempts have led to nothing so I hope you guys can help me. I have the following example input file including header(original file has 35 fields): ABC: DE Time: 2012/09/07... (3 Replies)
Discussion started by: Subbeh
3 Replies

5. UNIX Desktop Questions & Answers

Format csv file using Unix

Hi All, I have an csv file with three rows, where first containing header deatils. is there any way to make the first row to appear bold using UNIX command. Input File: Name Rank arun 1 babu 2 Expected Output: Name Rank arun 1 babu 2 (7 Replies)
Discussion started by: arunmanas
7 Replies

6. Shell Programming and Scripting

Retaining the Unix CSV format in Excel format while exporting

Hi All, I have created a Unix Shell script whch creates a *.csv file and export it to Excel. The problem i am facing is that Users wants one of the AMOUNT field in comma separted values. Example : if the Amount has the value as 3000000 User wants to be in 3,000,000 format. This Amount format... (2 Replies)
Discussion started by: rawat_me01
2 Replies

7. Shell Programming and Scripting

Display o/p in HTML format from unix environment

Hi, i want to disply the o/p in HTML format from unix environment. Let me explain my requirement. First an automated email should be sent in HTML format. The report contains number of error on a daily basis for this week. email looks like below, 01-04-2010 1000 02-04-2010 ... (3 Replies)
Discussion started by: apsprabhu
3 Replies

8. Shell Programming and Scripting

Format CSV file

I have a csv file which I need to process and export back to xlsx file. For instance, the csv contains: John Smith, job-title, hours John Smith, job-title, hours Mary Smith job-title, hours etc. I need to import that to a script, get id of redundant data i.e: John smith, job-title,... (13 Replies)
Discussion started by: _tina_
13 Replies

9. UNIX for Dummies Questions & Answers

Unix script to convert .csv file to.xls format

I have a .csv file in Unix box i need a UNIX script to convert the.csv files to.xls format. Its very urgent please help me. (1 Reply)
Discussion started by: moon_friend
1 Replies

10. Shell Programming and Scripting

AWK CSV to TXT format, TXT file not in a correct column format

HI guys, I have created a script to read 1 column in a csv file and then place it in text file. However, when i checked out the text file, it is not in a column format... Example: CSV file contains name,age aa,11 bb,22 cc,33 After using awk to get first column TXT file... (1 Reply)
Discussion started by: mdap
1 Replies
Login or Register to Ask a Question