02-02-2011
Sort content of text file based on date?
I now have a 230,000+ lines long text file formatted in segments like this:
Quote:
16 jan 2008 22:18
Text 1 from forum post Text 1 from forum post Text 1 from forum post
--------------------------------------------------------
26 jul 2005 18:33
Text 2 from forum post Text 2 from forum post Text 2 from forum post
--------------------------------------------------------
26 jul 2006 18:46
Text 3 from forum post Text 3 from forum post Text 3 from forum post
--------------------------------------------------------
26 jul 2003 18:54
Text 4 from forum post Text 4 from forum post Text 4 from forum post
--------------------------------------------------------
Is there a way to sort this file to have everything in chronological order, based on the date and time in the text? In this example, I would like the result to be:
Quote:
26 jul 2003 18:54
Text 4 from forum post Text 4 from forum post Text 4 from forum post
--------------------------------------------------------
26 jul 2005 18:33
Text 2 from forum post Text 2 from forum post Text 2 from forum post
--------------------------------------------------------
26 jul 2006 18:46
Text 3 from forum post Text 3 from forum post Text 3 from forum post
--------------------------------------------------------
16 jan 2008 22:18
Text 1 from forum post Text 1 from forum post Text 1 from forum post
--------------------------------------------------------
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have, a file wich list file on server ftp and i want to sort the file text as the command "ls -t"
i.e
drwxr-x--- 2 ftp_mont System 0 Sep 30 09:16 .
drwxr-x--- 2 ftp_mont System 0 Jul 15 2009 ..
-rwxr-x--- 1 ftp_mont System 343998791 Sep 01 09:20 manif... (14 Replies)
Discussion started by: protocomm
14 Replies
2. Shell Programming and Scripting
Input file format:
/tag="ABL"
/note="abl homolog
2
/tag="ABLIM1"
/note="actin binding LIM 1
/tag="ABP1"
/note="amiloride binding protein 1 (amine oxidase (copper-
containing))
/tag="ABR"
/note="active BCR-related
/tag="AC003042.1"
/note="SDR family member 11
precursor
.
.
. (4 Replies)
Discussion started by: perl_beginner
4 Replies
3. Shell Programming and Scripting
Hi Experts,
I have a filelist collected from another server , now want to sort the output using date/time stamp filed.
- Filed 6, 7,8 are showing the date/time/stamp.
Here is the input:
#----------------------------------------------------------------------
-rw------- 1 root ... (3 Replies)
Discussion started by: rveri
3 Replies
4. Shell Programming and Scripting
Hello,
I need help on.
I have a File which stores the information as below.
It is space separated file, I want to keep only unique record in file based on file name.
Also if you notice sometime filename with space appear in last column like (abc_ xyz1_bc12_20140312_c.xlsx)
03/17/2014 ... (9 Replies)
Discussion started by: kumar30213
9 Replies
5. Shell Programming and Scripting
Hello All,
I have a file which have content as below.
03/09/2014 10:35 AM 618 Admin\rick pqr_ klm2_pog12_20140309_c.xlsx
03/10/2014 10:35 AM 618 user\test01 mplz_ fgh2_lal12_20140310_c.xlsx
03/17/2014 10:35 AM 618 Admin\vick abc_ xyz2_bc12_20140317_c.xlsx
03/18/2014 ... (2 Replies)
Discussion started by: kumar30213
2 Replies
6. Shell Programming and Scripting
Greetings! I have an export of an outlook database in text format. The emails however did not export by date and are all scattered in a massive file. I am hoping somebody out there could help me with a command that could sort the file based on the date.
Here is the format of the email... (2 Replies)
Discussion started by: tntelle
2 Replies
7. UNIX for Dummies Questions & Answers
I am new to shell scripting. I am interested how to know how to sort a content of a file using shell scripting.
I've attached the 'Input file' and the 'expected output' to this thread.
Details provided in the expected output file will provide details on how the sort needs to be done.
... (16 Replies)
Discussion started by: nkarthik_mnnit
16 Replies
8. Shell Programming and Scripting
I have the below contents in a file after making the below curl call
curl ... | grep -E "state|Rno" | paste -sd',\n' | grep "Disconnected" > test
"state" : "Disconnected",, "Rno" : "5554f1d2"
"state" : "Disconnected",, "Rno" : "10587563"
"state" : "Disconnected",, "Rno" :... (2 Replies)
Discussion started by: Vaibhav H
2 Replies
9. Shell Programming and Scripting
Output from zipdiff GNU EAR comparison tool produces output in html divided into three sections "Added, Removed, Changed". I want the output to be sorted by jar or war file.
<html>
<body>
<table>
<tr>
<td class="diffs" colspan="2">Added </td>
</tr>
<tr><td>
<ul>... (5 Replies)
Discussion started by: kchinnam
5 Replies
10. UNIX for Beginners Questions & Answers
Hi all,
I have a text file similar to this:
Text
More text
Etc
Stuff
That
Is
Needed
Etc
Etc
This contains over 70 entries and each entry has several lines of text below the name in square brackets. (5 Replies)
Discussion started by: Scally
5 Replies