Sponsored Content
Full Discussion: sort data by date.. pls help
Top Forums Programming sort data by date.. pls help Post 302446841 by konsolebox on Friday 20th of August 2010 12:29:30 AM
Old 08-20-2010
Try this one
Code:
#!/bin/sh

sed 's/\(..\)-\(...\)-\(..\).*/\3\2\1 &/' | \
	sed 's/JAN/01/; s/FEB/02/; s/MAR/03/; s/APR/04/; s/MAY/05/; s/JUN/06/; s/JUL/07/; s/AUG/08/; s/SEP/09/; s/OCT/10/; s/NOV/11/; s/DEC/12/;' | \
		sort | \
			cut -f 2- -d ' '

sh script.sh < input_file.txt
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Formatting Date Variable (Pls help)

I have a situation where I am writing a shell script that will accept a date value it will then pass this date value to an Oracle stored procedure for processing. I want to format the date into (01-SEP-08) before passing to the proc. I also want to make sure the value passed in is a date value... (1 Reply)
Discussion started by: gmoth
1 Replies

2. Shell Programming and Scripting

How to Sort?? Pls help!!

The segment titled "Before" shows how it is now and the segment "After" (shown below) is how I want it to be sorted. Probably as a CSV format so that I can export it to a spreadsheet. Need your help and suggestions!! Before: 1500.100: by the old run: -- --- --- ---- neitqodo <... (1 Reply)
Discussion started by: kn.naresh
1 Replies

3. Shell Programming and Scripting

how to convert the result of the select query to comma seperated data - urgent pls

how to convert the result of the select query to comma seperated data and put in a .csv file using korn shell. Pls help me as its very urgent. Thanks, Hema. (1 Reply)
Discussion started by: Hemamalini
1 Replies

4. Shell Programming and Scripting

How to delete already existing data in a file using perl? Pls help me!!

Dear Friends, I need urgent help from u.. I have two files,file1 & file 2.. file1 have a existing data of file2.So i want to delete those existing datas from file1 (which contain the data from file1) My file1 like this rs39348 1 1045729 A G 0.1791 0.2054 0.84 ... (3 Replies)
Discussion started by: sureshraj
3 Replies

5. Shell Programming and Scripting

sort the date

Hi All, Please help me to sort the date field which is in the format 2012-02-03 16:09:37.388... Platform: Red Hat linux Thanks in advance (2 Replies)
Discussion started by: jesu
2 Replies

6. Shell Programming and Scripting

Help me pls : splitting single file in unix into different files based on data

I have a file in unix with sample data as follows : -------------------------------------------------------------- -------------------------------------------------------------- {30001002|XXparameter|Layout|$ I want this file to be splitted into different files and corresponding to the sample... (54 Replies)
Discussion started by: Ravindra Swan
54 Replies

7. Shell Programming and Scripting

Sort help: How to sort collected 'file list' by date stamp :

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

8. Shell Programming and Scripting

Sort data by date and then search by column

Hi, I have a file where data is pipe separated.First i want to sort the file content by date . Then i want to pick up the records based on the first column which should be unique and not have duplicates. NYSE|yyyrrrddd|toronto|isin|ticker|2013-05-15... (2 Replies)
Discussion started by: samrat dutta
2 Replies

9. Shell Programming and Scripting

Sort data by date first and then remove duplicates

Hi , I have below data inside a file named ref.psv . I want to create a shell script which will do the below 2 points : (1) sort the file content first based on the latest date which is the last column in the file (actual file its the 175th column) (2)after sorting the file based on latest date... (3 Replies)
Discussion started by: samrat dutta
3 Replies

10. Shell Programming and Scripting

sed --> sort data by date

Hi, i "tried" to sort data by date. So far, i used sed to take the data from the last and the actual month. Now, after changing the year it is not working properly. i use: GNU bash, version 4.2.45(1)-release (x86_64-suse-linux-gnu) sed -n '/\//p' $Home/../scripte/pd_0.txt y is a... (6 Replies)
Discussion started by: IMPe
6 Replies
OSINFO-QUERY.C(1)					      Virtualization Support						 OSINFO-QUERY.C(1)

NAME
osinfo-query - Query information in the database SYNOPSIS
osinfo-query [OPTIONS...] TYPE [CONDITION-1 [CONDITION-2 ...]] DESCRIPTION
The "osinfo-query" command allows extraction of information from the database. TYPE can be one of "os", "platform", "device", or "deployment". With no conditions specified, all entities of the given type will be listed. # List all operating systems $ osinfo-query os Short ID | Name ... ----------------------+----------- centos-6.0 | CentOS 6.0 ... centos-6.1 | CentOS 6.1 ... ... Conditions allow filtering based on specific properties of an entity. For example, to filter only distros from the Fedora Project, use # List all operating systems $ osinfo-query os vendor="Fedora Project" Short ID | Name ... ----------------------+-------------- fedora1 | Fedora Core 1 ... fedora2 | Fedora Core 2 ... ... The set of fields which are printed can be controlled using the "--fields" command line argument: # List all operating systems $ osinfo-query --fields=short-id,version os vendor="Fedora Project" Short ID | Version ----------------------+---------- fedora1 | 1 fedora2 | 2 ... OPTIONS
-s PROPERTY, --sort-key PROPERTY Set the data sorting key. Defaults sorting the first column -f PROPERTY1,PROPERTY2,..., --fields PROPERTY1,PROPERTY2,... Set the visibility of properties in output PROPERTY NAMES
OS Valid property names for the "os" type are: short-id The short OS identifier name The long OS name version The OS version string family The OS kernel family vendor The OS vendor release-date The OS release date eol-date The OS end-of-life date codename The OS code name id The OS identifier PLATFORM Valid property names for the "platform" type are: short-id The short platform identifier name The long platform name version The platform version string vendor The platform vendor release-date The platform release date eol-date The platform end-of-life date codename The platform code name id The platform identifier DEVICE Valid property names for the "device" type are: name The device name product The device product name product-id The device product ID string vendor The device vendor name vendor-id The device vendor ID string class The device type class bus The device bus type id The device identifier DEPLOYMENT Valid property names for the "deployment" type are: id The deployment identifier EXIT STATUS
The exit status will be 0 if matching entries were found, or 1 if not matches were found SEE ALSO
"osinfo-db-validate(1)", "osinfo-detect(1)" AUTHORS
Daniel P. Berrange <berrange@redhat.com> COPYRIGHT
Copyright (C) 2012 Red Hat, Inc. LICENSE
"osinfo-query" is distributed under the termsof the GNU LGPL v2+ license. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE libosinfo-0.2.7 2013-02-06 OSINFO-QUERY.C(1)
All times are GMT -4. The time now is 04:46 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy