Sponsored Content
Top Forums Shell Programming and Scripting Need to increment number in data file Post 302726977 by deneuve01 on Monday 5th of November 2012 12:40:19 PM
Old 11-05-2012
Need to increment number in data file

Hello,

I have an Excel spreadsheet with the following data:
Code:
 
Refntns3_1  char         30 Ref H77 nt codon 1      Reference H77 Nucleotide Codon 1                                             --
Codns3_1    char         30 Obs Nucleotides codon 1 Observed Nucleotides Codon 1                                                 --
Refaans3_1  char         30 Ref  H77 aa codon 1     Reference H77 Amino Acid Codon 1                                             --
Ns3_1       char         30 Obs Amino acid codon 1  Observed Amino Acid Codon 1                                                  --
Mutns3_1    char         30 Ref/Obs aa 1 (b_codes)  Reference and Observed Amino Acid Codon 1 (see mut in b_codes)               --
Synns3_1    int/value     3 Syn codon 1 (b_codes)   Synonymity Code Codon 1 (see syn in b_codes)                    -2:4         --
Aamixns3_1  int/value     3 Mix codon 1 (b_codes)   Mixture/Mutation Code Codon 1 (see aamix in b_codes)            -2:4         --

For the 1,4 and 5 fields - I need to increment the number 1 to the next number up to 100. I have several workbooks where I need to do this - over 7000 entries. I would like to edit this data file - increment the numbers - then copy it all back in.

Let me know if there is a shell, sed, awk or perl script that will do this.

Thank you !
Deneuve01

Last edited by vgersh99; 11-05-2012 at 01:49 PM.. Reason: fixed code tag
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

how to number format a data file without using SED?

Hi I have a file which contains data (list of data) and I want to put a number with bracket 1) 2) 3) etc at the beginning of every successive line I can do it with SED and I can also do it using the nl route but am looking for a different method. I'm guessing I would need some sort of loop... (3 Replies)
Discussion started by: Cactus Jack
3 Replies

2. Shell Programming and Scripting

how to get the data from line number 1 to line number 100 of a file

Hi Everybody, I am trying to write a script that will get some perticuler data from a file and redirect to a file. My Question is, I have a Very huge file,In that file I have my required data is started from 25th line and it will ends in 100th line. I know the line numbers, I need to get all... (9 Replies)
Discussion started by: Anji
9 Replies

3. UNIX for Dummies Questions & Answers

count the number of occurance and increment

Hi, I am trying to count the number of occurance of a specific value in a column and increment the variable in the second column accordingly. I have very little information about Unix. As an example, 21 1 32 1 32 2 45 1 56 1 56 2 56 3 73 1 82 1 Thanks, Natasha (2 Replies)
Discussion started by: natasha
2 Replies

4. Shell Programming and Scripting

How to extract specific data and count number containing sets from a file?

Hello everybody! I am quit new here and hope you can help me. Using an awk script I am trying to extract data from several files. The structure of the input files is as follows: TimeStep parameter1 parameter2 parameter3 parameter4 e.g. 1 X Y Z L 1 D H Z I 1 H Y E W 2 D H G F 2 R... (2 Replies)
Discussion started by: Daniel8472
2 Replies

5. Shell Programming and Scripting

Increment a floating number in ksh

Hi ! How to increment a varibale in ksh. #!/bin/ksh set -x RELEASE_NUM=5.2.103 VAL=0.0.1 RELEASE_NUM=`echo $RELEASE_NUM + $VAL | bc` echo $RELEASE_NUM The above code is throwing this error. + RELEASE_NUM=5.2.103 (2 Replies)
Discussion started by: dashok.83
2 Replies

6. Shell Programming and Scripting

Find line number of bad data in large file

Hi Forum. I was trying to search the following scenario on the forum but was not able to. Let's say that I have a very large file that has some bad data in it (for ex: 0.0015 in the 12th column) and I would like to find the line number and remove that particular line. What's the easiest... (3 Replies)
Discussion started by: pchang
3 Replies

7. Shell Programming and Scripting

To increment the values from the file

Hi I have the file called "file.txt" which contains the following output $cat file.txt sandy <version>1</version> karen <version>2</version> Rob <version>3</version> peter <version>4</version> i want to write a command which will add the value 1 to the digits and show the output... (2 Replies)
Discussion started by: sidh_arth85
2 Replies

8. Shell Programming and Scripting

Need a REGEX to increment the file number of a pdf file

Hello, I have a few thousand .pdf files in various folders each have a naming scheme like this: 006_-_Titled_Document_#34_-_September-25-2011-side-1.pdf In each folder, the number system starts at 001 (as you see on the far left of the file name), and then ends at 999 (maximum .pdf files).... (4 Replies)
Discussion started by: Marcus Aurelius
4 Replies

9. Shell Programming and Scripting

awk processing of variable number of fields data file

Hy! I need to post-process some data files which have variable (and periodic) number of fields. For example, I need to square (data -> data*data) the folowing data file: -5.34281E-28 -3.69822E-29 8.19128E-29 9.55444E-29 8.16494E-29 6.23125E-29 4.42106E-29 2.94592E-29 1.84841E-29 ... (5 Replies)
Discussion started by: radudownload
5 Replies

10. Shell Programming and Scripting

Find a word and increment the number in the word & save into new files

Hi All, I am looking for a perl/awk/sed command to auto-increment the numbers line in file, P1.tcl: run_build_model sparc_ifu_dec run_drc set_faults -model path_delay -atpg_effectiveness -fault_coverage add_delay_paths P1 set_atpg -abort_limit 1000 run_atpg -ndetects 1000 I would like... (6 Replies)
Discussion started by: jypark22
6 Replies
EMBOSS::GUI::Conf(3pm)					User Contributed Perl Documentation				    EMBOSS::GUI::Conf(3pm)

NAME
EMBOSS::GUI::Conf - repository for EMBOSS::GUI site-specific configuration AUTHOR
Luke McCarthy <lukem@gene.pbi.nrc.ca> SYNOPSIS
use EMBOSS::GUI::Conf; $conf = EMBOSS::GUI::Conf->new(); foreach $app ($conf->apps) { ($name, $doc) = @$app; if (!$conf->is_excluded($name)) { ... } } foreach $group ($conf->groups) { $group_name = shift @$group; if (!conf->is_excluded($group_name) { foreach $app (@$group) { ($name, $doc) = @$app; ... } } } DESCRIPTION
EMBOSS::GUI::Conf contains site-specific configuration information for EMBOSS::GUI. Consult the source for a description of the variables that can be set. Public methods are described below: new() Returns a new EMBOSS::GUI::Conf object. This method stores the EMBOSS::GUI::Conf package variables in the object hash, ensures that the specified output path is writeable and adds the EMBOSS binaries to the path. apps() Returns a list of available EMBOSS applications. Each element of the list is a reference to an array containing the name and description of an application. groups() Returns a list of application groups. Each element of the list is a reference to an array containing the name of the group and a list of applications belonging to that group (each application is in turn a reference to an array as described in apps() above.) Note that an individual application can appear in multiple groups. is_excluded($subject) Returns true if the subject is being excluded from public display, false otherwise. $subject is the name of an application or application group as it appears in the output from wossname. databases() Returns a list of available databases. Each element of the list is the name of a database, suitable for use in a USA. matrices() Returns a list of available alignment scoring matrices. Each element of the list is a reference to an array containing the filename of the scoring matrix, suitable for use as the value of a matrix or matrixf argument, and a description of the matrix. codon_usage_tables() Returns a list of available codon usage tables. Each element of the list is a reference to an array containing the filename of the codon usage table, suitable for use as the value of a codon argument, and the name of the species from which it is derived. BUGS
None that I know of. COPYRIGHT
Copyright (c) 2004 Luke McCarthy. All rights reserved. This program is free software. You may copy or redistribute it under the same terms as Perl itself. perl v5.14.2 2013-09-16 EMBOSS::GUI::Conf(3pm)
All times are GMT -4. The time now is 10:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy