Sponsored Content
Full Discussion: to delete a column in unix
Top Forums UNIX for Dummies Questions & Answers to delete a column in unix Post 302096942 by gaddesuneetha on Monday 20th of November 2006 07:40:33 PM
Old 11-20-2006
regarding delete command in unix

Hai

This is the format from which i want to delete the 2nd column and i have to replace it with numbers starting from 1. this file contains 1000 lines of the below format.

ATOM 131 N ASN I 19 13.270 -37.510 4.242 1.00 57.52
ATOM 132 CA ASN I 19 11.912 -37.066 4.598 1.00 57.72

plz let me know the command in unix in command mode.

Regards
suneetha.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

delete 7th column in unix

Hello., i have a file with 15 column. i want to remove the 7th column from the file. i am trying to use awk to delete the 7th column. can anyone help me how to do this thanks (6 Replies)
Discussion started by: pavan_test
6 Replies

2. Shell Programming and Scripting

Delete first row last column

Hi All, I am having following file and I want to delete 1 row last column. Current File Content: ================ procedure test421 put_line procedure test321 test421 procedure test521 test321 procedure test621 test521 Expected File Content: =========================== procedure... (3 Replies)
Discussion started by: susau_79
3 Replies

3. Shell Programming and Scripting

delete first column

Dear All, I need to delete the first column, which blank in the tab delimited file and i need to print all the other columns with out disturbing the format of the file. I have tried with the followings and its not working for my case awk '{$1=""}1' file > newfilecut -d, -f2- dataCan anyone... (6 Replies)
Discussion started by: Fredrick
6 Replies

4. Shell Programming and Scripting

for each different entry in column 1 extract maximum values from column 2 in unix/awk

Hello, I have 2 columns (1st column has multiple entries but the corresponding values in the column 2 may be the same or different.) however I want to extract unique values for each entry in column 1 by assigning the max value from column 2 SDF4 -0.211654 SDF4 0.978068 ... (1 Reply)
Discussion started by: Diya123
1 Replies

5. Shell Programming and Scripting

delete the same column

var1 var2 var3 var4 var5 var6.... A G A T G T G A A A A A A A A A A A G A G T A T let's call this "file1.txt" we can see that var2 and var5 have the idential values. I would like to make a script so that if any variables (could be more than 2) have the identical values, i want to... (4 Replies)
Discussion started by: johnkim0806
4 Replies

6. UNIX for Advanced & Expert Users

Copy a column to another column in UNIX fixedwidth file

Hi All, I have a fixedwidth file of length 3000. Now i want to copy a column of 4 chars i.e( length 1678-1681) to column 1127 – 1171 to the same file. Please let me know how can i achive using a single command in fixed width file. Also source column length is 4 chars and target column length... (4 Replies)
Discussion started by: kiranparsha
4 Replies

7. Shell Programming and Scripting

Delete a row if either of column value is zero

Hi, My input file is this way 1.1 0.0 2.4 3.5 7.9 1.8 22.3 4.7 8.9 0.9 1.3 0.0 3.4 5.6 0.0 1.1 2.2 0.0 0.0 1.1 0.0 0.0 3.4 5.6 I would like to delete the entire row, if either of 2nd and 3rd columns are 0.0. Please note that my values are all decimal values. So, my output would... (4 Replies)
Discussion started by: jacobs.smith
4 Replies

8. Shell Programming and Scripting

Delete last characters in each column

I need to delete the last 11 characters from each number and they are all in the same line (each is in a different column): -6.89080901827020800000 3.49348891708562325136 1.47988367839905286876 -2.29707635413510400000 -3.49342364708562325136 -4.43758473239905286876 -2.29707635413510400000... (14 Replies)
Discussion started by: rogeriog.em
14 Replies

9. Shell Programming and Scripting

Delete part of a column

I want to delete a part of the 4th column from the given file below: <Text Text_ID="10155645315851111_10155645333076543" From="460350337461111" Created="2011-03-16T17:05:37+0000" use_count="123">This is the first text</Text> <Text Text_ID="10155645315851111_10155645317023456"... (2 Replies)
Discussion started by: my_Perl
2 Replies

10. UNIX for Beginners Questions & Answers

UNIX script to compare 3rd column value with first column and display

Hello Team, My source data (INput) is like below EPIC1 router EPIC2 Targetdefinition Exp1 Expres rtr1 Router SQL SrcQual Exp1 Expres rtr1 Router EPIC1 Targetdefinition My output like SQL SrcQual Exp1 Expres Exp1 Expres rtr1 Router rtr1 Router EPIC1 Targetdefinition... (5 Replies)
Discussion started by: sekhar.lsb
5 Replies
ASN2FF(1)						     NCBI Tools User's Manual							 ASN2FF(1)

NAME
asn2ff - convert ASN.1 biological data to a flat format (old version) SYNOPSIS
asn2ff [-] [-A X] [-B X] [-C] [-G] [-L F] [-M] [-R] [-V F] [-a filename] [-b] [-d] [-e] [-f b/p/e/s/x/z] [-g] [-h F] [-k F] [-l filename] [-m r/d/s/c/k/l/e/p] [-n F] [-o filename] [-p F] [-q] [-r filename] [-s] [-t] [-v F] [-w] [-y] [-z] DESCRIPTION
asn2ff converts descriptions of biological sequences from NCBI's ASN.1 format to one of several flat-file formats. This program is built around a deprecated interface; please use asn2gb(1) instead. OPTIONS
A summary of options is included below. - Print usage message -A X Show region starting at X (default is 0) -B X Show region ending at X (default is last position) -C Show Bankit comments -G Output is one top bioseq only in genome view -L F Use old (pre-Genbank 127.0) LOCUS line format -M Output is map bioseqs only -R For GenBank Release -V F Don't use VERSION -a filename Filename for ASN.1 input (default is stdin) -b Input asnfile in binary mode -d Use SeqMgr indexing -e Input is a Seq-entry -f b/p/e/s/x/z Output Format: b GenBank (default) p GenPept e EMBL s PseudoEMBL x GenBankSelect z EMBLPEPT -g Show gi numbers -h F Hide sequence -k F Don't use complex sets (phy-set,mut-set, pop-set) -l filename Log errors to filename -m r/d/s/c/k/l/e/p Output mode: r release (default) d dump s Sequin c Chromoscope k dir-sub-debug l dir-sub e revise p partial report -n F Strict gene_binding -o filename Output Filename (default is stdout) -p F Omit new gene features -q Output is one top bioseq only -r filename Output error logfile (default is stderr) -s Input is a Seq-submit -t Show verbose message text -v F Suppress error messages -w Use HTML output format -y Print help format only -z New algorithm for orgnames AUTHOR
The National Center for Biotechnology Information. SEE ALSO
asn2all(1), asn2asn(1), asn2fsa(1), asn2gb(1), asn2xml(1), asndhuff(1). NCBI
2005-05-16 ASN2FF(1)
All times are GMT -4. The time now is 03:26 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy