Sponsored Content
Top Forums Shell Programming and Scripting Sort by id value in every two rows Post 303035769 by baris35 on Sunday 2nd of June 2019 04:19:15 PM
Old 06-02-2019
Sort by id value in every two rows

Hello,
I am running ubuntu 14.04. My purpose is to sort below file according to value of id even though it contains alphanumeric strings inside double quote. File is not tab separated. I am not sure that can be done...
mydata
Code:
#INFO id="133 texas" logo="http://tx.yy.zz
http://11.22.48
#INFO id="21 michigan" logo="http://mx.yy.zz
http://11.22.55
#INFO id="18 london" logo="http://lx.yy.zz
http://11.22.77
#INFO id="299 paris" logo="http://px.yy.zz
http://11.22.00

Expected output:
Code:
#INFO id="18 london" logo="http://lx.yy.zz
http://11.22.77
#INFO id="21 michigan" logo="http://mx.yy.zz
http://11.22.55
#INFO id="133 texas" logo="http://tx.yy.zz
http://11.22.48
#INFO id="299 paris" logo="http://px.yy.zz
http://11.22.00

What I tried:
Code:
awk '{print int((NR-1)/2), $0}' mydata | sort -n -k2,2 | cut -f2- -d' '


Thank you
Boris

EDIT:
Hello,
I have solved somehow with a bit long way but it's okay now.
Code:
for i in {10..900}
do
echo "id=\"$i"
done > output

Then with grep and while read -r line loop.

Thanks
Boris

Last edited by baris35; 06-02-2019 at 06:40 PM.. Reason: solved
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sort, group rows

I wrote script in bash which generates this report: User1,admin,rep,User2,shell,path1,x1,r1 User2,admin,rep,User7,shell,path1,x1,r1 User3,admin,rep,User4,shell,path1,x1,r1 User4,admin,rep,User3,shell,path1,x1,r1 User5,admin,rep,User1,shell,path1,x1,r1 User6,admin,rep,User5,shell,path1,x1,r1... (6 Replies)
Discussion started by: patrykxes
6 Replies

2. Shell Programming and Scripting

Deleting specific rows in large files having rows greater than 100000

Hi Guys, I need help in modifying a large text file containing more than 1-2 lakh rows of data using unix commands. I am quite new to the unix language the text file contains data in a pipe delimited format sdfsdfs sdfsdfsd START_ROW sdfsd|sdfsdfsd|sdfsdfasdf|sdfsadf|sdfasdf... (9 Replies)
Discussion started by: manish2009
9 Replies

3. Shell Programming and Scripting

Sort the multi column rows

abc xyz - - - - - - - - - - - How to sort the second column in ascending order. (2 Replies)
Discussion started by: sandy1028
2 Replies

4. Shell Programming and Scripting

Split single rows to multiple rows ..

Hi pls help me out to short out this problem rm PAB113_011.out rm: PAB113_011.out: override protection 644 (yes/no)? n If i give y it remove the file. But i added the rm command as a part of ksh file and i tried to remove the file. Its not removing and the the file prompting as... (7 Replies)
Discussion started by: sri_aue
7 Replies

5. UNIX for Advanced & Expert Users

Script to sort the files and append the extension .sort to the sorted version of the file

Hello all - I am to this forum and fairly new in learning unix and finding some difficulty in preparing a small shell script. I am trying to make script to sort all the files given by user as input (either the exact full name of the file or say the files matching the criteria like all files... (3 Replies)
Discussion started by: pankaj80
3 Replies

6. UNIX for Dummies Questions & Answers

merging rows into new file based on rows and first column

I have 2 files, file01= 7 columns, row unknown (but few) file02= 7 columns, row unknown (but many) now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there e.g. file 01 James|0|50|25|10|50|30... (1 Reply)
Discussion started by: A-V
1 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. UNIX for Dummies Questions & Answers

Converting Columns To Rows Sort Of

Hi I'm a UNIX awk and sed novice at best. I'm trying to creat a .csv file so it can be graphed in Excel. Tried various xargs, awk, sed and paste but just can't seem to get the data to line up. Not sure if this is beyond for a question in these forums. Any help would greatly be appreciated. Have... (4 Replies)
Discussion started by: jimmyf
4 Replies

9. Shell Programming and Scripting

Moving or copying first rows and last rows into another file

Hi I would like to move the first 1000 rows of my file into an output file and then move the last 1000 rows into another output file. Any help would be great Thanks (6 Replies)
Discussion started by: kylle345
6 Replies

10. UNIX for Dummies Questions & Answers

Sort tab delimited file according to which rows have missing values

Hello! I have a tab delimited file with values in three columns. Some values occur in all three columns, other values are present in only one or two columns. I would like to sort the file so that rows with no missing values come first, rows with one missing values come next, and rows with two... (9 Replies)
Discussion started by: MBarrett1213
9 Replies
http(n) 							 Tnm Tcl Extension							   http(n)

__________________________________________________________________________________________________________________________________________________

NAME
http - Send and process HTTP requests. _________________________________________________________________ DESCRIPTION
The Hypertext Transfer Protocol (HTTP) (RFC 1945) is a client/server protocol used to retrieve documents in the World Wide Web. Documents are addressed using Uniform Resource Locators (URL) (RFC 1738). The http command allows to implement HTTP clients and a simple HTTP server. HTTP COMMAND
The following list of http commands is useful for HTTP clients: http proxy [url] The http proxy command allows to define a proxy HTTP server which will be used in subsequent client commands. Using this command without an url argument will return the URL to the currently used proxy or an empty string. Providing a url argument sets the proxy server. Setting the proxy to an empty string turns the proxy feature off. http head url The http head command retrieves the HTTP header for the document located at url. The header is returned as a list of keys and values which can be converted into a Tcl array using the array set command. http get url fileName The http get command retrieves the document located at url. The body of the document is written to the file named fileName. The com- mand returns the HTTP header as described for the http head command above. http post url docFileName fileName The http post command posts the document in docFileName to the location url. The body of the returned document is written to the file named fileName. The command returns the HTTP header as described for the http head command above. http put url docFileName The http put command puts the document in docFileName to the location url. The command returns the HTTP header as described for the http head command above. http delete url The http delete command deletes the document at the location defined by url. The command returns HTTP status information. The following set of http commands is useful for a simple HTTP server: http server [port] The http server command starts a simple HTTP server listening on port port. If called without a port argument, the currently used port number or an empty string is returned. An empty string indicates that no server is currently active. http mime type extension The http mime command is used to add mime type definitions to the internal table which maps file name extension to mime types. If called without an argument, the list of all mime type mappings is returned. A new mapping is created by supplying a mime type and the file name extension. http bind pattern method [script] The http bind command binds a Tcl script to the invocation of a HTTP method where the URL matches pattern. Whenever a HTTP request of type method is received that matches the pattern, script is evaluated. The return value of the script must be a name of a file which will be send back to the client. Errors during the evaluation of the script will result in an error response. The following % sequences are substituted before a script bound to a URL is evaluated: %A The network address of the client. %P The URL path requested by the client. %S The search path contained in the URL path. SEE ALSO
scotty(1), Tnm(n), Tcl(n) AUTHORS
Juergen Schoenwaelder <schoenw@cs.utwente.nl> Tnm http(n)
All times are GMT -4. The time now is 11:41 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy