|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
sort a file which has 3.7 million records
Post 302333900 by methyl on Tuesday 14th of July 2009 09:37:27 AM
07-14-2009
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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
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
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
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
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
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
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
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
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
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 DEBIAN
readahead
readahead(8) System Manager's Manual readahead(8) NAME
readahead - file preloader for boot process optimization SYNOPSIS
readahead [options] <file-list> [another-file-list [...]] DESCRIPTION
readahead is a files preloader designed to optimize the disk I/O during the boot process. OPTIONS
-b, --build build optimised files list only, without sorting. -s, --sort build and sort list of files only (implies -b). -o, --output <file> write sorted list of files to file. -d, --dont-sort preload files described by an already sorted files list. -h, --help print the usage information. -v, --verbose enable the verbose mode. -t, --timing report time spent on each operation. -m, --maxsize <max size> maximum size in KiB a file can be in order to be preloaded, default is 10240. <file-list> [another-file-list [...]] One or more files containing the list of files to be preloaded or sorted. The files list can be generated by readahead-collector(8). FILES
/etc/default/readahead-fedora SEE ALSO
readahead-collector(8), readahead(2), AUTHORS
Arjan van de Ven <arjan@infradead.org>, Ziga Mahkovec <ziga.mahkovec@klika.si>, Karel Zak <kzak@redhat.com>, This manual page was written by Raphael Geissert <geissert@debian.org> July 2011 readahead(8)