format output in csv file

Prashant Jain · #1 (**permalink**) 2 Weeks Ago

I am sending the output of a file to .csv file.
The output should look like this:

Total Customers Processed:,8
Total Customers Skipped:,0
Total Customers Added:,8
Total Customers Changed:,0

Total Policies Deleted:,0
Total Policies Failed:,0

total:,8

Now i want this output in only one cell, i.e line break in the same cell of csv file.like, we use Alt Enter on the cell in excel.

Wht my approach is , first of all i will replace the , with something else, thn i will remove the new line character with some spaces so that data comes in different lines bt in same cell, but its not working..

Please Help.........

Franklin52 · #2 (**permalink**) 2 Weeks Ago

Try this, suppose you want to replace the commas with spaces:

Code:

 awk 'BEGIN{printf("\"")}{gsub(","," ")}END{printf("\"")}1'  file.csv > newfile.csv

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
format file output	zerbitated	Shell Programming and Scripting	1	07-21-2009 03:00 PM
format the output from a file	becksram123	Shell Programming and Scripting	5	07-05-2009 09:55 PM
Output format - comparison with I/p file	velappangs	Shell Programming and Scripting	1	04-03-2008 06:31 AM
File Format issue: Output of sqlplus	deepakgang	UNIX for Dummies Questions & Answers	2	10-25-2007 03:56 AM
Format the output of file	getdpg	Shell Programming and Scripting	9	01-24-2006 12:50 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by