How do I specify tab as field separator for sort?


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers How do I specify tab as field separator for sort?
# 1  
Old 04-26-2005
How do I specify tab as field separator for sort?

I'm trying to use sort on a file with tab-delimited fields. I can't figure out how to tell sort to use the tab character as the field separator. I'm trying this on both an HP Unix system and on OS X (using bash on both).

Things I've tried:
sort -t\t
sort -t"\t"
sort -t\"\t\"

I've tried other things out of desperation, but nothing has worked so far.
I've looked through all the messages on the forum but couldn't find an answer. I found one message where someone was using the third form above, but that didn't work for me.

TIA,
-Steve
# 2  
Old 04-26-2005
sort -t `/bin/echo '\t'`
# 3  
Old 04-26-2005
Thanks for the quick reply, but that doesn't seem to work. Here's a sample input file where I've converted the tabs to vertical bars:

a album|c song|2
b album|d song|2
a album|a song|4
a album|b song|1
b album|z song|1
b album|a song|3
a album|f song|3
b album|c song|4

(The real file is an exported playlist from iTunes. This is a simplified test version.) I want to sort by album, then track number. With this file, sort -t\| -k 1,1 -k 3,3n works fine. But with the real file that contains tabs, nothing works. I tried sort -t `/bin/echo '\t'` -k 1,1 -k 3,3n but it sorts by the entire line just like everything else I've tried.
# 4  
Old 04-26-2005
sort -t "`/bin/echo '\t'" -k 1,1 -k 3,3n
# 5  
Old 04-26-2005
Thanks but still no luck. On OS X that still sorts by the entire line. On the HP system, it's rejected as invalid syntax. (I removed the character after the opening double quote since that must be a typo.)
# 6  
Old 04-26-2005
sorry for the typo!

does this sort by the first field?
sort -t "`/bin/echo '\t'`" -k 1,1
# 7  
Old 04-26-2005
Ok, "`/bin/echo '\t'`" did it! Thanks very much for your help and perseverance.

I'm not familiar with the "backwards" single quote. What does that do? (And what do you call it?)
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Inserting a field without disturbing field separator on other fields

Hi All, I have the input as below: cat input 032016002 2.891 97.109 16.605 27.172 24.017 32.207 0.233 0.021 39.810 0.077 0.026 19.644 13.882 0.131 11.646 0.102 11.449 76.265 23.735 16.991 83.009 8.840 91.160 0.020 99.980 52.102 47.898 44.004 55.996 39.963 18.625 0.121 1.126 40.189... (15 Replies)
Discussion started by: am24
15 Replies

2. Shell Programming and Scripting

Field separator

Hello All, I have a file, but I want to separate the file at a particular record with comma"," in the line Input file APPLE6SSAMSUNGS5PRICEPERPIECEDOLLAR600EACH010020340URX581949695US to Output file APPLE6S,SAMSUNGS5,PRICEPERPIECE,DOLLAR600EACH,010020340URX581949695,US This is for... (11 Replies)
Discussion started by: m6248m
11 Replies

3. UNIX for Dummies Questions & Answers

How to sort the 6th field of tab delimited files?

Here's a sample of the data: NAME BIRTHDAY SEX LOCATION AGE ID Jim 05/11/1986 M Japan 27 86 Rei 08/25/1990 F Korea 24 33 Jane 02/24/1985 F India 29 78 I've been trying to sort files using the... (8 Replies)
Discussion started by: maihani
8 Replies

4. Shell Programming and Scripting

Substitute newline with tab at designated field separator

Hello, I need to replace newline with tab at certain lines of the file (every four lines is a record). infile.fq: @GAIIX-300 ATAGTCAAAT + _SZS^\\\cd @GAIIX-300 CATACGACAT + hhghfdffhh @GAIIX-300 GACGACGTAT + gggfcfoutfile: @GAIIX-300 ATAGTCAAAT + _SZS^\\\cd @GAIIX-300 ... (6 Replies)
Discussion started by: yifangt
6 Replies

5. UNIX for Dummies Questions & Answers

change field separator only from nth field until NF

Hi ! input: 111|222|333|aaa|bbb|ccc 999|888|777|nnn|kkk 444|666|555|eee|ttt|ooo|ppp With awk, I am trying to change the FS "|" to "; " only from the 4th field until the end (the number of fields vary between records). In order to get: 111|222|333|aaa; bbb; ccc 999|888|777|nnn; kkk... (1 Reply)
Discussion started by: beca123456
1 Replies

6. Shell Programming and Scripting

how to convert comma delimited file to tab separator

Hi all, How can i convert comma delimited .csv file to tab separate using sed command or script. Thanks, Krupa (4 Replies)
Discussion started by: krupasindhu18
4 Replies

7. Shell Programming and Scripting

Field separator X'1F'

Hi, I have a flat file with fields separated by a X'1F' i have to fetch 4th field from second line. please help me how to achieve it. I tried with below command and its not working. cut -f4 -d`echo -e '\x1f'` filename.txt I am using SunOS. Thanks in advance. (2 Replies)
Discussion started by: rohan10k
2 Replies

8. Shell Programming and Scripting

awk, comma as field separator and text inside double quotes as a field.

Hi, all I need to get fields in a line that are separated by commas, some of the fields are enclosed with double quotes, and they are supposed to be treated as a single field even if there are commas inside the quotes. sample input: for this line, 5 fields are supposed to be extracted, they... (8 Replies)
Discussion started by: kevintse
8 Replies

9. Shell Programming and Scripting

join - using *only* tab as a field separator

I have files with tabs separating the fields but those fields values can have whitespace characters (basically a text string). I want to instruct join to not consider white spaces as separators but only tabs. I have tried: join -t "<Tab>" file1 file2 join -t "<tab>" file1 file2 join -t "\t"... (7 Replies)
Discussion started by: FrancoisCN
7 Replies

10. Shell Programming and Scripting

field separator as regexp

I have some version of AWK that does not support regular expression field separators ( neither do I have nawk or gawk). How do I go about reading a line with the field separator as either the string "=#" or "+=". My data looks like this: abhishek=#nnnnn+#1234+#87 One option is to use... (2 Replies)
Discussion started by: Abhishek Ghose
2 Replies
Login or Register to Ask a Question