i am stuck with this awk command. i need to calculate the sum of a column of values on a flatfile and i am using the following command :
Code:
awk -F"|" '{x += $10} END {print "Sum: "x}' standard_csv_file1.out
that flatfile contains 180 fields and i am getting the following error.
Code:
awk: record `"D"||||||2449|||203|...' has too many fields
record number 1
i tried the same command when i had few fields (may be 30 or so) it worked fine. but in order to standardise the flatfile, i have to add too many null value fields and now the total number of fields is 180 and the command doesn't work saying too many fields. any way around please.
Hi,
I would be very happy if someone could help me please. I am relatively new to UNIX, and still learning.
My understanding of things are:
Say I have a PC running Windows. This machine has a name. If I have 10 PC's, then I have 10 names, one for each PC. Each PC is independent of the other.... (4 Replies)
Hi
I am trying to set up two hosts in a reverse proxy. The reverse proxy already has 8 servers running perfectly, but they are all simply mapping pure addresses, which I have registered internally and externally.
The latest two I wish to add are a bit different, they are app servers, one... (1 Reply)
Hi,
I am trying to upload a file to a SQL database table. The column type is IMAGE. I am looking for a solution to upload a word doc file. I tried 3 approaches.
1) my $fileToStore = "mytest.doc";
open IPFILE, "<", $name;
binmode IPFILE;
while (<IPFILE>)
{
$fileToStore .= $_;
}
close... (1 Reply)
hi all
I am new to unix and want to create a loop to repeat the loop and before that it ask me to do so.I know "while" may help but I put it in my work and getting stuk with it.any help appreciated. (13 Replies)
Hi,
I am working on a parsing script but cannot figure out how to accomplish this. Here is a simplified version of the script:
#!/bin/bash
DS=$1
DS=`expr $DS \* 2`
DS=`expr $DS + 7`
cat $FILENAME | awk '/<row><v> +/' | awk '{printf("%.0f %.0f\n", $6, $9)}'
The problem is that I want the... (2 Replies)
Hi,
I have used the following command to get result using some program and got desired output but I am unable to understand the last part: sort -k5,5 -rn|head -n 10
grep Centre groups.dat |sort -k5,5 -rn|head -n 10
Please guide.
Thanks (2 Replies)
Hi ,
i have a shell script with the first two lines as
#! /bin/ksh
set -x
when i try opening the file from unix using the command 'sh filename.sh' , i am getting the below error :
invalid optionline 2: set: -
Pls help
Use code tags for you code and data... (1 Reply)
I have not been able to append the contents of many files into one file. I have executed the CAT command shown below separately substituting an actual path and file name for the array variable to verify that I have the syntax correct. The bottom line - nothing is happening with CAT. I am running... (16 Replies)
Discussion started by: demmith
16 Replies
LEARN ABOUT REDHAT
igawk
IGAWK(1) Utility Commands IGAWK(1)NAME
igawk - gawk with include files
SYNOPSIS
igawk [ all gawk options ] -f program-file [ -- ] file ...
igawk [ all gawk options ] [ -- ] program-text file ...
DESCRIPTION
Igawk is a simple shell script that adds the ability to have ``include files'' to gawk(1).
AWK programs for igawk are the same as for gawk, except that, in addition, you may have lines like
@include getopt.awk
in your program to include the file getopt.awk from either the current directory or one of the other directories in the search path.
OPTIONS
See gawk(1) for a full description of the AWK language and the options that gawk supports.
EXAMPLES
cat << EOF > test.awk
@include getopt.awk
BEGIN {
while (getopt(ARGC, ARGV, "am:q") != -1)
...
}
EOF
igawk -f test.awk
SEE ALSO gawk(1)
Effective AWK Programming, Edition 1.0, published by the Free Software Foundation, 1995.
AUTHOR
Arnold Robbins (arnold@skeeve.com).
Free Software Foundation Nov 3 1999 IGAWK(1)
12-13-2011
