Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How do I specify tab as field separator for sort?
Top Forums UNIX for Dummies Questions & Answers How do I specify tab as field separator for sort? Post 70176 by SSteve on Tuesday 26th of April 2005 02:32:34 PM
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.
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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

LEARN ABOUT DEBIAN

mtp_libmtp_album_struct

LIBMTP_album_struct(3)						      libmtp						    LIBMTP_album_struct(3)

NAME

       libmtp - LIBMTP_album_struct

SYNOPSIS

       #include <libmtp.h>

   Data Fields
       uint32_t album_id
       uint32_t parent_id
       uint32_t storage_id
       char * name
       char * artist
       char * composer
       char * genre
       uint32_t * tracks
       uint32_t no_tracks
       LIBMTP_album_t * next

Detailed Description
       MTP Album structure

       Examples:
	   sendtr.c.

Field Documentation
   uint32_t LIBMTP_album_struct::album_id
       Unique playlist ID

       Referenced by LIBMTP_Create_New_Album(), LIBMTP_Get_Album(), LIBMTP_Get_Album_List_For_Storage(), LIBMTP_new_album_t(),
       LIBMTP_Set_Album_Name(), and LIBMTP_Update_Album().

   char* LIBMTP_album_struct::artist
       Name of album artist

       Examples:
	   sendtr.c.

       Referenced by LIBMTP_Create_New_Album(), LIBMTP_destroy_album_t(), and LIBMTP_Update_Album().

   char* LIBMTP_album_struct::composer
       Name of recording composer

       Examples:
	   sendtr.c.

       Referenced by LIBMTP_Create_New_Album(), LIBMTP_destroy_album_t(), and LIBMTP_Update_Album().

   char* LIBMTP_album_struct::genre
       Genre of album

       Examples:
	   sendtr.c.

       Referenced by LIBMTP_Create_New_Album(), LIBMTP_destroy_album_t(), and LIBMTP_Update_Album().

   char* LIBMTP_album_struct::name
       Name of album

       Examples:
	   sendtr.c.

       Referenced by LIBMTP_Create_New_Album(), LIBMTP_destroy_album_t(), LIBMTP_Set_Album_Name(), and LIBMTP_Update_Album().

   LIBMTP_album_t* LIBMTP_album_struct::next
       Next album or NULL if last album

       Examples:
	   sendtr.c.

       Referenced by LIBMTP_Get_Album_List_For_Storage().

   uint32_t LIBMTP_album_struct::no_tracks
       The number of tracks in this album

       Examples:
	   sendtr.c.

       Referenced by LIBMTP_Create_New_Album(), LIBMTP_Get_Album(), LIBMTP_Get_Album_List_For_Storage(), and LIBMTP_Update_Album().

   uint32_t LIBMTP_album_struct::parent_id
       ID of parent folder

       Referenced by LIBMTP_Create_New_Album(), LIBMTP_Get_Album(), and LIBMTP_Get_Album_List_For_Storage().

   uint32_t LIBMTP_album_struct::storage_id
       ID of storage holding this album

       Examples:
	   sendtr.c.

       Referenced by LIBMTP_Create_New_Album(), LIBMTP_Get_Album(), and LIBMTP_Get_Album_List_For_Storage().

   uint32_t* LIBMTP_album_struct::tracks
       The tracks in this album

       Examples:
	   sendtr.c.

       Referenced by LIBMTP_Create_New_Album(), LIBMTP_destroy_album_t(), LIBMTP_Get_Album(), LIBMTP_Get_Album_List_For_Storage(), and
       LIBMTP_Update_Album().

Author
       Generated automatically by Doxygen for libmtp from the source code.

Version 1.1.3							  Sun Feb 17 2013					    LIBMTP_album_struct(3)
All times are GMT -4. The time now is 05:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy