Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Sort data file by case
Top Forums Shell Programming and Scripting Sort data file by case Post 302953889 by drl on Wednesday 2nd of September 2015 11:38:19 AM
Old 09-02-2015
Hi.
Code:
       -d, --dictionary-order
              consider only blanks and alphanumeric characters

-- man sort

From your sample input file:
Input data file data1:
Code:
xxx	12345		Rat in the house
xxx	12345		CAT in the hat
xxx	12345		Dog in the yard
xxx	12345		BAT in the belfry
xxx	12345		Duck in the pond
xxx	12345		ANT in the garage

via:
sort -d -k3,3 data1
to:
Code:
xxx	12345		ANT in the garage
xxx	12345		BAT in the belfry
xxx	12345		CAT in the hat
xxx	12345		Dog in the yard
xxx	12345		Duck in the pond
xxx	12345		Rat in the house

Best wishes ... cheers, drl
This User Gave Thanks to drl For This Post:
palex
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

data array needs to change upper case to lower case

Hi all, i have a data array as followes. ARRAY=DFSG345GGG ARRAY=234FDFG090 ARRAY=VDFVGBGHH so on.......... i need all english letters to be change to lower case. So i am expecting to see ARRAY=dfsg345ggg ARRAY=234fdfg090 ARRAY=vdfvgbghh so on........ If i have to copy this data in... (8 Replies)
Discussion started by: usustarr
8 Replies

2. Shell Programming and Scripting

Sort a big data file

Hello, I have a big data file (160 MB) full of records with pipe(|) delimited those fields. I`m sorting the file on the first field. I'm trying to sort with "sort" command and it brings me 6 minutes. I have tried with some transformation methods in perl but it results "Out of memory". I was... (2 Replies)
Discussion started by: rubber08
2 Replies

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

4. Shell Programming and Scripting

Ignore Header and Footer and Sort the data in fixed width file

Hi Experts, I want to Sort the data in fixed width file where i have Header and Footer also in file. I m using below commad to do the sort based on field satarting from 15 position to 17 position , but it is not ignoring the Header and Footer of the file while sorting. In the output i am... (5 Replies)
Discussion started by: sasikari
5 Replies

5. Shell Programming and Scripting

Sort a the file & refine data column & row format

cat file1.txt field1 "user1": field2:"data-cde" field3:"data-pqr" field4:"data-mno" field1 "user1": field2:"data-dcb" field3:"data-mxz" field4:"data-zul" field1 "user2": field2:"data-cqz" field3:"data-xoq" field4:"data-pos" Now i need to have the date like below. i have just... (7 Replies)
Discussion started by: ckaramsetty
7 Replies

6. Shell Programming and Scripting

Advanced: Sort, count data in column, append file name

Hi. I am not sure the title gives an optimal description of what I want to do. Also, I tried to post this in the "UNIX for Dummies Questions & Answers", but it seems no-one was able to help out. I have several text files that contain data in many columns. All the files are organized the same... (14 Replies)
Discussion started by: JamesT
14 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 Advanced & Expert Users

Sort mixed data file

I have a text file and each field is separated by semicolon ( ; ). Field number 7 is internally separated by comma ( , ) and pipe ( | ) symbol. I want to sort file based on three different fields which are marked in BOLD. Here first BOLD field will have numbers upto the length of 9 characters,... (6 Replies)
Discussion started by: jnrohit2k
6 Replies

9. Shell Programming and Scripting

Sort data in text file in particular format

I have to sort below output in text file in unix bash 20170308 DA,I,113 20170308 PM,I,123 20170308 DA,U,22 20170308 PM,U,123 20170309 DA,I,11 20170309 PM,I,23 20170309 DA,U,123 20170309 PM,U,233 (8 Replies)
Discussion started by: Adfire
8 Replies

10. Shell Programming and Scripting

Sort file data according to a custom list of string

I have a string of pre defined ip address list which will always remain constant their order will never change like in below sample: iplist=8.8.5.19,9.7.5.14,12.9.9.23,8.8.8.14,144.1.113 In the above example i m considering only 5 ips but there could be many more. Now i have a file which... (15 Replies)
Discussion started by: mohtashims
15 Replies

LEARN ABOUT DEBIAN

lurker-search

LURKER-SEARCH(1)					      General Commands Manual						  LURKER-SEARCH(1)

NAME

       lurker-search -- searches for messages in a lurker database

SYNOPSIS

       lurker-search [-c <config-file>]  [-k <keyword>]  [-d -f -i -v -q]  [<terms>*]

DESCRIPTION

       lurker-search searches a lurker database the same way as the web interface. It can output summary information and delete messages.

OPTIONS

       -c config-file
		 Use this config file for lurker settings.

       -k keyword
		 Tag the matching messages with this keyword.

       -d	 Delete the messages found by this search

       -f	 Don't prompt before deleting

       -i	 Command line paramers are not search terms, but message IDs.

       -v	 Output message summary information

       -q	 Don't output message ids or status

SEARCH TERMS

       Lurker-search accepts these keywords for searching:

       -xxx	 select messages which do NOT match this term

       id:xxx	 select a message by the Message-ID field

       rt:xxx	 select messages which reply to the chosen Message-ID

       th:xxx	 select messages included in this thread

       ml:xxx	 select messages in this mailing list

       gr:xxx	 select messages in this mailing list group

       au:xxx	 select messages with this term in the author fields

       sb:xxx	 select messages with this word in the subject

       lang:xxx  select messages in this language

SEE ALSO

       lurker-index(1), lurker-prune(1), lurker-params(1), lurker-list(1)

       lurker documentation on http://lurker.sourceforge.net/

COPYRIGHT

       Copyright (C) 2002: Wesley W. Terpstra <terpstra@users.sourceforge.net>

       This  program  is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
       the Free Software Foundation; version 2.

       This program is distributed in the hope that it will be useful, but WITHOUT ANY	WARRANTY;  without  even  the  implied	warranty  of  MER-
       CHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more details.

       You  should  have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation,
       Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.

BUGS

       Before reporting a bug, please confirm that the bug you found is still present in the latest official release.  If  the	problem  persists,
       then send mail with instructions describing how to reproduce the bug to <lurker-users@lists.sourceforge.net>.

																  LURKER-SEARCH(1)
All times are GMT -4. The time now is 08:14 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy