Sponsored Content
Full Discussion: AWK--does anyone remember it
Top Forums Shell Programming and Scripting AWK--does anyone remember it Post 58970 by cnitadesigner on Monday 6th of December 2004 03:45:19 PM
Old 12-06-2004
Question AWK--does anyone remember it

I am trying to run awk on a 55 page Word document.
I wanted to delete every occurrence of <company>, <script>, </scripts> from the file then cut & paste all of the appropriate fields to an Excel spreadsheet.

Also the code is suppose to replace the dates in a new format such as "xxxx-xx-xx" Is there someone out there who can help?

I tried saving my code in a .exe file on Linux, as follows:
awk -F, Test1
BEGIN
{
date1[i]= " "
temp[i]= " "
date2[i]= " "
i = 0
for(i = 1; i <= NF; i = i + 1)
{
wk -F, Test1
BEGIN
{
date1[i]= " "
temp[i]= " "
date2[i]= " "
i = 0
for(i = 1; i <= NF; i = i + 1)
{
date1[i]= "20040811"

date2[i]="xxxx-xx-xx"
next

}

END
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

It's been awhile...help me remember

Well it's been a long time since I have used any OS besides apples and windows (raising my son). My principal would like our teachers to use UNIX as their mail system. That's not a problem, the mail system is like riding a bike you never forget. Here's my problem. She wants me to write a script... (2 Replies)
Discussion started by: catbad
2 Replies

2. UNIX for Dummies Questions & Answers

remember last visited line in vim

hi, I know we can do this; but dont know how.. I open a file using vim..browse thru it and then say :wq after reaching some line; The next time I open the same file, I want vim to position the cursor on the line where I left last time; anyone? (2 Replies)
Discussion started by: spopuri
2 Replies

3. UNIX for Dummies Questions & Answers

scripts remember the previous parameter???

I have a simple script. I have tried this in Bourne, Korn and C shells in my AIX ...no luck unset STARTQUEUE # Check parameters if then echo "*E* Batch Queue parameter is missing" else $BATCHQ/bin/setup.sh STARTQUEUE=$1 # If the queue doesn't exist, create it ... (3 Replies)
Discussion started by: KenL
3 Replies

4. Forum Support Area for Unregistered Users & Account Problems

Two Login's - Remember only one.

Hi All, Have only recently returned to Unix.com due to other activities (*oh the shame of it all). Anyways, when I initially came back to redesigned/revamped site I couldn't remember any of my logins. I'd originally thought that I'd used the UID of 'Cameron' but couldn't remember any details... (2 Replies)
Discussion started by: Cameron
2 Replies

5. Shell Programming and Scripting

remember processed files

Hello dear community! I have the following task to accomplish: there is a directory with approximately 2 thousand files. I have to write a script which would randomly extract 200 files on the first run. On the second run it should extract again 200 files but that files mustn't intersect with... (5 Replies)
Discussion started by: sidorenko
5 Replies

6. UNIX for Dummies Questions & Answers

Grep that I should know but I can't remember!

I have a master list of hosts, and a list of bad hosts. I want to filter out the bad hosts from the master list. I was trying a few for loops but it's not providing the desired result: for i in $(cat master_host_list);do grep -iv $i bad_host_list;done | sort | uniq # won't work because it... (5 Replies)
Discussion started by: MaindotC
5 Replies

7. What is on Your Mind?

Anyone remember this cute unix ad?

It showed a cleaning woman (probably in the evening, after most of the other employees had left work) happily typing commands on a dot matrix terminal (could've been a DEC LA120, IIRC) just because "unix is so easy to use, even a cleaning woman can use it!". If you know where to find a scanned... (2 Replies)
Discussion started by: mathiasbage
2 Replies

8. Post Here to Contact Site Administrators and Moderators

Log Out vs Remember Me

Howdy, I clicked the rememberer me when I log in, and evidently I really do not understand what that means. I had hoped that at least it would remember my user name for the next time that I log in. However, when I log out, I see a message about cookies being removed and one other thing that I... (1 Reply)
Discussion started by: danuke
1 Replies

9. UNIX for Beginners Questions & Answers

What is the best way to remember UNIX / Linux Commands?

Hi all, I'm new to UNIX world and new to this forum. As I observed there are lot of commands that needs to be remembered in UNIX programming. I'm into DevOps and can anyone please tell me what are all the important commands that are useful for DevOps Engineer. NOTE: Please correct me if my... (3 Replies)
Discussion started by: maxlink
3 Replies
Date::Manip::Examples(3)				User Contributed Perl Documentation				  Date::Manip::Examples(3)

NAME
Date::Manip::Examples - examples of how to use Date::Manip DESCRIPTION
This document includes a number of examples on how to do common Date::Manip operations. I will be happy to add new examples over time, and welcome suggestions and examples to include. In most cases, an example will include two different ways of getting the answer. The first way will be using the new (as of 6.00) OO modules. The second will be using the old-style functional interface. It should be noted that any time you want to work with alternate time zones, the OO interface is STRONGLY recommended since the functional interface does not preserve time zone information with the date, and may therefore give incorrect results in some cases. However, working in the time zone of the system should give correct results. It should be noted that, in the examples below, it appears that the OO method often requires more lines of code than the functional interface. There are a number of ways to shorten the OO method, but for the examples, I wanted to include all the steps explicitly. PARSING A DATE
Dates can be parsed in practically any form in common usage: OO method $date = new Date::Manip::Date; $err = $date->parse("today"); $err = $date->parse("1st Thursday in June 1992"); $err = $date->parse("05/10/93"); $err = $date->parse("12:30 Dec 12th 1880"); $err = $date->parse("8:00pm December tenth"); Functional $date = ParseDate("today"); $date = ParseDate("1st Thursday in June 1992"); $date = ParseDate("05/10/93"); $date = ParseDate("12:30 Dec 12th 1880"); $date = ParseDate("8:00pm December tenth"); The Date::Manip::Date manual has a list of all valid formats. PARSING AN AMOUNT OF TIME
Amounts of time (referred to as deltas) can also be parsed: OO method $delta = new Date::Manip::Delta; $err = $delta->parse("in 12 hours"); $err = $delta->parse("-1:30:0"); $err = $delta->parse("4 business days later"); Functional $delta = ParseDateDelta("in 12 hours"); $delta = ParseDateDelta("-1:30:0"); $delta = ParseDateDelta("4 business days later"); TO CALCULATE THE AMOUNT OF TIME BETWEEN TWO DATES
$datestr1 = "Jan 30 1999 13:00 EST"; $datestr2 = "2/Mar/1999 15:30:00 +0500"; OO method $date1 = new Date::Manip::Date; $date2 = $date1->new_date(); $err = $date1->parse($datestr1); $err = $date2->parse($datestr2); To get an exact amount of time between the two dates (expressed only in terms of weeks, days, hours, minutes, seconds), use: $delta = $date1->calc($date2); To get an approximate amount of time (expressed in terms of years, months, weeks, etc. in terms that a human would typically think of), use: $delta = $date1->calc($date2,"approx"); Functional $date1 = ParseDate($string1); $date2 = ParseDate($string2); To get an exact amount: $delta = DateCalc($date1,$date2); and the approximate amount: $delta = DateCalc($date1,$date2,1); The Date::Manip::Calc manual has information about these, and other types of calculations. TO ADD AN AMOUNT OF TIME TO A DATE
To find a second date a given amount of time before or after a first date, use the following: $datestr = "Jan 30 1999 13:00 EST"; $deltastr = "12 hours ago"; $deltastr = "in 3 business days"; OO method $date = new Date::Manip::Date; $delta = $date->new_delta(); $date->parse($datestr); $delta->parse($deltastr); $d = $date->calc($delta); Functional $date = DateCalc($datestr,$deltastr); If the delta is a business delta, it will do a business mode calculation. The Date::Manip::Calc manual has information about these, and other types of calculations. COMPARE TWO DATES
To take two different dates and see which is earlier, do the following: $datestr1 = "Jan 30 1999 13:00 EST"; $datestr2 = "2/Mar/1999 15:30:00 +0500"; OO method $date1 = new Date::Manip::Date; $date2 = $date1->new_date; $date1->parse($datestr1); $date2->parse($datestr2); $date1->cmp($date2); => -1, 0, 1 Functional $date1 = ParseDate($datestr1); $date2 = ParseDate($datestr2); Date_Cmp($date1,$date2); => -1, 0, 1 TO EXTRACT INFORMATION ABOUT A DATE OR DELTA
If you have a date or a delta, you can extract information about them as follows: $datestr = "1:24:08 PM EST Feb 3, 1996"; $deltastr = "12 hours ago"; OO method $date = new Date::Manip::Date; $delta = $date->new_delta(); $date->parse($datestr); $delta->parse($deltastr); $str = $date->printf("It is now %T on %b %e, %Y."); => "It is now 13:24:08 on Feb 3, 1996." $str = $delta->printf("In %hv hours, %mv minutes, %sv seconds"); => "In -12 hours, 0 minutes, 0 seconds"; Functional $str = UnixDate($datestr,"It is now %T on %b %e, %Y."); => "It is now 13:24:08 on Feb 3, 1996." $str = Delta_Format($deltastr,"In %hv hours, %mv minutes, %sv seconds"); => "In -12 hours, 0 minutes, 0 seconds"; The Date::Manip::Date manual contains all of the format codes that can be used to extract information from a date. The Date::Manip::Delta manual contains the codes for a delta. WORKING WITH EPOCH
Date::Manip can easily be used to work with the number of seconds since the epoch (Jan 1, 1970 00:00:00 UTC). If you have a date, and you want to find out how many seconds it is after the epoch, you can do it in the following ways: $datestr = "1999-04-30-15:30:00 EDT"; $secs = 1234567; OO method To find out how many seconds have elapsed on a certain date, you can do the following: $date = new Date::Manip::Date; $err = $date->parse($datestr); $str = $date->printf('%s'); => number of seconds To find out the date that is a certain number of seconds since the epoch, you can use the following: $date = new Date::Manip::Date; $err = $date->parse("epoch $secs"); $date now contains the date wanted (in the local time zone) Functional To find out how many seconds have elapsed: $str = UnixDate($datestr,'%s'); => number of seconds To find the date that is a number of seconds since the epoch: $date = ParseDateString("epoch $secs"); Note that Date::Manip will work with both positive seconds (for dates that have come since the epoch) and negative seconds (for dates that occurred before the epoch). RECURRING EVENTS
To find a list of dates where a recurring event happens (even very complex recurrences), do the following: OO method # To find the 2nd Tuesday of every month from Jan 1 1999 to Apr 30 1999 $recur = new Date::Manip::Recur; $start = $recur->new_date(); $end = $recur->new_date(); $start->parse("Jan 1 1999"); $end->parse("Apr 30 1999"); $recur->parse("0:1*2:2:0:0:0",$start,$end); @date = $recur->dates(); # To find the Monday after Easter in 1997-1999 $recur = new Date::Manip::Recur; $recur->parse("*1997-1999:0:0:0:0:0:0*EASTER,ND1"); @date = $recur->dates(); Functional # To find the 2nd Tuesday of every month from Jan 1 1999 to Apr 30 1999 @date = ParseRecur("0:1*2:2:0:0:0","","Jan 1 1999","Apr 30 1999"); # To find the Monday after Easter in 1997-1999. @date = ParseRecur("*1997-1999:0:0:0:0:0:0*EASTER,ND1"); The Date::Manip::Recur manual contains information about recurring events. WORKING WITH DATES IN ANOTHER LANGUAGE
If you want to work with dates in a language other than English (but you are only working with a single language), do the following: OO method $date = new Date::Manip::Date; $date->config("Language","French","DateFormat","non-US"); $date->parse("1er decembre 1990"); Functional Date_Init("Language=French","DateFormat=non-US"); $date = ParseDate("1er decembre 1990"); The Date::Manip::Config manual has a list of all supported languages (in the section on the Language config variable). The meaning of the DateFormat config variable is also included. WORKING WITH TWO DIFFERENT LANGUAGES
If you want to work with dates in two (or more) languages, it is STRONGLY recommended that you use the OO interface. The functional interface will be much slower since it has to re-initialize a lot of language-specific stuff every time you switch back and forth between languages. OO method $date_eng = new Date::Manip::Date; $date_eng->config("Language","English","DateFormat","US"); $date_fre = new Date::Manip::Date; $date_fre->config("Language","French","DateFormat","non-US"); Use the $date_eng object to do English operations, the $date_fre object to do French operations. Functional If you are working with both French and English dates, you can call the following to switch between them: Date_Init("Language=French","DateFormat=non-US"); Date_Init("Language=English","DateFormat=US"); This is NOT recommended. Use the OO method instead. BUGS AND QUESTIONS
Please refer to the Date::Manip::Problems documentation for information on submitting bug reports or questions to the author. SEE ALSO
Date::Manip - main module documentation LICENSE
This script is free software; you can redistribute it and/or modify it under the same terms as Perl itself. AUTHOR
Sullivan Beck (sbeck@cpan.org) perl v5.16.3 2014-06-09 Date::Manip::Examples(3)
All times are GMT -4. The time now is 12:40 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy