Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
I re-post my question to seek your help and critique. I was required to verify a very large and tab-delimited file, named 'MyFile'.
1. The each line in 'MyFile' has 7 columns, and that the values in the 5th column are integers. I need to use shell functions (and standard LINUX/UNIX filters) to... (1 Reply)
Hi All,
I am trying to pivot the contents in a file.
Ex: I have a file sample.txt with data "A B C D", i need the contents to pivot & resulting file should look like "A
B
C
... (3 Replies)
Hi ,
I have a text file noname.txt containing 1000+ records like this. One of the record I have given below.
Input will b e like this
BOT:
2010/06/01 00:25:59
21 = "private"
Access-Method = 31
NCC = GBR
01 = "340806@osiris.fr.ft"
04 =... (2 Replies)
Hi
Please suggest a script that would do a horizontal pivot , on the fields separated by a semicolon
Below is my input file 1|c2|aa
1|c3|dd
1|c4|cc
1|c5|aa
1|c6|ss
1|c7|dd
1|c8|bb
1|c9|jjj
1|c10|kkk
1|c11|fffg
1|c12|nnn;indi;pak;linf;wer
1|c13|lllnk;li;sdfsd;oiuo
1|c14|ppp... (5 Replies)
Hi, I need to generate graph from the text file in Unix server.
The file contains the following data,
Fri Feb 03 07:01:00 PST 2012|3325
Fri Feb 03 07:02:00 PST 2012|3349
Fri Feb 03 07:03:00 PST 2012|3290
Fri Feb 03 07:04:00 PST 2012|3496
Fri Feb 03 07:05:00 PST 2012|3362
Fri Feb 03 07:06:00... (2 Replies)
Hi All ,
I have a file as below .
A "1"
B "2"
C "3"
D "4"
E "5"
F "6"
A "11"
B "21"
C "31"
D "41"
E "51"
F "61"
And the output should be like
A B C D E F
1 2 3 4 5 6
11 21 31 41 51 (8 Replies)
Hi, I am new at using shell scripting. So I have a question for the more experienced Linux users. I would like to perform some kind of pivot on a file.
Example Input file
COL1,"2001-01-01","2001-03-01","2001-03-24"
A1,22,,44
B1,56,78,12
C2,5,,
I would like to have to following output... (2 Replies)
Discussion started by: shanlinux
2 Replies
LEARN ABOUT DEBIAN
bp_bioflat_index
BP_BIOFLAT_INDEX(1p) User Contributed Perl Documentation BP_BIOFLAT_INDEX(1p)NAME
bioflat_index.pl - index sequence files using Bio::DB::Flat
DESCRIPTION
Create or update a biological sequence database indexed with the
Bio::DB::Flat indexing scheme. The arguments are a list of flat files
containing the sequence information to be indexed.
USAGE
bioflat_index.pl <options> file1 file2 file3...
Options:
--create Create or reinitialize the index. If not specified,
the index must already exist.
--format <format> The format of the sequence files. Must be one
of "genbank", "swissprot", "embl" or "fasta".
--location <path> Path to the directory in which the index files
are stored.
--dbname <name> The symbolic name of the database to be created.
--indextype <type> Type of index to create. Either "bdb" or "flat".
"binarysearch" is the same as "flat".
Options can be abbreviated. For example, use -i for --indextype.
The following environment variables will be used as defaults if the corresponding options are not provided:
OBDA_FORMAT format of sequence file
OBDA_LOCATION path to directory in which index files are stored
OBDA_DBNAME name of database
OBDA_INDEX type of index to create
perl v5.14.2 2012-03-02 BP_BIOFLAT_INDEX(1p)