Sponsored Content
Top Forums Shell Programming and Scripting awk/sed to search & replace data in first column Post 302542868 by rdcwayx on Friday 29th of July 2011 12:16:46 AM
Old 07-29-2011
The source file format is strange.

in your sample, there are two different dates displayed.

Mon Jul 18 00:32:52 EDT 2011
Jul 19 2011
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help, sed search&replace

Plzzzz, tell me some script about this... What does this mean ? sed '/^ */s///' sed '/^/s// /' and why it's diferent ??? sed '/ */s// /g' and sed 's/ */ /g'. It's all the same ??? Thanks you very much (2 Replies)
Discussion started by: mle
2 Replies

2. Shell Programming and Scripting

awk/sed column replace using column header - help

$ cat log.txt Name Age Sex Lcation nfld alias xsd CC 25 M XYZ asx KK Y BB 21 F XAS awe SS N SD 21 M AQW rty SD A How can I replace the column with header "Lcation" with the column with header "alias" and delete the "alias" column? so that the final output will become: Name Age Sex... (10 Replies)
Discussion started by: jkl_jkl
10 Replies

3. Shell Programming and Scripting

Help with sed search&replace between two strings

Hi, i read couple of threads here on forum, and googled about what bugs me, yet i still can't find solution. Problem is below. I need to change this string (with sed if it is possible): This is message text that is being quoted to look like this: This is message text that is being quotedI... (2 Replies)
Discussion started by: angrybb
2 Replies

4. Shell Programming and Scripting

awk/sed string search and replace

Need help with either sed or awk to acheive the following file1 ----- In the amazon forest The bats eat all the time... mon tue wed they would eat berries In the tropical forest The bats eat all the time... on wed bats eat nuts In the rain forest The bats eat all the time... on... (2 Replies)
Discussion started by: jville
2 Replies

5. Shell Programming and Scripting

Using sed to search and replace data

Hi, Kindly need your expertise in this problem. I have to search and replace data. The problem is, the data is in the same format but slightly different content. What I need is sed commands that can work for those "slightly different content". input: ... (3 Replies)
Discussion started by: Alvin123
3 Replies

6. Shell Programming and Scripting

Search & replace content using awk/gsub

Hi, I have two files master.txt & reference.txt. Sample below Master.txt 2372,MTS,AP 919848001104,Airtel,DL 0819,MTS,MUM 919849788001,Airtel,AP 1430,Aircel MP,20 Reference.txt 2372,919848701430,46467 919848002372,2372,47195 2372,919849788001,59027 0819,028803,1 0819,029801,1... (2 Replies)
Discussion started by: siramitsharma
2 Replies

7. Shell Programming and Scripting

Search & Replace content of files using gsub in awk

Hi,I have 2 files master.txt & reference.txt as shown below & i require o/p as mentioned in file 3 using awk but content is not replacing properlymaster.txt:... (15 Replies)
Discussion started by: siramitsharma
15 Replies

8. Shell Programming and Scripting

awk to search for specific line and replace nth column

I need to be able to search for a string in the first column and if that string exists than replace the nth column with "-9.99". AW12000012012 2.38 1.51 3.01 1.66 0.90 0.91 1.22 0.82 0.57 1.67 2.31 3.63 0.00 AW12000012013 1.52 0.90 1.20 1.34 1.21 0.67 ... (14 Replies)
Discussion started by: ncwxpanther
14 Replies

9. Shell Programming and Scripting

How to search and replace string in column in file with command sed?

how to search and replace string in column in file with command sed or other search "INC0000003.in" and replace column 4 = "W" $ cat file.txt INC0000001.in|20150120|Y|N|N INC0000002.in|20150120|Y|N|N INC0000003.in|20150120|Y|N|N INC0000004.in|20150120|Y|N|Noutput... (4 Replies)
Discussion started by: ppmanja3
4 Replies

10. Shell Programming and Scripting

awk search and replace nth column by using a variable.

I am passing a variable and replace nth value with the variable. I tried using many options in awk command but unable to ignore the special characters in the output and also unable to pass the actual value. Input : "1","2","3" Output : "1","1000","3" TempVal=`echo 1000` Cat... (2 Replies)
Discussion started by: onesuri
2 Replies
DateTime::Format::Mail(3pm)				User Contributed Perl Documentation			       DateTime::Format::Mail(3pm)

NAME
DateTime::Format::Mail - Convert between DateTime and RFC2822/822 formats SYNOPSIS
use DateTime::Format::Mail; # From RFC2822 via class method: my $datetime = DateTime::Format::Mail->parse_datetime( "Sat, 29 Mar 2003 22:11:18 -0800" ); print $datetime->ymd('.'); # "2003.03.29" # or via an object my $pf = DateTime::Format::Mail->new(); print $pf->parse_datetime( "Fri, 23 Nov 2001 21:57:24 -0600" )->ymd; # "2001-11-23" # Back to RFC2822 date use DateTime; my $dt = DateTime->new( year => 1979, month => 7, day => 16, hour => 16, minute => 45, second => 20, time_zone => "Australia/Sydney" ); my $str = DateTime::Format::Mail->format_datetime( $dt ); print $str; # "Mon, 16 Jul 1979 16:45:20 +1000" # or via an object $str = $pf->format_datetime( $dt ); print $str; # "Mon, 16 Jul 1979 16:45:20 +1000" DESCRIPTION
RFCs 2822 and 822 specify date formats to be used by email. This module parses and emits such dates. RFC2822 (April 2001) introduces a slightly different format of date than that used by RFC822 (August 1982). The main correction is that the preferred format is more limited, and thus easier to parse programmatically. Despite the ease of generating and parsing perfectly valid RFC822 and RFC2822 people still get it wrong. So this module provides four things for those handling mail dates: 1 A strict parser that will only accept RFC2822 dates, so you can see where you're right. 2 A strict formatter, so you can generate the right stuff to begin with. 3 A loose parser, so you can take the misbegotten output from other programs and turn it into something useful. This includes various minor errors as well as some somewhat more bizarre mistakes. The file t/sample_dates in this module's distribution should give you an idea of what's valid, while t/invalid.t should do the same for what's not. Those regarded as invalid are just a bit too strange to allow. 4 Interoperation with the rest of the DateTime suite. These are a collection of modules to handle dates in a modern and accurate fashion. In particular, they make it trivial to parse, manipulate and then format dates. Shifting timezones is a doddle, and converting between formats is a cinch. As a future direction, I'm contemplating an even stricter parser that will only accept dates with no obsolete elements. CONSTRUCTORS
new Creates a new "DateTime::Format::Mail" instance. This is generally not required for simple operations. If you wish to use a different pars- ing style from the default, strict, parser then you'll need to create an object. my $parser = DateTime::Format::Mail->new() my $copy = $parser->new(); If called on an existing object then it clones the object. It has two optional named parameters. o "loose" should be a true value if you want a loose parser, else either don't specify it or give it a false value. o "year_cutoff" should be an integer greater than or equal to zero specifying the cutoff year. See "set_year_cutoff" for details. my $loose = DateTime::Format::Mail->new( loose => 1 ); my $post_2049 = DateTime::Format::Mail->new( year_cutoff => 60 ); clone For those who prefer to explicitly clone via a method called "clone()". If called as a class method it will die. my $clone = $original->clone(); PARSING METHODS
These methods work on either our objects or as class methods. loose, strict These methods set the parsing strictness. my $parser = DateTime::Format::Mail->new; $parser->loose; $parser->strict; # (the default) my $p = DateTime::Format::Mail->new->loose; parse_datetime Given an RFC2822 or 822 datetime string, return a "DateTime" object representing that date and time. Unparseable strings will cause the method to die. See the synopsis for examples. set_year_cutoff Two digit years are treated as valid in the loose translation and are translated up to a 19xx or 20xx figure. By default, following the specification of RFC2822, if the year is greater than '49', it's treated as being in the 20th century(19xx). If lower, or equal, then the 21st(20xx). That is, 50 becomes 1950 while 49 is 2049. "set_year_cutoff()" allows you to modify this behaviour by specifying a different cutoff. The return value is the object itself. $parser->set_year_cutoff( 60 ); year_cutoff Returns the current cutoff. Can be used as either a class or object method. my $cutoff = $parser->set_year_cutoff; default_cutoff Returns the default cutoff. A useful method to override for subclasses. my $default = $parser->default_cutoff; fix_year Takes a year and returns it normalized. my $fixed = $parser->fix_year( 3 ); FORMATTING METHODS
format_datetime Given a "DateTime" object, return it as an RFC2822 compliant string. use DateTime; use DateTime::Format::Mail; my $dt = DateTime->new( year => 1979, month => 7, day => 16, time_zone => 'UTC' ); my $mail = DateTime::Format::Mail->format_datetime( $dt ); print $mail, " "; # or via an object my $formatter = DateTime::Format::Mail->new(); my $rfcdate = $formatter->format_datetime( $dt ); print $rfcdate, " "; THANKS
Dave Rolsky (DROLSKY) for kickstarting the DateTime project. Roderick A. Anderson for noting where the documentation was incomplete in places. Joshua Hoblitt (JHOBLITT) for inspiring me to check what the standard said about interpreting two digit years. SUPPORT
Support for this module is provided via the datetime@perl.org email list. See <http://datetime.perl.org/mailing_list.html> for more details. Alternatively, log them via the CPAN RT system via the web or email: http://rt.cpan.org/NoAuth/ReportBug.html?Queue=DateTime%3A%3AFormat%3A%3AMail bug-datetime-format-mail@rt.cpan.org This makes it much easier for me to track things and thus means your problem is less likely to be neglected. LICENCE AND COPYRIGHT
Copyright E<copy> Iain Truskett, 2003. All rights reserved. This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The full text of the licences can be found in the Artistic and COPYING files included with this module, or in perlartistic and perlgpl in Perl 5.8.1 or later. AUTHOR
Originally written by Iain Truskett <spoon@cpan.org>, who died on December 29, 2003. Maintained by Dave Rolsky <autarch@urth.org>. SEE ALSO
"datetime@perl.org" mailing list. <http://datetime.perl.org/> perl, DateTime RFCs 2822 and 822. perl v5.8.8 2007-09-11 DateTime::Format::Mail(3pm)
All times are GMT -4. The time now is 04:50 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy