Sort - only one field appears in output?

Login or Register to Ask a Question and Join Our Community

Sort - only one field appears in output?

Tags

Top Forums UNIX for Dummies Questions & Answers Sort - only one field appears in output?

07-24-2006

Registered User

18, 0

Join Date: Jul 2006

Last Activity: 28 June 2010, 10:22 AM EDT

Posts: 18

Thanks Given: 0

Thanked 0 Times in 0 Posts

Sort - only one field appears in output?

I'm running against a file with 1008 records like this, all beginning '4760 Slave':

4760 Slave,7,3607 ,GL ,200605,11320024 , ,GBP ,X00033
,AI80190 ,GBP,+,000000000015
370123, ,P ,

I'm running a sort, like this:

sort +1 -9 -t, -o sorted_REPORT_200605_3607_GL_RECON REPORT_200605_3607_GL_RECON

...which *should* sort the comma-seperated file on fields 2-9, outputting it to "sorted_...." file... but the output file I get just contains:

4760 Slave
4760 Slave
4760 Slave
etc...

When it runs, I do see a message of:

"sort: Warning: A newline character was added to the end of file REPORT_200605_3607_GL_RECON."

Any help please? Where has the remainder of each record gone?

If I 'vi' the file, it looks fine, but I have also noticed, if I 'head' the file, I see the same thing:

4760 Slave
4760 Slave
4760 Slave

miwinter

View Public Profile for miwinter

Find all posts by miwinter

07-24-2006

Registered User

262, 4

Join Date: Nov 2001

Last Activity: 26 November 2016, 7:52 PM EST

Location: Flint, MI

Posts: 262

Thanks Given: 0

Thanked 4 Times in 4 Posts

I always surround my field separator with double quotes and specify all the fields that I want to sort on like this:
sort +0 +2 +4 +5 -t"|" infile.txt > outfile.txt

+0 is the first field in the record, +1 would be the second.

jyoung

View Public Profile for jyoung

Find all posts by jyoung

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Combine Similar Output from the 2nd field w.r.t 1st Field

Hi, For example: I have: HostA,XYZ HostB,XYZ HostC,ABC I would like the output to be: HostA,HostB: XYZ HostC:ABC How can I achieve this? So far what I though of is:

2. Shell Programming and Scripting

Print Terminal Output Exactly how it Appears in the Terminal to a New Text File

Hello All, I have a text file containing output from a command that contains lots of escape/control characters that when viewed using vi or view, looks like jibberish. But when viewed using the cat command the output is formatted properly. Is there any way to take the output from the cat...

3. Shell Programming and Scripting

Sort field and uniq

I have a flatfile A.txt 2012/12/04 14:06:07 |trees|Boards 2, 3|denver|mekong|mekong12 2012/12/04 17:07:22 |trees|Boards 2, 3|denver|mekong|mekong12 2012/12/04 17:13:27 |trees|Boards 2, 3|denver|mekong|mekong12 2012/12/04 14:07:39 |rain|Boards 1|tampa|merced|merced11 How do i sort and get...

4. Shell Programming and Scripting

Plz Help. Compare 2 files field by field and get the output in another file.

Hi Freinds, I have 2 files . one is source.txt and second one is target.txt. I want to keep source.txt as baseline and compare target.txt. please find the data in 2 files and Expected output. Source.txt 1|HYD|NAG|TRA|34.5|1234 2|CHE|ESW|DES|36.5|134 3|BAN|MEH|TRA|33.5|234...

5. Shell Programming and Scripting

Compare two files Field by field and output the result in another file

Hi Friends, Need Help. I have file1.txt as File1.txt |123|A|7267|Hyder|Cross|Sell|7801 |995|A|7051|2008|Lunar|New|Year|Promotion|7801 |996|A|7022|Q108|Targ|Prospect|&|SSCC|Savings|Promo|7801 |997|A|7182|Q1|Feb-Apr|08|Credit|ITA|PA|SBA|Campaign|7801 File2.txt...

6. Shell Programming and Scripting

Sort help on non numeric field

Hi, I am unable to sort data on the first field $cat t Jim,212121,Seattle Bill,404404,Seattle Steve,246810,Nevada Scott,212277,LosAngeles Jim,212121,Ohio sort -t"," -k1,2 t Bill,404404,Seattle Jim,212121,Ohio Jim,212121,Seattle Scott,212277,LosAngeles Steve,246810,Nevada

7. UNIX for Advanced & Expert Users

Sort on basis of particular field

05.50.25:AIRE.S:RESTRICTED:S2: 05.50.25:ANDR.VI:RESTRICTED:S2: 05.50.25:BASF.MI:RESTRICTED:N: 05.50.25:BMWG.DE:RESTRICTED:N: 05.50.25:BORE.ST:RESTRICTED:N: I can sort of the basis of second field using " sort -t: -k2,2 " but what i want to sort the data is on the basis its extension e.g.:...

8. Shell Programming and Scripting

Sort alpha on 1st field, numerical on 2nd field (sci notation)

I want to sort alphabetically on the first field and sort in descending numerical order on the 2nd field. With a normal "sort -r -n" it does this: abc ||| 5e-05 ||| bla abc ||| 3 ||| ble def ||| 1 ||| abc def ||| 0.2 ||| def As you can see it ignores the fact that 5e-05 is actually 0.00005...

9. Shell Programming and Scripting

delimiter appears in field

The typical line of the input file is as follows, 123|abcde|"xyz|mn"|ghelosa|3455hello| The delimiter is |. I need to change it to another delimiter, say ~. For the above line, the output should be: 123~abcde~xyz|mn~ghelosa~3455hello~ The challenge is when | appears in a field, it...

10. Shell Programming and Scripting

sort columns by field

hello, i have a table contain many columns delimited by blank. i want to sort this table by the 2 columns and 3 one and i want to keep the first line inchanged? how can i do using the sort command? thanks table like : field1 field2 field3 field4 x y z b t h r n ..

Login or Register to Ask a Question