I have an Excel spreadsheet with the following data:
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
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)
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)
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)
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)
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)
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)
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)
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)
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)
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
LEARN ABOUT DEBIAN
emboss::gui::conf
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)