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
wsreg_query_create(3WSREG)			    Product Install Registry Library Functions				wsreg_query_create(3WSREG)

NAME
wsreg_query_create, wsreg_query_free - create a new query SYNOPSIS
cc [flag ...] file ...-lwsreg [library ...] #include <wsreg.h> Wsreg_query *wsreg_query_create(void); void wsreg_query_free(Wsreg_query *query); DESCRIPTION
The wsreg_query_create() function allocates a new query that can retrieve components from the product install registry. The wsreg_query_free() function releases the memory associated with the query specified by query. RETURN VALUES
The wsreg_query_create() function returns a pointer to the newly allocated query. The resulting query is completely empty and must be filled in to describe the desired component. USAGE
The query identifies fields used to search for a specific component in the product install registry. The query must be configured and then passed to the wsreg_get(3WSREG) function to perform the registry query. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |MT-Level |Unsafe | +-----------------------------+-----------------------------+ SEE ALSO
wsreg_get(3WSREG), wsreg_initialize(3WSREG), wsreg_query_set_id(3WSREG), wsreg_query_set_instance(3WSREG), wsreg_query_set_loca- tion(3WSREG), wsreg_query_set_unique_name(3WSREG), wsreg_query_set_version(3WSREG), wsreg_unregister(3WSREG), attributes(5) SunOS 5.10 22 Sep 2000 wsreg_query_create(3WSREG)
All times are GMT -4. The time now is 02:06 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy