[SOLVED] Field $() is incorrect 'what does it mean' Post: 302703835

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers [SOLVED] Field $() is incorrect 'what does it mean' Post 302703835 by Bruble on Thursday 20th of September 2012 12:09:43 PM

09-20-2012

Registered User

[SOLVED] Field $() is incorrect 'what does it mean'

I am creating (or trying to) an awk script to retrieve various data from an input file and output the data in a different format. I think it is self explanatory what I am attempting but I getting the error Field $() isincorrect when I reun it using

Code:

awk -f file.awk inputfile

Code:

 
#!/bin/awk -f
#get text between 'starting' and 'Ending'
#
BEGIN {
OFS=","
}
#'start loop here'
  /Starting/,/Ending/ {
#if the line contains 'starting'
    if ($0 ~ /starting/) {
       day=substr($0,8,3);
       month=substr($0,12,3);
       date=substr($0,16,2);
       sthour=substr($0,19,2);
       stmin=substr($0,22,2);
       stsec=substr($0,25/2);
       year=substr($0,28,4);
       number=substr($0,33,5);
    }
#if the line contains 'LN'
    if ($0 ~ /LN/) {
       depot=substr($0,58,3);
       order=substr($0,61,5);
    }
#if the line contains 'Ending'
    if ($0 ~ /Ending/) {
       endhour=substr($0,19,2);
       endmin=substr($0,22,2);
       endsec=substr($0,25/2);
    }
 }
#'leave loop here'
durhour=$endhour-$sthour;
durmin=$endmin-$stmin;
dursec=$endsec-$stsec;
END {
  print $year $month $date $sthour $stmin $stsec $endhour $endmin $endsec $durhour $durmin $dursec 
$depot $order
  }

I hope someone can explain why this may be the case.

Thanks in advance.

Bruble

View Public Profile for Bruble

Find all posts by Bruble

10 More Discussions You Might Find Interesting

1. Forum Support Area for Unregistered Users & Account Problems

user name is incorrect

Hello. I registered yesterday with a username of "kailor" and a password of removed. I could only logon with a username of "keithailor@comc" and the above password. I want my username to become "kailor" and my password to remain as removed. Please email me with the steps to correct this. ...

2. UNIX for Dummies Questions & Answers

login incorrect

Hi to all, I get a problem when i tried to modifie the password of the root,but thi s the message i have on root password,even i put the old password i have the same message "password has expired, you are allowed to entry by daemon"Could any one give me any suggestion to solve the problem?...

3. Shell Programming and Scripting

[solved] merging two files and writing to another file- solved

i have two files as file1: 1 2 3 file2: a b c and the output should be: file3: 1~a 2~b 3~c

4. Solaris

[Solved] Solaris 10 - Ftp Login incorrect

Hey everyone, I am trying to get a 2GB patch cluster FTP'd to a solaris 10 server. I have tried logging in via ftp, and both with root as well as my personal account, I get "Login Incorrect." I have verified that I can log in using telnet. -bash-3.00$ netstat -a |grep ftp *.ftp ...

5. Shell Programming and Scripting

[Solved] Need help changing a field from MM/DD/YY to DD/MM/YY format

Hi, I need help changing a field from MM/DD/YY to DD/MM/YY format. Suppose a file a.csv. The record is "11/16/09","ABC"," 1","EU","520892414","1","600","31351000","1234567","ANR BANK CO. LTD" "11/16/09","PQR"," 2","EU","520892427","1","600","31351000","5467897","ANR BANK CO....

6. Shell Programming and Scripting

[Solved] sort on numeric part of field

I have ran into a heavy case of PEBCAK*) and could need some advice on what i do wrong: OS is Linux (kernel 2.6.35), sort --version reports "8.5" from 2010, shell is ksh. Originally i had a file with with the following structure: hdisk1 yyy hdisk2 yyy hdisk3 yyy hdisk4 yyy hdisk5 yyy...

7. Shell Programming and Scripting

[Solved] Counting specific characters within each field

Hello, I have a file like following: ALB_13554 1 1 1 ALB_13554 1 2 1 ALB_18544 2 0 2 ALB_18544 1 0 1 This is a sample of my file, my real file has 441845 number of fields. What I want to do is to calculate the number of 1 and 2 in each column using AWK, so, the output file looks like...

8. Shell Programming and Scripting

[SOLVED] How to set field separator in awk when FS is "||" ?

Dear Experts, How to use field separator in awk , when the field separation is needed as "||" Example: (file1 ) aa || bb || cc || 1234 xx || yy || zz || 1123 Q: If I want to print $3 and $4 only , with using the field separator "||" How to write awk code:

9. UNIX for Dummies Questions & Answers

ID incorrect field values in dat file and output to new file

Hi All I have a .dat file, the values are seperated by ". I wish to identify all field values in field 14 that are not '01-APR-2013' band then copy those records to a new file. Can anyone suggest the UNIX command required. Thanks in advance Andy

10. UNIX for Dummies Questions & Answers

[Solved] Awk: count occurrence of each character for every field

Hi, let's say an input looks like: A|C|C|D A|C|I|E A|B|I|C A|T|I|B as the title of the thread explains, I am trying to get something like: 1|A=4 2|C=2|B=1|T=1 3|I=3|C=1 4|D=1|E=1|C=1|B=1 i.e. a count of every character in each field (first column of output) independently, sorted...

LEARN ABOUT REDHAT

tzselect

TZSELECT(8)						      System Manager's Manual						       TZSELECT(8)

NAME

       tzselect - select a time zone

SYNOPSIS

       tzselect

DESCRIPTION

       The  tzselect program asks the user for information about the current location, and outputs the resulting time zone description to standard
       output.	The output is suitable as a value for the TZ environment variable.

       All interaction with the user is done via standard input and standard error.

ENVIRONMENT VARIABLES

       AWK    Name of a Posix-compliant awk program (default: awk).

       TZDIR  Name of the directory containing time zone data files (default: /usr/local/etc/zoneinfo).

FILES

       TZDIR/iso3166.tab
	      Table of ISO 3166 2-letter country codes and country names.

       TZDIR/zone.tab
	      Table of country codes, latitude and longitude, TZ values, and descriptive comments.

       TZDIR/TZ
	      Time zone data file for time zone TZ.

EXIT STATUS

       The exit status is zero if a time zone was successfully obtained from the user, nonzero otherwise.

SEE ALSO

       newctime(3), tzfile(5), zdump(8), zic(8)

																       TZSELECT(8)

10 More Discussions You Might Find Interesting

1. Forum Support Area for Unregistered Users & Account Problems

user name is incorrect

Discussion started by: keithailor@comc

2. UNIX for Dummies Questions & Answers

login incorrect

Discussion started by: espace1000

3. Shell Programming and Scripting

[solved] merging two files and writing to another file- solved

Discussion started by: mlpathir

4. Solaris

[Solved] Solaris 10 - Ftp Login incorrect

Discussion started by: msarro