Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: AWK delete issue
Top Forums Shell Programming and Scripting AWK delete issue Post 302574331 by jamie_123 on Thursday 17th of November 2011 05:48:42 AM
Old 11-17-2011
Hi,

Thanks to the both of you. I have no clue why the same post was made twice earlier..didnt mean it.

The issue that I had was solved by changing the syntax of print statement. I was using printf "%s\n", "blah blah: " $0; when I changed it to print $0 it worked fine. Have no clue why, but it works now without crashing mid way. Can anyone point me at the mistake here?

Thanks again!

I have a file now with two columns, the first one having epoch times. I am interested in extracting hourly times from this whole table. I tried something like this- awk '/1319130869/, $NF ~ /1319130870/ '. It works when the time that I am extracting is at the end of the file. when doing the same for values at the begining it returns me all the values. Should I try something else to do this? or is something like sed a better option here?
Please help me out.
Thanks in advance!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk : delete ^M at the end of the line

Hi all, I'm newbi in scripting. could someone tell how to delete the ^M at the end of the linie with an awk command. many thanks in advance. (2 Replies)
Discussion started by: liliput
2 Replies

2. UNIX for Dummies Questions & Answers

delete files using awk

The code below works for finding files created in 2005 that are compressed. How do I delete these files? Do I substitute rm -f for the print $0 ? here's the code that finds the 2005 compressed files (ls -lR | awk '$8 == "2005" && $9 ~ /Z$/ {print $0}') thanks for your help!!! (2 Replies)
Discussion started by: igidttam
2 Replies

3. Shell Programming and Scripting

awk - delete last two letters

Hello! How do I remove the last two letters "GB" off each line, using awk? What I need to remove is the "GB" in following input: ..... 30GB 2504GB 3GB 40GB ...... The OS used is Solaris9 Regards, Fredrik (1 Reply)
Discussion started by: sap4ever
1 Replies

4. Shell Programming and Scripting

how to delete line with awk

Hi I have a multi -line file which is sorted by the 1-st colomn in the following format: 400 0000 0001 1000 1010 0111 0000 1000 0000 402 1101 0000 1100 1010 0111 1000 1000 0000 403 1001 0000 1100 1010 0111 0000 1000 0000 495 1000 0000 1100 1010 0111 0000 1000 0000 500 0000 0001 1000 0010... (2 Replies)
Discussion started by: aoussenko
2 Replies

5. Shell Programming and Scripting

delete string using AWK

inputfile has 3 columns SCHEMA.TAB1 COL1 LENGTH SCHEMA.TAB2 COL2 LENGTH. If i use awk on the above inputfile awk '{print $1}' inputfile.The out put will be SCHEMA.TAB1 SCHEMA.TAB2. But from the above output i need to delete SCHEMA. i.e i don't want the string "SCHEMA." should... (6 Replies)
Discussion started by: rocking77
6 Replies

6. Shell Programming and Scripting

Delete text between square brackets and also delete those square brackets using sed or awk

Hi All, I have a text file which looks like this: computer programming systems engineering I want to get rid of these square brackets and also the text that is inside these brackets. So that my final text file looks like this: computer programming systems engineering I am using... (3 Replies)
Discussion started by: shoaibjameel123
3 Replies

7. Shell Programming and Scripting

Delete certain column awk

Hi experts, I have a file, where inside this file contains multiple columns (up to 2000 columns): 0.05 0.54 2.02 0.21 1.39 2.92 0.31 1.75 3.34 I want to delete column 3,6,9,12,15,18,21... etc (any columns where can be divided from value 3), so that results is like: 0.05 0.54 0.21 1.39... (6 Replies)
Discussion started by: guns
6 Replies

8. UNIX for Dummies Questions & Answers

Using awk to delete a certain line

Ok I have a file that contains #num.txt 1 2 3 4 5 6 7 8 9 my script main.sh checks to see if the first two arguments exist in a seperate file and the third argument would be the value in the num.txt so when i execute $ main.sh name place 5 how would i go about deleteing the... (13 Replies)
Discussion started by: austing5
13 Replies

9. Shell Programming and Scripting

Variable value substitution issue with awk command issue

Hi All, I am using the below script which has awk command, but it is not returing the expected result. can some pls help me to correct the command. The below script sample.ksh should give the result if the value of last 4 digits in the variable NM matches with the variable value DAT. The... (7 Replies)
Discussion started by: G.K.K
7 Replies

10. Shell Programming and Scripting

Delete big directory issue

Hello folks, I am deleting a directory with script it is taking 11Hour and also increase the IO on server. I am using below command, inside date directory there are hour directories, which i am deleting after archiving. Archiving is not taking long time, only "rm -rf" is taking alot of time with... (21 Replies)
Discussion started by: learnbash
21 Replies

LEARN ABOUT DEBIAN

time::piece::mysql

Time::Piece::MySQL(3pm) 				User Contributed Perl Documentation				   Time::Piece::MySQL(3pm)

NAME

       Time::Piece::MySQL - Adds MySQL-specific methods to Time::Piece

SYNOPSIS

	 use Time::Piece::MySQL;

	 my $time = localtime;

	 print $time->mysql_datetime;
	 print $time->mysql_date;
	 print $time->mysql_time;

	 my $time = Time::Piece->from_mysql_datetime( $mysql_datetime );
	 my $time = Time::Piece->from_mysql_date( $mysql_date );
	 my $time = Time::Piece->from_mysql_timestamp( $mysql_timestamp );

DESCRIPTION

       Using this module instead of, or in addition to, "Time::Piece" adds a few MySQL-specific date-time methods to "Time::Piece" objects.

OBJECT METHODS

   mysql_date / mysql_time / mysql_datetime / mysql_timestamp
       Returns the date and/or time in a format suitable for use by MySQL.

CONSTRUCTORS

   from_mysql_date / from_mysql_datetime / from_mysql_timestamp
       Given a date, datetime, or timestamp value as returned from MySQL, these constructors return a new Time::Piece object.  If the value is
       NULL, they will retrun undef.

   CAVEAT
       "Time::Piece" itself only works with times in the Unix epoch, this module has the same limitation.  However, MySQL itself handles date and
       datetime columns from '1000-01-01' to '9999-12-31'.  Feeding in times outside of the Unix epoch to any of the constructors has
       unpredictable results.

       Also, MySQL doesn't validate dates (because your application should); it only checks that dates are in the right format.  So, your database
       might include dates like 2004-00-00 or 2001-02-31.  Passing invalid dates to any of the constructors is a bad idea: on my system the former
       type (with zeros) returns undef (previous version used to die) while the latter returns a date in the following month.

AUTHOR

       Original author: Dave Rolsky <autarch@urth.org>

       Current maintainer: Marty Pauley <marty+perl@kasei.com>

COPYRIGHT

       (c) 2002 Dave Rolsky

       (c) 2004 Marty Pauley

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

SEE ALSO

       Time::Piece

perl v5.12.4							    2008-06-07						   Time::Piece::MySQL(3pm)
All times are GMT -4. The time now is 11:01 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy