Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

perl instead of grep 'conversion' help?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting perl instead of grep 'conversion' help?
# 1  
Old 09-12-2010
perl instead of grep 'conversion' help?
Hello:

I butchered a shell script together, but my script kung-fu is 5 years old and all I've used for 5 years are for i loops. I hope that some perl guru can do in 5 minutes what takes me 5 weeks, so I am asking for help.

I have a simple script using "grep -A 2 'string' /path/to/file" but after importing my data into it (if's a FF plugin called ReminderFox), the rows are "re-ordered"

script now outputs: (source ics file is 'US Holidays')
  1. SUMMARY:Washington's Birthday
    DTSTART;VALUE=DATE:20090216
    DTEND;VALUE=DATE:20090217

But grep'ing with the same command on my backup file, I get this kind of output:
  1. SUMMARY:Technical Support Specialist
    UID:1281092384117-979283602
    DTSTART:20100812T085900''

In simplest terms, my request is...
I'd like to have these fields from any ics file that has them:
SUMMARY:
DTSTART;VALUE=DATE:
DTEND;VALUE=DATE:
(and echo a newline)

and if possible convert DTSTART|DTEND data...
from it's current format of "+%Y%m%d" to "+%h %m %Y"

This is NOT homework.
Bash = GNU bash, version 4.0.38 | Awk = GNU Awk 3.1.7
Grep = GNU grep 2.6.3 | perl = 5.10.0

I hope this is clear. Smilie
Thank you for your time.
# 2  
Old 09-12-2010
Quote:
Originally Posted by Habitual
...
In simplest terms, my request is...
I'd like to have these fields from any ics file that has them:
SUMMARY:
DTSTART;VALUE=DATE:
DTEND;VALUE=DATE:
(and echo a newline)

and if possible convert DTSTART|DTEND data...
from it's current format of "+%Y%m%d" to "+%h %m %Y"

...
I will assume you meant "+%d %m %Y" and not "+%h %m %Y".

Code:
$ 
$ 
$ perl -lne '/SUMMARY/ && print;
             /(DTSTART;VALUE=DATE:)(\d{4})(\d\d)(\d\d)/ && print "$1$4 $3 $2";
             /(DTEND;VALUE=DATE:)(\d{4})(\d\d)(\d\d)/ && print "$1$4 $3 $2\n"
            ' basic.ics
DTSTART;VALUE=DATE:16 02 2009
DTEND;VALUE=DATE:17 02 2009

SUMMARY:Washington's Birthday
DTSTART;VALUE=DATE:15 02 2010
DTEND;VALUE=DATE:16 02 2010

SUMMARY:Washington's Birthday
DTSTART;VALUE=DATE:11 11 2009
DTEND;VALUE=DATE:12 11 2009

SUMMARY:Veterans Day
DTSTART;VALUE=DATE:11 11 2010
DTEND;VALUE=DATE:12 11 2010

...
... <output snipped for brevity>
...

SUMMARY:Christmas
DTSTART;VALUE=DATE:01 04 2010
DTEND;VALUE=DATE:02 04 2010

SUMMARY:April Fool's Day
DTSTART;VALUE=DATE:01 04 2009
DTEND;VALUE=DATE:02 04 2009

SUMMARY:April Fool's Day
$ 
$ 
$

tyler_durden
# 3  
Old 09-12-2010
tyler:

Flawless! it works great.
Yes, I meant date "+%h %m %Y"
I like my stuff 'human readable" (Sep 09 2010 vs 12 09 2010)

n/m I just swapped out
"$1$4 $3 $2" with
"$1$3 $4 $2"

How can I save that into a .pl file, and run it later?
and how about only showing the current year?

Thank you for your time, sir. I greatly appreciate it.
Last edited by Habitual; 09-12-2010 at 08:56 PM..
# 4  
Old 09-13-2010
Quote:
Originally Posted by Habitual
...
How can I save that into a .pl file, and run it later?
and how about only showing the current year?
...
How to save it into a .pl file ?
Well, open up your favorite text editor, type in the Perl program, save and quit so that "cat -n basic.pl" spews something like the following:

Code:
$ 
$ 
$ cat -n basic.pl
     1    #!/usr/bin/perl -w
     2    # determine the current year first
     3    my $year = (localtime)[5]+1900;
     4    # set the "ics" file
     5    my $file = "basic.ics";
     6    # process the file now
     7    open (F, $file) or die "Can't open $file: $!";
     8    while (<F>) {
     9      if (/SUMMARY/) {
    10        print;
    11      } elsif (/(DTSTART;VALUE=DATE:)($year)(\d\d)(\d\d)/) {
    12        print "$1$3 $4 $2\n";
    13      } elsif (/(DTEND;VALUE=DATE:)($year)(\d\d)(\d\d)/) {
    14        print "$1$3 $4 $2\n\n"
    15      }
    16    }
    17    close (F) or die "Can't close $file: $!";
$ 
$ perl basic.pl
SUMMARY:Washington's Birthday
DTSTART;VALUE=DATE:02 15 2010
DTEND;VALUE=DATE:02 16 2010

SUMMARY:Washington's Birthday
SUMMARY:Veterans Day
DTSTART;VALUE=DATE:11 11 2010
DTEND;VALUE=DATE:11 12 2010

...
... <output snipped for brevity>
...

SUMMARY:Christmas Eve
SUMMARY:Christmas Eve
DTSTART;VALUE=DATE:12 25 2010
DTEND;VALUE=DATE:12 26 2010

SUMMARY:Christmas
SUMMARY:Christmas
DTSTART;VALUE=DATE:04 01 2010
DTEND;VALUE=DATE:04 02 2010

SUMMARY:April Fool's Day
SUMMARY:April Fool's Day
$ 
$

The program takes into account the current year requirement as well.

tyler_durden
# 5  
Old 09-13-2010
By awk, and GNU date.

Code:
awk '
BEGIN{FS=OFS=":"}
/^SUMMARY/{print}
/DTSTART;VALUE=/||/DTEND;VALUE=/{"date -d "$NF" \"+%h %m %Y\" "|getline $NF;print}
' infile


SUMMARY:Washington's Birthday
DTSTART;VALUE=DATE:Sep 09 2010
DTEND;VALUE=DATE:Sep 09 2010

Last edited by rdcwayx; 09-13-2010 at 12:57 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl - TimeDate format conversion

Dear All, I need to print the below value from excel column 20160219T05:21:59+0100 to 19-FEB-2016 05:21:11 Can anyone help on this datetime format conversion. Please suggest in print logic itself. Regards, Kumaresan P (6 Replies)
Discussion started by: Kumaresanpvk
6 Replies

2. Shell Programming and Scripting

conversion of loop in perl

Hello Sir, How can i convert below two loop lines in perl for BLOCK in /sys/block/myblock* for BLOCK in /dev/myblock* How i can write them in perl like foreach( </sys/block/myblock*/queue/nr_requests> ) (5 Replies)
Discussion started by: learnbash
5 Replies

3. Shell Programming and Scripting

conversion of code in perl and python

How to convert below bash code in perl and python. for BLOCK in /sys/block/emcpow* do echo "100000" > "$BLOCK"/queue/nr_requests echo "noop" > "$BLOCK"/queue/scheduler done (2 Replies)
Discussion started by: learnbash
2 Replies

4. Shell Programming and Scripting

Timestamp conversion in PERL

Hi, I have a file as below I need to overwrite the 2 nd column alone to numeric format like "06122011030414012345" as per the timestamp value output file should be the microseconds can be neglected if required. Any help will be appreciated. Thanks in advance (1 Reply)
Discussion started by: irudayaraj
1 Replies

5. Shell Programming and Scripting

Conversion from Perl to Shell scripting

Hai ! I am doing a research on Bioinformatics and a part of the code in perl have to be converted to shell scripting. I am new to shell programming. Pls. kindly help me to convert this code to shell script though it is somewhat lengthy. PLS KINDLY HELP ME. THANKS IN ADVANCE. my @FreeEnergy =... (1 Reply)
Discussion started by: kswapnadevi
1 Replies

6. Shell Programming and Scripting

Perl Conversion Tool

I want a perl script that converts special characters (French, German, Italy, Denmark character set) into database compatible format and retrieves the back in the original format. A generic functionality will be developed which converts any special characters (having > 8 bit format). I tried... (3 Replies)
Discussion started by: perl2ask
3 Replies

7. Shell Programming and Scripting

Encoding conversion in PERL script

I have oracle 9i database installed with UTF-8 Encoding. I want a perl script that converts unicode to utf8 before commiting in database and utf8 to unicode when retreiving from database For example : the word Ïntêrnatïônàlîzâtion has to be stored in database as Internationalization and when retreived... (6 Replies)
Discussion started by: vkca
6 Replies

8. Shell Programming and Scripting

[Perl] Timestamp conversion

Hi, I have searched, read and tried, but no luck. I have this code: #!/bin/perl -w #-d use strict; use POSIX qw(strftime); my $getprpw_list="/usr/lbin/getprpw -l"; my $host = "nbsol151"; my $user = "genadmin"; my %uid; my %spwchg; my %upwchg; my %slogint; (2 Replies)
Discussion started by: ejdv
2 Replies

9. Shell Programming and Scripting

Perl in KSH - julian conversion

Hello Everyone, I have this code misbehaving in one of my scripts, I have a var containing the sequential number of the day for the year and I am suppose to get the regular date for that day and its weekday. If I set the day to 273 I get back 2008/09/31 which is not a proper date. can you help... (7 Replies)
Discussion started by: gio001
7 Replies

10. UNIX for Dummies Questions & Answers

Another bash shell to perl conversion

Hello everyone. I am new to linux and need help again. I need help converting this bash shell to linux: for i in `ls -l *.txt` do `./cnvidtf.pl $i` `curl -u login:pswd --disable-espv -T loadfile.seq ftp://11.1.11.1` `mysql -u login -h 11.1.11.1 -ppswd < lddocs.sql` done Thanks! Any help... (6 Replies)
Discussion started by: freak
6 Replies
Login or Register to Ask a Question