Sponsored Content
Full Discussion: file sorting
Top Forums Shell Programming and Scripting file sorting Post 302097476 by ranj@chn on Saturday 25th of November 2006 07:50:35 AM
Old 11-25-2006
hi

What i tried was to join the 4 lines(which form a group) into a single line and then sort bsed on the required key and then get back the old format.
Input data -
Quote:
**************************************
sree
sree@yahoo.com
98662323432
*************************************
phani
phani@yahoo.com
98662323344
*************************************
Code:
1) paste -s -d "\t\t\t\n" filename gives
xrkrb@chu10t1: /home/xrkrb/unix_forum>paste -s -d "\t\t\t\n" mytestfile
**************************************  sree    sree@yahoo.com  98662323432
*************************************   phani   phani@yahoo.com 98662323344
*************************************
2) then you sort the lines based on the second field which is the name 
3) get back the original format as it existed in the original file - this is done by 'tr'


Last edited by ranj@chn; 11-25-2006 at 08:51 AM.. Reason: typo errors
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help sorting file.

Hi, I have this file (filex) 07-11-2003 10:11:12!cccc!ddd!eeeeeeee 07-11-2003 09:11:11!dddd!kkkkk!xxxxxx 09-12-2003 14:18:43!aaaa!bbbbb!cccc where I need to sort it by date+time in this order: 09-12-2003 14:18:43!aaaa!bbbbb!cccc 07-11-2003 10:11:12!cccc!ddd!eeeeeeee 07-11-2003... (3 Replies)
Discussion started by: gio123bg
3 Replies

2. Shell Programming and Scripting

sorting file

hi everyone, i have a document where i have email addresess and names, i need to check if the email addresses are uniq, if they repeat erase one of them, how can i do that? document sample: aD00763357@cucei.udg.mx,ABRAHAM ANTONIO SEVERIANO a199721111@cucei.udg.mx,ABRAHAM GONZALEZ... (4 Replies)
Discussion started by: sx3v1l_1n51de
4 Replies

3. Shell Programming and Scripting

Sorting a file

hello all, I have a file with two numbers on each line, comma separated. I want to sort the contents of the file in increasing order (smallest to largest) of the numbers on the second line. i.e: 23,3 25,2 27,12 to become 25,2 23,3 27,12 Does anyone know how I can do this? Thanks... (2 Replies)
Discussion started by: Khoomfire
2 Replies

4. Programming

regarding file sorting

i ahve a file like: ************************************* sree 122132 12321 *********************************** phani 21321 3213214 ****************************** dddsds 213213123 23213213 ******************************* i want to sort the file with respect to name how we can do this... (1 Reply)
Discussion started by: phani_sree
1 Replies

5. Shell Programming and Scripting

Sorting file

I have the file as follow: A: 60 B: 80 C: 40 D: 11 E: 100 I want to sort the file and get the output to file as follow: E: 100 B: 80 A: 60 C: 40 D: 11 Could any one help me please? (1 Reply)
Discussion started by: moutaz1983
1 Replies

6. Shell Programming and Scripting

Finding & Moving Oldest File by Parsing/Sorting Date Info in File Names

I'm trying to write a script that will look in an /exports folder for the oldest export file and move it to a /staging folder. "Oldest" in this case is actually determined by date information embedded in the file names themselves. Also, the script should only move a file from /exports to... (6 Replies)
Discussion started by: nikosey
6 Replies

7. UNIX for Dummies Questions & Answers

sorting s file

how would i sort a file on the third column based on numerical value instead of the ASCII order? (1 Reply)
Discussion started by: trob
1 Replies

8. UNIX for Dummies Questions & Answers

Sorting data in file based on field in another file

Hi, I have two files, one of which I would like to sort based on the order of the data in the second. I would like to do this using a simple unix statement. My two files as follows: File 1: 12345 1 2 2 2 0 0 12349 0 0 2 2 1 2 12350 1 2 1 2 2 2 . . . File2: 12350... (3 Replies)
Discussion started by: kasan0
3 Replies

9. Solaris

What about sorting a 5G file?

Hi Guys, My client (dear clients, I hate to love you) has the funky idea of sorting a 5G flat file. Certainly enough, this is taking forever and also fulls the / of our machine. Any idea of how we could proceed to make this a little bit more efficient? Maybe by forcing sort to "stay in... (7 Replies)
Discussion started by: plmachiavel
7 Replies

10. Shell Programming and Scripting

Need help in Sorting a file

Hi Unix Admins, I wanted to sort a file in a specific order, i.e the input file contains two fields and the first column is not unique and had to be sorted. example Input File ------- 2014-10-21:Rand1 2014-11-02:Rand2 2014-11-02:Rand3 2014-11-02:Rand4 2014-11-03:Rand5 2014-11-04:Rand6... (4 Replies)
Discussion started by: Naveenezone
4 Replies
GNC-FQ-HELPER(1)					User Contributed Perl Documentation					  GNC-FQ-HELPER(1)

NAME
gnc-fq-helper - allows gnucash to communicate with Finance::Quote over pipes from guile. The requests and responses are scheme forms. SYNOPSIS
gnc-fq-helper DESCRIPTION
Input: (on standard input - one entry per line and one line per entry, and double quotes must only be delimiters, not string content -- remember, we don't have a real scheme parser on the perl side :>). (<method-name> symbol symbol symbol ...) where <method-name> indicates the desired Finance::Quote method. The currently recognized subset is yahoo, yahoo_europe, fidelity_direct, troweprice_direct, vanguard, asx, tiaacref, and currency. For currency quotes, the symbols alternate between the 'from' and 'to' currencies. For example: (yahoo "IBM" "LNUX") (fidelity_direct "FBIOX" "FSELX") (currency "USD" "AUD") Output (on standard output, one output form per input line): Schemified version of gnc-fq's output, basically an alist of alists, as in the example below. Right now, only the fields that this script knows about (and knows how to convert to scheme) are returned, so the conversion function will have to be updated whenever Finance::Quote changes. Currently you'll get symbol, gnc:time-no-zone, and currency, and either last, nav, or price. Fields with gnc: prefixes are non-Finance::Quote fields. gnc:time-no-zone is returned as a string of the form "YYYY-MM-DD HH:MM:SS", basically the unmolested (and underspecified) output of the quote source. It's up to you to know what it's proper timezone really is. i.e. if you know the time was in America/Chicago, you'll need to convert it to that. For example: $ echo '(yahoo "CSCO" "JDSU" "^IXIC")' | ./gnc-fq-helper (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2001-03-13 19:27:00") (last . 20.375) (currency . "USD")) ("JDSU" (symbol . "JDSU") (gnc:time-no-zone . "2001-03-13 19:27:00") (last . 23.5625) (currency . "USD")) ("^IXIC" (symbol . ^IXIC) (gnc:time-no-zone . 2002-12-04 17:16:00) (last . 1430.35) (currency . failed-conversion))) On error, the overall result may be #f, or on individual errors, the list sub-item for a given symbol may be #f, like this: $ echo '(yahoo "CSCO" "JDSU")' | ./gnc-fq-helper (#f ("JDSU" (symbol . "JDSU") (gnc:time-no-zone . "2001-03-13 19:27:00") (last . 23.5625) (currency . "USD"))) further, errors may be stored with each quote as indicated in Finance::Quote, and whenever the conversion to scheme data fails, the field will have the value 'failed-conversion, and accordingly this symbol will never be a legitimate conversion. Exit status 0 - success non-zero - failure perl v5.14.2 2013-01-03 GNC-FQ-HELPER(1)
All times are GMT -4. The time now is 11:29 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy