Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Awk Command to extract Fields
Top Forums Shell Programming and Scripting Awk Command to extract Fields Post 302190702 by usshell on Wednesday 30th of April 2008 09:31:00 AM
Old 04-30-2008
Awk Command to extract Fields
Hi

I am newbie.My requirement is:
I have start time :Wed Apr 30 3:30:45
End time :Wed Apr 30 3:35:45
which is stored in a file.
I have to extract timestamp 3:30:45 using awk. And Subtract the same

The script:
----------
#!/bin/ksh
LOG_FILE=$1

START_TIME=`head -2 $LOG_FILE `
echo $START_TIME
NUM_FIELDS=`echo $START_TIME| awk '{print NF}'`

count=0
Time_Stamp=`echo $START_TIME| awk -F ':' '{print $NUM_FIELDS}'`
echo 'Time'
echo $Time_Stamp
while [$count -lt $NUM_FIELDS]
do
count=`expr $count + 1`
Time_Stamp=`echo $START_TIME| awk '{print $NUM_FIELDS}'`
echo $Time_Stamp
done
The script is not working.
Please let me know how to proceed.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk sed cut? to rearrange random number of fields into 3 fields

I'm working on formatting some attendance data to meet a vendors requirements to upload to their system. With some help on the forums here, I have the data close. But they've since changed what they want. The vendor wants me to submit three fields to them. Field 1 is the studentid field,... (4 Replies)
Discussion started by: axo959
4 Replies

2. Shell Programming and Scripting

Help with awk command to extract messages

Need expert's opinion urgently. I have a file which contains messages. A message is separated by $ in this file. In each message we need to get string aftr :20: and send it to an output file. If :20: is not prsent in a message then we need to search for :20C: and send the corresponding string... (5 Replies)
Discussion started by: Opamps123
5 Replies

3. Shell Programming and Scripting

extract the data using AWK command

In a file i have a data like INPUT: no,name,company 1,vivek,hcl 2,senthil,cts 1,narsi,hcl 4,prabhakaran,ibm OUTPUT: 1,vivek,hcl 1,narsi,hcl Using AWK command i want to display the names those having no:1 and company:hcl.Please tell me the command to display above result. (8 Replies)
Discussion started by: katakamvivek
8 Replies

4. Shell Programming and Scripting

How to print 1st field and last 2 fields together and the rest of the fields after it using awk?

Hi experts, I need to print the first field first then last two fields should come next and then i need to print rest of the fields. Input : a1,abc,jsd,fhf,fkk,b1,b2 a2,acb,dfg,ghj,b3,c4 a3,djf,wdjg,fkg,dff,ggk,d4,d5 Expected output: a1,b1,b2,abc,jsd,fhf,fkk... (6 Replies)
Discussion started by: 100bees
6 Replies

5. Shell Programming and Scripting

awk sort based on difference of fields and print all fields

Hi I have a file as below <field1> <field2> <field3> ... <field_num1> <field_num2> Trying to sort based on difference of <field_num1> and <field_num2> in desceding order and print all fields. I tried this and it doesn't sort on the difference field .. Appreciate your help. cat... (9 Replies)
Discussion started by: newstart
9 Replies

6. Shell Programming and Scripting

awk to extract multiple values from file and add two additional fields

In the attached file I am trying to use awk to extract multiple values and create the tab-delimited desired output. In the output R_Index is a the sequential # and Pre_Enrichment is defaulted to .. I can extract from the values to the side of the keywords, but most are above and I can not... (2 Replies)
Discussion started by: cmccabe
2 Replies

7. Shell Programming and Scripting

awk command to search based on 5 user input fields

Field1=”” Field2=”” Field3=”” Field4=”” Field5=”” USER INPUT UP TO 5 FIELDS awk -F , '{ if ( $3 == Field1 && $6 == Field2 && $8 == Field3 && $9 == Field4 && $10 == Field5) print $0 }' /tmp/rodney.outD INPUT FILE (Rodney.outD): ... (3 Replies)
Discussion started by: rmerrird
3 Replies

8. UNIX for Beginners Questions & Answers

How to extract fields from a CSV i.e comma separated where some of the fields having comma as value?

can anyone help me!!!! How to I parse the CSV file file name : abc.csv (csv file) The above file containing data like abv,sfs,,hju,',',jkk wff,fst,,rgr,',',rgr ere,edf,erg,',',rgr,rgr I have a requirement like i have to extract different field and assign them into different... (4 Replies)
Discussion started by: J.Jena
4 Replies

9. UNIX for Beginners Questions & Answers

Is there a UNIX command that can compare fields of files with differing number of fields?

Hi, Below are the sample files. x.txt is from an Excel file that is a list of users from Windows and y.txt is a list of database account. $ head -500 x.txt y.txt ==> x.txt <== TEST01 APP_USER_PROFILE USER03 APP_USER_PROFILE TEST02 APP_USER_EXP_PROFILE TEST04 APP_USER_PROFILE USER01 ... (3 Replies)
Discussion started by: newbie_01
3 Replies

10. UNIX for Beginners Questions & Answers

Awk/sed command to extract the string between 2 patterns but having some particular value

Hi - i have one file with content as below. ***** BEGIN 123 ***** BASH is awesome ***** END ***** ***** BEGIN 365 ***** KSH is awesome ***** END ***** ***** BEGIN 157 ***** KSH is awesome ***** END ***** ***** BEGIN 7123 ***** C is awesome ***** END ***** I am trying to find all... (4 Replies)
Discussion started by: reldb
4 Replies

LEARN ABOUT DEBIAN

extractor

EXTRACTOR(1)						  The Canonical Csound Reference					      EXTRACTOR(1)

NAME

       extractor - Extract a section of audio from an audio file. .

DESCRIPTION

       Extract a section of audio, by time or sample, from an existing sound file.

SYNTAX

	   extractor [OPTIONS ... ] infile

INITIALIZATION

       Flags:

       o   -S integer = Start the extract at the given sample number.

       o   -Z integer = End the extract at the given sample number.

       o   - Q integer = Extract given number of samples.

       o   -T fpnum = Start the extract at the given time in seconds.

       o   -E fpnum = End the extract at the given time in seconds.

       o   -D fpnum = Extract given time in seconds.

       o   -v = Verbose mode.

       o   -R = Continually rewrite the header while writing soundfile (WAV/AIFF).

       o   -H integer = Show a "heart-beat" to indicate progress, in style 1, 2 or 3.

       o   -N = Alert call (usually ringing the bell) when finished.

       o   -v = Verbose mode.

       o   -o fname = output file name (default: test.wav)

EXAMPLES

       The default values are

	       extractor -S 0 -Z end-of-file -otest

       For example

	       extractor -S 10234 -D 2.13 in.aiff -o out.wav

       This creates a new sound file taken from sample 10234 and lasting 2.13 seconds.

CREDITS

       Author: John ffitch

       1994

AUTHORS

       Barry Vercoe
       MIT Media Lab

	   Author.

       Dan Ellis
       MIT Media Lab,
		 Cambridge
		 Massachussetts

	   Author.

COPYRIGHT

5.10								    08/01/2011							      EXTRACTOR(1)
All times are GMT -4. The time now is 07:20 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy