creating a csv file in awk

Segwar · #1 (**permalink**) 02-29-2008

Hi All
I am trying to create a csv file in the korn shell and the script segment is as follows:

Code:

if [ percent -gt 80 ]
        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", $drive,$percent%,$space)}' >> tempfile.txt

now i am getting a syntax error when the script is run.

Code:

awk: syntax error near line 1
awk: illegal statement near line 1

it seems that i am making an elementry mistake that I am not able to catch
the $drive $percent and $space are integers and are being pulled from a df -k command
Please Assist

Franklin52 · #2 (**permalink**) 02-29-2008

Replace the awk command with:

Code:

awk '{printf("%d/t"|"%d/t"|"%d/t\n", $1, $2, $3)}' >> tempfile.txt

Regards

Segwar · #3 (**permalink**) 02-29-2008

Quote:

Originally Posted by Franklin52

Replace the awk command with:

Code:

awk '{printf("%d/t"|"%d/t"|"%d/t\n", $1, $2, $3)}' >> tempfile.txt

Regards

Thanks Franklin,
I will try and get back

Segwar · #4 (**permalink**) 02-29-2008

Quote:

Originally Posted by Segwar

Thanks Franklin,
I will try and get back

I tried and got the same error message

Code:

awk: syntax error near line 1
awk: illegal statement near line 1

Segwar · #5 (**permalink**) 02-29-2008

Quote:

Originally Posted by Segwar

I tried and got the same error message

Code:

awk: syntax error near line 1
awk: illegal statement near line 1

shoud I try to replace the $1 $2 and $3 with the drive percent and space variables?

Franklin52 · #6 (**permalink**) 02-29-2008

Sorry, I just copy and paste the first piece of the printf statement, try this:

Code:

awk '{printf("%d/t|%d/t|%d/t\n", $1, $2, $3)}' >> tempfile.txt

Regards

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
creating a file using Perl	chriss_58	Shell Programming and Scripting	1	06-03-2008 07:41 AM
Creating a file	ravisg	Shell Programming and Scripting	2	05-10-2008 06:15 AM
help with creating new log file	john89011	Shell Programming and Scripting	0	02-29-2008 12:45 PM
Creating a txt file	outthere_3	UNIX for Dummies Questions & Answers	1	01-31-2008 11:09 PM
Creating a csv file based on Existing file	skywayterrace	Shell Programming and Scripting	3	12-02-2007 09:19 AM

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