Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Compare date in .txt with system date and remove if it's lesser than system date Post 303030188 by bakunin on Thursday 7th of February 2019 04:25:56 AM
Old 02-07-2019
Quote:
Originally Posted by Stuti
Can someone help me with the code wherein there is a file f1.txt with different column and 34 column have expiry date and I need to get that and compare with system date and if expiry date is <system date remove those rows and other rows should be moved to new file f2.txt .
I don't want to delete f1.txt
Could you please elaborate a little:

- What is your operating system, its version, which shell do you use, which version is it, .... ?
- can you post (within CODE-tags!) a sample of this f1.txt file?
- what exactly do you mean by "system date"? The output of the date command on the system?

I hope this helps.

bakunin
 

10 More Discussions You Might Find Interesting

1. Linux

compare files in the system with last modified date

HI, I have some files in my Linux machine that are very old and occupy a HUGe amount of space. I am trying to delete these files from the system so that it will be easy for me to add some files. I would like to know if this can done through a Perl or a shell script. What i want to do is i... (6 Replies)
Discussion started by: bsandeep_80
6 Replies

2. Shell Programming and Scripting

Compare date from db2 table to yesterday's Unix system date

I am currently running the following Korn shell script which works fine: #!/usr/bin/ksh count=`db2 -x "select count(*) from schema.tablename"` echo "count" I would like to add a "where" clause to the 2nd line that would allow me to get a record count of all the records from schema.tablename... (9 Replies)
Discussion started by: sasaliasim
9 Replies

3. Shell Programming and Scripting

Set system date to some date (Sunos)

I am testing a script and need to change the system date to Nov 30 2009. I cannot seem to find a way to do this other than TZ command but it does not seem to work correctly. I tried TZ=GMT+168 date but it is returning todays date Mon Dec 7 19:48:11 GMT 2009 ...instead of Nov 30 2009 I... (4 Replies)
Discussion started by: hanton
4 Replies

4. Shell Programming and Scripting

how to get what date was 28 days ago of the current system date IN UNIX

Hi, Anybody knows how to get what date was 28 days ago of the current system date through UNIX script. Ex : - If today is 28th Mar 2010 then I have to delete the files which arrived on 1st Mar 2010, (15 Replies)
Discussion started by: kandi.reddy
15 Replies

5. UNIX for Dummies Questions & Answers

Delete a row from a file if one column containing a date is greater than the current system date

Hello gurus, I am hoping someone can help me with the required code/script to make this work. I have the following file with records starting at line 4: NETW~US60~000000000013220694~002~~IT~USD~2.24~20110201~99991231~01~01~20101104~... (4 Replies)
Discussion started by: chumsky
4 Replies

6. UNIX for Dummies Questions & Answers

Comparing Output Date to Current System Date

Hi Guys, Anyone who knows how to compare the current date with the a file containing a date, say for example I have a file that looks like this: Command was launched from partition 0. ------------------------------------------------ Executing command in server server6 Fri Dec 16... (7 Replies)
Discussion started by: rymnd_12345
7 Replies

7. Shell Programming and Scripting

Adding days to system date then compare to a date

Hi! I am trying to read a file and every line has a specific date as one of its fields. I want to take that date and compare it to the date today plus 6 days. while read line do date=substr($line, $datepos, 8) #date is expected to be YYYYMMDD if ; then ...proceed commands ... (1 Reply)
Discussion started by: kokoro
1 Replies

8. Shell Programming and Scripting

Compare the system date with date from a text file

I get the date that's inside a text file and assigned it to a variable. When I grep the date from the file, I get this, Not After : Jul 28 14:09:57 2017 GMT So I only crop out the date, with this command echo $dateFile | cut -d ':' -f 2,4The result would be Jul 28 14:57 2017 GMT How do I... (3 Replies)
Discussion started by: Loc
3 Replies

9. SCO

Cannot use 'date -t' to set the system date and time

Hi! All, I am trying to reset the date and time since the change in time over the weekend. I cannot issue the command date -t 201703131330. The system gives me an error invalid option. This happens on my SCO OpenServer 5.0.7 and 5.0.6. Do anyone have an idea why? I even tried using... (6 Replies)
Discussion started by: trolley
6 Replies

10. Answers to Frequently Asked Questions

Compare date in .txt with system date and remove if it's lesser than system date

I m working on shell scripting and I m stuck where in my .txt file there is column as expiry date and I need to compare that date with system date and need to remove all the rows where expiry date is less than system date and create a new .txt with update. (1 Reply)
Discussion started by: Stuti
1 Replies
gtkcookie(1)						      General Commands Manual						      gtkcookie(1)

NAME
gtkcookie - edit Netscape cookie file SYNOPSIS
gtkcookie [ Gtk options ] DESCRIPTION
Options gtkcookie supports the command flags common to all Gtk applications. There are no gtkcookie-specific flags. What happens at startup On startup, gtkcookie will try to find your Netscape cookie file by looking for ~/.netscape/cookies. If ~/.netscape/cookies is found, gtk- cookie will load the file and show it in a multi-column list. Opening a cookie file Regardless of whether gtkcookie finds your cookie file, or you have to open it manually, when you open the file, all of your Netscape cook- ies are displayed in whatever order Netscape wrote them into the file. Sorting a cookie file You can sort the cookies by any column by clicking on the heading for that column. Human-readable dates The final column is actually not stored in your cookie file, but is a translation of Netscape's native date field. Netscape stores the date as the number of seconds since 1 Jan 1970 (familiar to anyone who's spent any time on Unix), but gtkcookie translates those dates into human-readable expiry dates in the final column. Editing cookies To edit a cookie, double-click on the cookie, and a cookie edit dialogue will pop up. You'll notice that the date, in seconds since the epoch (the epoch is 1 Jan 1970), is not an editable field, whereas the human-readable date is. Follow the format presented in the edit dia- logue box, and as you edit the human-readable date, the expiry date in seconds since the epoch will update itself. Please note (as repeated in the bugs section below) that although dates later than 2038 are supposed to present problems, (you'll see the date in seconds since the epoch become -1) dates on or after 2036 seem to present problems. I'm still looking into this. Searching for text strings Under the Edit menu, select Find. Type in a string or substring that you wish to find, and press the Find button. If the string or sub- string is found anywhere in a cookie, that cookie will become selected, and the view will scroll to that cookie, if necessary. Pressing Find again will search for the next instance, or pop up a "not found" dialogue box if the string wasn't found. In its current version, gtk- cookie isn't yet smart enough to re-start a search from the top of the cookie list, so if you need to search from the top, hightlight the first cookie, and then do your search. Deleting cookies Right click on a cookie, and select "Delete" from the popup menu, or click on the cookie and press "Del" on your keyboard. Creating cookies Press the "Create Cookie" button. A cookie with dummy values will be added to the cookie list, and the "Edit Cookie" dialogue box will pop up so that you can edit the new cookie to your liking. Note that even if you press "Cancel" immediately after creating a new cookie, the new cookie, with its dummy values, will still be in the list. You'll have to delete the cookie manually. FILES
~/.netscape/cookies The Netscape cookie file in your home directory SEE ALSO
None NOTES
None AUTHOR
Manni Wood: mwood@sig.bsh.com or pq1036@110.net BUGS
1. The "Edit Cookie" dialogue has problems with on-the-fly conversion of human-readable dates to the number of seconds since the epoch for dates later than 2036. For some reason, despite the fact that the date is supposed to overflow in 2038, the C function strptime flubs up the conversion for dates larger than 1036. Unfortunately, this means that when you edit a cookie whose expiry date is after 2036, the edit dialogue box shows the number of seconds since the epoch as -1. There is currently no workaround to this problem, besides moving the date back 2 years. 2. Although the "find" feature is supposed to always highlight and scroll to any found item, sometimes, the item becomes highlighted, but is outside the current view. 3. The file open and save dialogues don't show directories beginning with a dot (such as .netscape!) but typing such directory names manu- ally will work. 4. Double-clicking in the scroll bar will pop up the "Edit Cookie" dialogue box for the currently highlighted cookie. 5. Editing the cookie file while Netscape is running is futile, because Netscape will re-write the cookie file when you exit Netscape, based on what's in its memory, not what's in the cookie file. A popup menu in my programme warns you of a running netscape... unless you're running Netscape 4.5. Netscape 4.5 doesn't seem to create the same lock file that earlier Netscapes used to. October 1998 gtkcookie(1)
All times are GMT -4. The time now is 02:58 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy