Shell Programming and Scripting

Okay, later I will try. But one more thing, this data I need to send to email via command line (include to scritps) Scripts for email it work and no problem.

Previous my csv file like this:

Code:

 
Media 894.45
Document 106.35
Picture 75.52
Archive 72.70
Database 0.06

Then from here I can add in to email scripts:

Code:

 
awk '{ print $1 "  -  " $2,"GB" }' profile.csv >> email.txt

output is -> Media - 894.45 GB <- add (-) and (GB)

That why my csv file don't have comma from beginning.

Now if my data with comma:

Code:

 
Media,894.45
Document,106.35
Picture,75.52
Archive,72.70
Database,0.06

How do I remove the comma then I can use back my email scripts:

Code:

 
awk '{ print $1 "  -  " $2,"GB" }' profile.csv >> email.txt

output is - Media - 894.45 GB <- add (-) and (GB)

Thanks.

Add field seperater in awk as below

Code:

awk -F, '{ print $1 "  -  " $2,"GB" }' inputfile

Thanks Pravin... Million thanks... also not forget to Chubler XL...