08-08-2011
Perl script: extracting numbers from a date formatt
Hi I want to basically sort some data files that I have based on the date.
Here is my issue, the date is in the form of "2010-05-24T09:48:55-04"
All I really need is the date so perhaps I could sort the number 20100524 in this case.
My question is how do extract a number that I can later sort from this date format using regex or something simple??
Thank you in advance!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to extract the date part from the file name (20080221 in this ex) and compare it with the current date and delete it, if it is a past date.
$file = exp_ABCD4_T-2584780_upto_20080221.dmp.Z
really appreciate any help.
thanks
mkneni (4 Replies)
Discussion started by: MKNENI
4 Replies
2. Shell Programming and Scripting
Hello all,
I am being dumb with this and I know there is a simple solution.
I have a file with the follwing lines
bc stuff (more)...............123
bc stuffagain (moretoo)............0
bc stuffyetagain (morehere)......34
failed L3 thing..............1
failed this... (2 Replies)
Discussion started by: gobi
2 Replies
3. UNIX for Dummies Questions & Answers
Hi All,
I have searched the forum but couldn't find exactly what I need. Hopefully someone may be able to help.
I'm trying to put a script together that will extract numbers from a text file and multiply them by, for example 1.5 or 1.2
Sample file looks like this...... (1 Reply)
Discussion started by: speedfreak
1 Replies
4. Shell Programming and Scripting
Hello Everyone,
i have quick question.
I have file names like: bin_map300.asc and I would like to extract grid300.
My approach so far:
name=bin_map300.asc
echo ${name%%.*}
echo ${name##*_}
I am stuck combining the two.
Any help would be appreciated. (3 Replies)
Discussion started by: creamcheese
3 Replies
5. UNIX for Dummies Questions & Answers
Hi all,
I'm a new programmer to shell script... and I have no idea how to use substring.
I want to extract the numbers from the following string and place it into a variable:
"170 unique conformations found"
The numbers can be more than three digits depending on the case. I just want to... (10 Replies)
Discussion started by: ah7391
10 Replies
6. Shell Programming and Scripting
I have input like this :
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 07-FEB-2012 04:19:45
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/t3local_apps/apps/oracle/product/11.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve... (3 Replies)
Discussion started by: dnam9917
3 Replies
7. Shell Programming and Scripting
Hi all,
I do have a tab delimited file
a1 a2 b1 b2 c1 c2 d1 d2 e1 e2 f1 f2
0 0 123 546 0 0 0 0 0 0 0 0
0 0 345 456 765 890 902 1003 0 0 0 0
534 768 0 0 0 0 0 0 0 0 0 0
0 0 0 0 456 765 0 0 0 0 0 0
0 0 0 0 0 0 12 102 0 0 0 0
456 578 789 1003 678 765 345 400 801 1003 134 765... (5 Replies)
Discussion started by: Lucky Ali
5 Replies
8. Shell Programming and Scripting
Hi I am part of a academic organization and I want to send a fax to the students however there must be a quicker way to get the fax numbers extracted from the online forms they sent me.
The file looks like this (numbers are fake in order to protect identity):
Biochemistry Major
Michael... (3 Replies)
Discussion started by: phil_heath
3 Replies
9. Shell Programming and Scripting
Thanks (1 Reply)
Discussion started by: Raysf
1 Replies
10. Shell Programming and Scripting
I have number 192.168.21.8.
I want to extract from this number with sed 21 and 8 to variables a and b. Any Ideas?
I did like 's/\(192.168.\)/ /' but its wrong :( (6 Replies)
Discussion started by: Natalie
6 Replies
LEARN ABOUT ULTRIX
sortbib
sortbib(1) General Commands Manual sortbib(1)
Name
sortbib - sort bibliographic database
Syntax
sortbib [-sKEYS] database...
Description
The command sorts files of records containing refer key-letters by user-specified keys. Records may be separated by blank lines, or by .[
and .] delimiters, but the two styles may not be mixed together. This program reads through each database and pulls out key fields, which
are sorted separately. The sorted key fields contain the file pointer, byte offset, and length of corresponding records. These records
are delivered using disk seeks and reads, so may not be used in a pipeline to read standard input.
By default, alphabetizes by the first %A and the %D fields, which contain the senior author and date. The -s option is used to specify new
KEYS. For instance, -sATD will sort by author, title, and date, while -sA+D will sort by all authors, and date. Sort keys past the fourth
are not meaningful. No more than 16 databases may be sorted together at one time. Records longer than 4096 characters will be truncated.
The command sorts on the last word on the %A line, which is assumed to be the author's last name. A word in the final position, such as
``jr.'' or ``ed.'', will be ignored if the name beforehand ends with a comma. Authors with two-word last names or unusual constructions
can be sorted correctly by using the convention `` '' in place of a blank. A %Q field is considered to be the same as %A, except sorting
begins with the first, not the last, word. The command sorts on the last word of the %D line, usually the year. It also ignores leading
articles (like ``A'' or ``The'') when sorting by titles in the %T or %J fields; it will ignore articles of any modern European language.
If a sort-significant field is absent from a record, places that record before other records containing that field.
Options
-sKEYS
Specifies new sort KEYS. For example, ATD sorts by author, title, and date.
See Also
addbib(1), indxbib(1), lookbib(1), refer(1), roffbib(1)
sortbib(1)