Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: creating a csv file in awk
Top Forums Shell Programming and Scripting creating a csv file in awk Post 302171697 by Segwar on Friday 29th of February 2008 07:59:24 AM
Old 02-29-2008
creating a csv file in awk
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
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Creating a csv file based on Existing file

Hi I am Newbie to Unix.Appreciate Help from forum user would loada b.Csv File(Below example) in /data/m/ directory.Program need to read the b.csc to extract certain column and create a new file /data/d/ directory as csv file with new name. User File Format 1232,samshouston,12345... (3 Replies)
Discussion started by: skywayterrace
3 Replies

2. UNIX for Advanced & Expert Users

Creating multiple worksheets in CSV file

Hello, I've been tasked with sending 3 types of data (file size, row count, and file name) to a csv file every month for various vendors. I have been asked to put this in one csv or xls file with each vendor being a different tab (or worksheet). Until now, we have been finding and emailing... (4 Replies)
Discussion started by: tekster757
4 Replies

3. UNIX for Dummies Questions & Answers

creating a CSV file for past 7 days

I have a requirement which will select the files with a specific naming convention which got created in past 7 days in a specific directory.Lets say the directory is /data/XYZ and the file names follow the below nomenclature like Daily_File*.txt I just need to create one CSV file which will... (12 Replies)
Discussion started by: dr46014
12 Replies

4. UNIX for Dummies Questions & Answers

Creating a report from csv file.

Hi Gurus, I need your help in transforming the CSV file into some what a report format. My source file looks like below Date,ProdID,TimeID,LevelID 2010-08-31,200,M,1 2010-08-31,201,Q,2 2010-08-31,202,Y,1 2010-08-31,203,M,5 Output required is ... (9 Replies)
Discussion started by: naveen.kuppili
9 Replies

5. Shell Programming and Scripting

Problem creating file with awk

Hello, I don't understand why the script below doesn't act the way it should : #!/bin/sh awk 'BEGIN{printf("Entrez la date : "); getline date < "-"} $0 ~ date {f=1;print;next} /^{2}\//{f=0} f' Planning.csv > planning.txt It doesn't create file planning.txt with only the result of... (14 Replies)
Discussion started by: freyr
14 Replies

6. Shell Programming and Scripting

creating a csv file from this 1 liner?

I'm trying to create a csv file by running awk and sed on a number of xml files in a directory; I'm using this below: hostname; grep "BuildDate" /dir/ABCD/configuration/*/*.xml | awk -F"/" '{ print $5 }' > /tmp/tempfile.txt; grep "BuildDate" /dir/ABCD/configuration/*/*.xml | awk -F\" '{ print $2... (2 Replies)
Discussion started by: rich@ardz
2 Replies

7. UNIX for Dummies Questions & Answers

Problem in creating CSV file

Hi guys, I am not experienced with Unix, so please dont mind if the question seem to be irrelevant. I have written a simple script, that connects DB & fetches few records from a table. I wanted to get those details as file in .CSV format via mail. -I stored the query o/p in a file. -I... (6 Replies)
Discussion started by: sumitburnwal88
6 Replies

8. Shell Programming and Scripting

reading a csv file and creating a flat file

hi i have written a script for reading a csv file and creating a flat file, suggest if this script can be optimized #---------------- FILENAME="$1" SCRIPT=$(basename $0) #-----------------------------------------// function usage { echo "\nUSAGE: $THIS_SCRIPT file_to_process\n"... (3 Replies)
Discussion started by: mprakasheee
3 Replies

9. UNIX for Dummies Questions & Answers

Creating a csv file with header in UNIX

I have a flat file that contains dynamic list of variables like a=1 b=2 c=3 . .. z=26 I need to convert the above into a csv file having the format below: a,b,c,..,z 1,2,3,..,26 Please note, I do not want a comma separating the last variable. I tried to refer the post... (4 Replies)
Discussion started by: vkumbhakarna
4 Replies

10. Shell Programming and Scripting

Creating your own Header file in awk

whether it is possible in awk to create your own header file like in C if so someone give me awk equivalent for below one $ cat foo.h int add(int a,int b) { return(a+b); } $ cat main.c #include<stdio.h> #include"foo.h" void main() { int number1=10,number2=10,number3; number3 =... (5 Replies)
Discussion started by: Akshay Hegde
5 Replies

LEARN ABOUT LINUX

xbacklight

XBACKLIGHT(1)						      General Commands Manual						     XBACKLIGHT(1)

NAME

       xbacklight - adjust backlight brightness using RandR extension

SYNOPSIS

       xbacklight [-help]  [-display display] [-get] [-set percent] [-inc percent] [-dec percent]

DESCRIPTION

       Xbacklight is used to adjust the backlight brightness where supported. It finds all outputs on the X server supporting backlight brightness
       control and changes them all in the same way.

       -get   Print out the current backlight brightness of each output with such a control. The brightness is represented as a percentage of  the
	      maximum brightness supported.

       -set percent
	      Sets each backlight brightness to the specified level.

       -inc percent
	      Increases brightness by the specified amount.

       -dec percent
	      Decreases brightness by the specified amount.

       -help  Print out a summary of the usage and exit.

       -time milliseconds
	      Length of time to spend fading the backlight between old and new value.  Default is 200.

       -steps number
	      Number of steps to take while fading. Default is 20.

SEE ALSO

       Xrandr(3)

AUTHORS

       Keith Packard, Open Source Technology Center, Intel Corporation.

X Version 11							 xbacklight 1.1.2						     XBACKLIGHT(1)
All times are GMT -4. The time now is 06:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy