Visit Our UNIX and Linux User Community


Help on Sorting


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Help on Sorting
# 8  
Old 04-26-2019
Hi. How to handle this when I have more than one input file

--- Post updated at 11:10 AM ---

HI .. How to handle this case when I have multiple input files
# 9  
Old 04-26-2019
Quote:
Originally Posted by richa_240889
Tried this .. Getting error that option is not supported

--- Post updated at 04:32 AM ---

I have 12 input files for this requirement .. Do I need to add the number in each file .. even if I do the key will match for multiple rows.
If you want 12 output files you need to treat them separately, and a loop is appropriate.
Code:
for file in input1.txt input2.txt ...
do
  cat -n "$file" | sort -k2,2 -k4,4 -k1,1 | cut -f2- > "$file".sorted
done

This User Gave Thanks to MadeInGermany For This Post:
# 10  
Old 04-26-2019
Hi .. Output file is only one and input files are more than one. I need to sort them and merge into one file. When the keys in files matching, the sorting is not working fine . It is sorting based on other columns also which are not part of key. My question is if I add number in each file at the end to solve this, How will it work as in each file number will be added at the end.

--- Post updated at 04:03 PM ---

Hi .. I am able to apply this logic in one input file. In my scenario the input files are more than one . All of them to be sorted and generate one output file. Please help how to achieve this .
I have tried the option of combining the files in one Temporary file and in that temporary file I am applying this logic mentioned by you to generate final output.

Is there any other way.
# 11  
Old 04-26-2019
cat -n starts from 1 with each file, so awk with its NR is better:
Code:
awk '{print (NR "\t" $0)}' input1.txt input2.txt ... | sort -k2,2 -k4,4 -k1,1 | cut -f2-

Note: the awk inserts a tab-separated field #1, so the sort fields are +1 compared to the fields in the input files. At the end the field #1 is cut off again.
This User Gave Thanks to MadeInGermany For This Post:
# 12  
Old 04-26-2019
Can I apply this logic to more than one input file at a time??

--- Post updated at 05:07 PM ---

It is working now ., Thank you for help.
This User Gave Thanks to richa_240889 For This Post:

Previous Thread | Next Thread
Test Your Knowledge in Computers #532
Difficulty: Medium
UTF-8 uses a fixed number of bytes to encode characters.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sorting help

Hi, Please i need help in writing an 'awk' script in sorting the following data; traceroute6 to 2001:1ba0:2a0:5965:0:30:24:1 (2001:1ba0:2a0:5965:0:30:24:1) from 2001:418:1::62, 64 hops max, 16 byte packets 1 2001:418:1::4 0.342 ms 2 2001:418:1::1 0.630 ms 3 2001:504:16::1b1b 0.393 ms 4... (6 Replies)
Discussion started by: sam127
6 Replies

2. Shell Programming and Scripting

sorting

Hi all, Does anyone can help me the following question? I would like to write an AWK script. In the following input file, each number in "start" is paired with numbers in column "end". No Start End A 22,222,33,22,1233,3232,44 555,333,222,55,1235,3235,66... (7 Replies)
Discussion started by: phoeberunner
7 Replies

3. Shell Programming and Scripting

Sorting HELP

Hi, I have posted related topic but as i continue the research I find more need to sort the data. AS(2607:f278:4101:11:dead:beef:f00f:f), AS786 AS6453 AS7575 AS7922 AS(2607:f2e0:f:1db::16), AS786 AS3257 AS36252 AS786 AS3257 AS36252 AS(2607:f2f8:1700::2), AS786 AS6939 AS25795 ... (6 Replies)
Discussion started by: sam127
6 Replies

4. UNIX for Advanced & Expert Users

HELP on sorting

hi everyone, I am kind of new to this forum. I need help in sorting this data out accordingly, I am actually doing a traceroute application and wants my AS path displayed in front of my address like this; 192.168.1.1 AS28513 AS65534 AS5089 AS5089 .... till the last AS number and if possible... (1 Reply)
Discussion started by: sam127
1 Replies

5. UNIX for Dummies Questions & Answers

HELP on sorting

hi everyone, I am kind of new to this forum. I need help in sorting this data out accordingly, I am actually doing a traceroute application and wants my AS path displayed in front of my address like this; 192.168.1.1 AS28513 AS65534 AS5089 AS5089 .... till the last AS number and if possible... (1 Reply)
Discussion started by: sam127
1 Replies

6. Shell Programming and Scripting

Sorting

Let's say that I have a database that I call part ID. This database has the following grouping: Dart1=4 Dart2=8 Dart3=12 Fork1=68 Fork2=72 Fork3=64 Bike1=28 Bike2=24 Bike3=20 Car1=44 Car2=40 Car3=36 I want to write a program that would read this database and tell me when the... (19 Replies)
Discussion started by: Ernst
19 Replies

7. Homework & Coursework Questions

Sorting help

i have list of files: Wang De Wong CVPR 09.pdf Yaacob AFGR 99 Second edition.pdf Shimon CVPR 01.pdf Den CCC 97 long one.pdf Ronald De Bour CSPP 04.pdf ..... how can i sort this directory so the output will be in the next format: <year>\t<conference/journal>\t<author list> - t is tab (its... (1 Reply)
Discussion started by: nirnir26
1 Replies

8. UNIX for Dummies Questions & Answers

Sorting help

i have list of files: Wang De Wong CVPR 09.pdf Yaacob AFGR 99 Second edition.pdf Shimon CVPR 01.pdf Den CCC 97 long one.pdf Ronald De Bour CSPP 04.pdf ..... how can i sort this directory so the output will be in the next format: <year>\t<conference/journal>\t<author list> - t is tab (its... (1 Reply)
Discussion started by: nirnir26
1 Replies

9. UNIX for Dummies Questions & Answers

Sorting help

how can i sort the next list just by look at the numbers (ignore letters) example: abc123 dff4f aaa2aa bbbb55555bb output: aaa2aa dff4f abc123 bbbb55555bb (1 Reply)
Discussion started by: nirnir26
1 Replies

10. Shell Programming and Scripting

Need immediate help with sorting!!!

hey, I have a file that looks smthng like this: /*--- abcd_0050 ---*/ asdfjk adsfkja lkjljgafsd /*---abcd_0005 ---*/ lkjkljbfkgj ldfksjgf dfkgfjb /*-- abcd_0055--*/ klhfdghd dflkjgd jfdg I would like it to be sorted so that it looks like this: /*---abcd_0005 ---*/ lkjkljbfkgj (9 Replies)
Discussion started by: sasuke_uchiha
9 Replies

Featured Tech Videos