Sponsored Content
Top Forums Shell Programming and Scripting Sorting the records in the Flat file Post 302273885 by frostmourn on Tuesday 6th of January 2009 04:36:47 AM
Old 01-06-2009
Code:
head -1 file >tmp.txt&&sed '1d' file|sort -d -u -k1 >>tmp.txt

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sorting a flat file based on multiple colums(using character position)

Hi, I have an urgent task here. I am required to sort a flat file based on multiple columns which are based on the character position in that line. I am restricted to use the character position instead of the space and sort +1 +2 etc to do the sorting. I understand that there is a previous... (8 Replies)
Discussion started by: cucubird
8 Replies

2. Shell Programming and Scripting

Inserting records from flat file to db table

I have 20000 numbers present in a file in each line like 25663, 65465, 74579, 56446, .. .. I have created a table in db with single number column in it. create table testhari (no number(9)); I want to insert all these numbers into that table. how can i do it? can anybody please... (4 Replies)
Discussion started by: Hara
4 Replies

3. UNIX for Advanced & Expert Users

Records mismatch while sorting in MPRAS and SunOS

Hi, As part of migrating a script from SunOS to MP RAS, the following script is not functioning in desired way. sort -t\| -u +6 -7 +12 -14 textfile1.out > \ textfile2uniq.out The -u is fetching unique records differently on SunOS and MP RAS Pentium IV. And thus the records... (1 Reply)
Discussion started by: RRVARMA
1 Replies

4. Shell Programming and Scripting

How to delimit a flat file with records with SED

Hi gurus, hoping someone can help with a sed line that can do the following... I have a flat file with about 1000 records, but in order to import into openoffice spreadsheet, I need to create a delimited file. I'd like to do 2 things with the SED command: 1- add a pipe character "|" at the end... (4 Replies)
Discussion started by: RogCor
4 Replies

5. UNIX for Dummies Questions & Answers

Conditional sorting on fixed length flat file

I have a fixed length file that need to be sorted according to the following rule IF B=1 ORDER by A,B Else ORDER by A,C Input file is ABC 131 112 122 231 212 222 Output needed ABC 112 131 122 212 231 222 (1 Reply)
Discussion started by: zsk_00
1 Replies

6. Shell Programming and Scripting

How do I load records from table to a flat file!

Hi All, I need to load records from oracle table XYZ to a flat file say ABC.dat. could any one tell me how do i do this in UNXI, Regards Ann (1 Reply)
Discussion started by: Haque123
1 Replies

7. Shell Programming and Scripting

Sorting the records for a file

hi, Please suggest me how to do this logic say i am dynamically taking a file name into the script. when ever a file name it should sort the all the records based on the first character in every line except the heading line and ending line. for example file1 heading... (1 Reply)
Discussion started by: angel12345
1 Replies

8. Shell Programming and Scripting

Remove somewhat Duplicate records from a flat file

I have a flat file that contains records similar to the following two lines; 1984/11/08 7 700000 123456789 2 1984/11/08 1941/05/19 7 700000 123456789 2 The 123456789 2 represents an account number, this is how I identify the duplicate record. The ### signs represent... (4 Replies)
Discussion started by: jolney
4 Replies

9. Shell Programming and Scripting

Sorting group of records and loading last record

Hi Everyone, I have below record set. File is fixed widht file 101newjersyus 20150110 101nboston us 20150103 102boston us 20140106 102boston us 20140103 I need to group record based on first 3 letters in our case(101 and 102) and sort last 8 digit in ascending order and print only... (4 Replies)
Discussion started by: patricjemmy6
4 Replies

10. Shell Programming and Scripting

Sorting a file of book records

I have a texinfo file containing book records and I want to sort them. An example is shown below. Records are separated by two blank lines. The sort pattern I want to sort is starting from the beginning of the year declaration and finishing at the beginning of the book title where I use the... (4 Replies)
Discussion started by: Danette
4 Replies
PROFTMB(1)							   User Commands							PROFTMB(1)

NAME
proftmb - per-residue prediction of bacterial transmembrane beta barrels SYNOPSIS
proftmb [options] DESCRIPTION
proftmb predicts bacterial transmembrane beta barrels from sequence using profile fed Hidden Markov Models (HMM). Output format Self-annotating. Letters of prediction: 'i' - inside cytoplasm, 'O' - outside cytoplasm, 'U' - up (on chain moving out of cytoplasm), 'D' - down (on chain moving into cytoplasm). References Bigelow, H. and Rost, B. (2006). PROFtmb: a web server for predicting bacterial transmembrane beta barrel proteins. Nucleic Acids Res, 34(Web Server issue), W186-8. To invoke the menu, type: proftmb --menu The options are: -d, --directory-root <STRING> root path where files (options -s,-r,-l,-a,-e,-t,-u,-z,-n) reside -a, --reduction-state-decode <STRING> state reduction for decoding -b, --reduction-state-report <STRING> state reduction for reporting -m, --membrane-strand-states <STRING> list of membrane strand states -z, --z-curve-file <STRING> file containing means and sd's at integral length values -x, --z-calibration-curve <STRING> file mapping coverage and accuracy values to z-scores -n, --null-frequency <STRING> background frequency file -c, --minimum-score-cutoff <DOUBLE> minimum z-score for per-residue prediction -o, --outfile-prefix <STRING> output file prefix for the three files generated: PREFIX_dat.txt, PREFIX_proftmb_pretty.txt PREFIX_proftmb_tabular.txt -s, --static-model-data <STRING> data representing the model architecture -t, --trained-params <STRING> params representing the encoded training data -q, --test-blastQ-file-or-dir <STRING> psiblast profile (-Q) or directory (full pathname or relative to current directory) with many profiles -w, --single-sequence-name <STRING> if -q option points to a single file, this is the name -v, --list-blastQ-files <STRING> list of psiblast files to process in directory (leave blank to process all files) --outfile-pretty <STRING> pretty output file (overrides automatic name PREFIX_proftmb_pretty.txt) --outfile-tab <STRING> tabulated output file (overrides automatic name PREFIX_proftmb_tabular.txt) --outfile-dat <STRING> data output file (overrides automatic name PREFIX_dat.txt) --version <BOOL> output version information and exit --quiet <BOOL> be quiet EXAMPLES
proftmb @/usr/share/proftmb/options -q /usr/share/doc/proftmb/examples/example.Q -o /tmp/example The above produces 3 output files: /tmp/example_proftmb_tabular.txt, /tmp/example_proftmb_pretty.txt and /tmp/example_dat.txt. Compare these to the examples in /usr/share/doc/proftmb/examples. BUGS
Please report bugs at <https://rostlab.org/bugzilla3/enter_bug.cgi?product=proftmb>. COPYRIGHT
Copyright (C) 2004 Henry Bigelow 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, either version 3 of the License, or (at your option) any later version. This package 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, see <http://www.gnu.org/licenses/>. proftmb 1.1.10 February 2012 PROFTMB(1)
All times are GMT -4. The time now is 11:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy