08-02-2009
Sorting a file
I have a file that has the following 4 fields separated by a colum, Name, Street Address,City and State, Zip code. I want to sort the file by zip code.
I tried this and it is not working. Please help!
awk -f filename '{ print $4 " " $1 " " $2 " " $3 " " } |sort -n
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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. Programming
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
4. Shell Programming and Scripting
i have a data in afile like this
**************************************
sree
sree@yahoo.com
98662323432
*************************************
phani
phani@yahoo.com
98662323344
*************************************
i want to sort the file with respect to name.
how can i do this.
thank... (5 Replies)
Discussion started by: phani_sree
5 Replies
5. Shell Programming and Scripting
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
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
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
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
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
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
json(n) JSON parser json(n)
__________________________________________________________________________________________________________________________________________________
NAME
json - JSON parser
SYNOPSIS
package require Tcl 8.4
package require json ?1.0?
::json::json2dict txt
_________________________________________________________________
DESCRIPTION
The json package provides a simple Tcl-only library for parsing the JSON http://www.json.org/ data exchange format as specified in RFC 4627
http://www.ietf.org/rfc/rfc4627.txt. There is some ambiguity in parsing JSON because JSON has type information that is not maintained by
the Tcl conversion. The json package returns data as a Tcl dict. Either the dict package or Tcl 8.5 is required for use.
COMMANDS
::json::json2dict txt
Parse JSON formatted text txt into a Tcl dict and return the value.
EXAMPLES
An example of a JSON array converted to Tcl. A JSON array is returned as a single item with multiple elements.
[
{
"precision": "zip",
"Latitude": 37.7668,
"Longitude": -122.3959,
"Address": "",
"City": "SAN FRANCISCO",
"State": "CA",
"Zip": "94107",
"Country": "US"
},
{
"precision": "zip",
"Latitude": 37.371991,
"Longitude": -122.026020,
"Address": "",
"City": "SUNNYVALE",
"State": "CA",
"Zip": "94085",
"Country": "US"
}
]
=>
{Country US Latitude 37.7668 precision zip State CA City {SAN FRANCISCO} Address {} Zip 94107 Longitude -122.3959} {Country US Latitude 37.371991 precision zip State CA City SUNNYVALE Address {} Zip 94085 Longitude -122.026020}
An example of a JSON object converted to Tcl. A JSON object is returned as a multi-element list (a dict).
{
"Image": {
"Width": 800,
"Height": 600,
"Title": "View from 15th Floor",
"Thumbnail": {
"Url": "http://www.example.com/image/481989943",
"Height": 125,
"Width": "100"
},
"IDs": [116, 943, 234, 38793]
}
}
=>
Image {IDs {116 943 234 38793} Thumbnail {Width 100 Height 125 Url http://www.example.com/image/481989943} Width 800 Height 600 Title {View from 15th Floor}}
BUGS, IDEAS, FEEDBACK
This document, and the package it describes, will undoubtedly contain bugs and other problems. Please report such in the category json of
the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883]. Please also report any ideas for enhancements you may have for
either package and/or documentation.
KEYWORDS
data exchange, exchange format, javascript, json
COPYRIGHT
Copyright (c) 2006 ActiveState Software Inc.
json 1.0 json(n)