Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: sort a file which has 3.7 million records
Top Forums Shell Programming and Scripting sort a file which has 3.7 million records Post 302333891 by Neo on Tuesday 14th of July 2009 09:20:48 AM
Old 07-14-2009
Hello,

Per our forum rules, all threads must have a descriptive subject text. For example, do not post questions with subjects like "Help Me!", "Urgent!!" or "Doubt". Post subjects like "Execution Problems with Cron" or "Help with Backup Shell Script".

The reason for this is that nearly 95% of all visitors to this site come here because they are referred by a search engine. In order for future searches on your post (with answers) to work well, the subject field must be something useful and related to the problem!

In addition, current forum users who are kind enough to answer questions should be able to understand the essence of your query at first glance.

So, as a benefit and courtesy to current and future knowledge seekers, please be careful with your subject text. You might receive a forum infraction if you don't pay attention to this.

Thank you.

The UNIX and Linux Forums
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to Sort Records Uniquely?

I have a file containing many records separated by a % that I would like to sort uniquely (and if possible with a count of dupes) while maintaining the integrity of each record. File looks like this: % srcip: 5.6.7.8 srcburb: internal dstip: 1.2.3.4 dstport: 2000 dstburb: external... (12 Replies)
Discussion started by: earnstaf
12 Replies

2. Solaris

How to remove duplicate records with out sort

Can any one give me command How to delete duplicate records with out sort. Suppose if the records like below: 345,bcd,789 123,abc,456 234,abc,456 712,bcd,789 out tput should be 345,bcd,789 123,abc,456 Key for the records is 2nd and 3rd fields.fields are seperated by colon(,). (2 Replies)
Discussion started by: svenkatareddy
2 Replies

3. Shell Programming and Scripting

How to remove duplicate records with out sort

Can any one give me command How to delete duplicate records with out sort. Suppose if the records like below: 345,bcd,789 123,abc,456 234,abc,456 712,bcd,789 out tput should be 345,bcd,789 123,abc,456 Key for the records is 2nd and 3rd fields.fields are seperated by colon(,). (19 Replies)
Discussion started by: svenkatareddy
19 Replies

4. Shell Programming and Scripting

Sort & Split records in a file

Hi, I am new to scripting. I need a script to sort and the records in a file and then split them into different files. For example, the file is: H1...................... H2...................... D2.................... D2.................... H1........................... (15 Replies)
Discussion started by: Sunitha_edi82
15 Replies

5. Shell Programming and Scripting

Extract data from large file 80+ million records

Hello, I have got one file with more than 120+ million records(35 GB in size). I have to extract some relevant data from file based on some parameter and generate other output file. What will be the besat and fastest way to extract the ne file. sample file format :--... (2 Replies)
Discussion started by: learner16s
2 Replies

6. Shell Programming and Scripting

Unix sort for fixed length columns and records

I was trying to use the AIX 6.1 sort command to sort fixed-length data records, sorting by specific columns only. It took some time to figure out how to get it to work, so I wanted to share the solution. The sort man page wasn't much help, because it talks about field delimeters (default space... (1 Reply)
Discussion started by: CheeseHead1
1 Replies

7. UNIX for Dummies Questions & Answers

Grep specific records from a file of records that are separated by an empty line

Hi everyone. I am a newbie to Linux stuff. I have this kind of problem which couldn't solve alone. I have a text file with records separated by empty lines like this: ID: 20 Name: X Age: 19 ID: 21 Name: Z ID: 22 Email: xxx@yahoo.com Name: Y Age: 19 I want to grep records that... (4 Replies)
Discussion started by: Atrisa
4 Replies

8. UNIX for Dummies Questions & Answers

Alphabetical sort for multi line records contains in a single file

Hi all, I So, I've got a monster text document comprising a list of various company names and associated info just in a long list one after another. I need to sort them alphabetically by name... The text document looks like this: Company Name: the_first_company's_name_here Address:... (2 Replies)
Discussion started by: quee1763
2 Replies

9. Shell Programming and Scripting

Matching 10 Million file records with 10 Million in other file

Dear All, I have two files both containing 10 Million records each separated by comma(csv fmt). One file is input.txt other is status.txt. Input.txt-> contains fields with one unique id field (primary key we can say) Status.txt -> contains two fields only:1. unique id and 2. status ... (8 Replies)
Discussion started by: vguleria
8 Replies

10. Shell Programming and Scripting

How to read records in a file and sort it?

I have a file which has number of pipe delimited records. I am able to read the records....but I want to sort it after reading. i=0 while IFS="|" read -r usrId dataOwn expire email group secProf startDt endDt smhRole RoleCat DataProf SysRole MesgRole SearchProf do print $usrId $dataOwn... (4 Replies)
Discussion started by: harish468
4 Replies

LEARN ABOUT NETBSD

quiz

QUIZ(6) 							 BSD Games Manual							   QUIZ(6)

NAME

     quiz -- random knowledge tests

SYNOPSIS

     quiz [-t] [-i file] [question answer]

DESCRIPTION

     The quiz utility tests your knowledge of random facts.  It has a database of subjects from which you can choose.  With no arguments, quiz
     displays the list of available subjects.

     The options are as follows:

     -t      Use tutorial mode, in which questions are repeated later if you didn't get them right the first time, and new questions are presented
	     less frequently to help you learn the older ones.

     -i      Specify an alternative index file.

     Subjects are divided into categories.  You can pick any two categories from the same subject.  quiz will ask questions from the first cate-
     gory and it expects answers from the second category.  For example, the command ``quiz victim killer'' asks questions which are the names of
     victims, and expects you to answer with the cause of their untimely demise, whereas the command ``quiz killer victim'' works the other way
     around.

     If you get the answer wrong, quiz lets you try again.  To see the right answer, enter a blank line.

   Index and Data File Syntax
     The index and data files have a similar syntax.  Lines in them consist of several categories separated by colons.	The categories are regular
     expressions formed using the following meta-characters:

	   pat|pat  alternative patterns
	   {pat}    optional pattern
	   [pat]    delimiters, as in pat[pat|pat]pat

     In an index file, each line represents a subject.	The first category in each subject is the pathname of the data file for the subject.  The
     remaining categories are regular expressions for the titles of each category in the subject.

     In data files, each line represents a question/answer set.  Each category is the information for the question/answer for that category.

     The backslash character (``'') is used to quote syntactically significant characters, or at the end of a line to signify that a continuation
     line follows.

     If either a question or its answer is empty, quiz will refrain from asking it.

FILES

     /usr/share/games/quiz.db  The default index and data files.

BUGS

     quiz is pretty cynical about certain subjects.

BSD
								   May 31, 1993 							       BSD
All times are GMT -4. The time now is 08:14 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy