Format csv file using Unix

Applications UNIX Desktop Questions & Answers
1

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

2

one way ..

$ nawk '{if(NR==1){print "tput bold;echo \""$0"\";tput rmso"}else{print "echo "$0}}' infile | sh
Name Rank
arun 1
babu 2
3

csv file is a normal text file and i dont think, you can bold the header in the CSV file

4

Now its arun's turn to tell whether the csv file is a text file or a flat file ..

5

@Jayan

your tput command only shows the bold result in terminal ( not in the csv file )

6

@kamaraj, got your question .. tput output is just for appearance in terminal ..

I think, even arun is also expecting this .. Lets see .. :wink:

7

Hi Jayan & Kamaraj,

Thanks for your Replies.,

I need the output in CSV file.

I also tried a lot to display the bold format in CSV file, but i was unable to do it..

IS there any way to do that..

One more Question:

Is there any way to two or more excel sheets in a single excel document ie.,

for example i have three excel sheets a1,a2,a3..

so in a single excel document, whether i can view all these three sheets in three different tabs.., (am not mentioning that i need to view all three file in a single file., where CAT command can help me out to do that, but i need to view in different tabs)?

Thanks,
Arun Manas

8

A CSV file is a text file.

Not in a CSV file.