HI
I need to import data from a file which is in comressed format
but system doesn't have enough space to uncompress file
Is there any way so that i can do import from compressed file. (4 Replies)
I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated.
Input:
test_data_1
1 2 90%
4 3 91%
5 4 90%
6 5 90%
9 6 90%
test_data_2
3 5 92%
5 4 92%
7 3 93%
9 2 92%
1 1 92%
...
Output:... (7 Replies)
Hi,
I have a requirement for creating a Perl Script which will perform Data Import process in an automated way and I am elaborating herewith :
Section 1 )
- use the following command line format :
"./import.pl -h hostname -p port -f datafile.txt"
Section 2)
datafile.txt will... (3 Replies)
Hi ,
I want to read the data from 9 tables in oracle DB into 9 different files in the same connection instance (session). I am able to get data from one table to one file with below code :
X=`sqlplus -s user/pwd@DB <<eof
select col1 from table1;
EXIT;
eof`
echo $X>myfile
Can anyone... (2 Replies)
I have been trying to write a simple snip of bash shell code to import from 1 to 100 records into a BASH array.
I have a CSV file that is structured like:
record1,item1,item2,item3,item4,etc.,etc. .... (<= 100 items)
record2,item1,item2,item3,item4,etc.,etc. .... (<= 100 items)... (5 Replies)
Say I have two tables like below..
status
HId sName dName StartTime EndTime
1 E E 9:10 10:10
2 E F 9:15 10:15
3 G H 9:17 10:00
logic
Id devName capacity free Line
1 E 123 34 1
2 E 345 ... (3 Replies)
I have 2 files generated in linux that has common output and were produced across multiple hosts with the same setup/configs. These files do some simple reporting on resource allocation and user sessions. So, essentially, say, 10 hosts, with the same (2) system reporting in the files, so a... (0 Replies)
I want to lookup values from two different tables based on common columns and append. The trick is the column to be looked up is not fixed and varies , so it has to be detected from the header. How can I achieve this at once, for multiple data files, but lookup tables fixed.
The two lookup... (5 Replies)
We have the data looks like below in a log file.
I want to generat files based on the string between two hash(#) symbol like below
Source:
#ext1#test1.tale2 drop
#ext1#test11.tale21 drop
#ext1#test123.tale21 drop
#ext2#test1.tale21 drop
#ext2#test12.tale21 drop
#ext3#test11.tale21 drop... (5 Replies)
What I have:
I have a input.sh (script which basically connect to mysql-db and query's multiple tables to write back the output to output1.out file in a directory)
note: I need to pass an integer (unique_id = anything b/w 1- 1000) next to the script everytime I run the script which generates... (3 Replies)
Discussion started by: kkpand
3 Replies
LEARN ABOUT DEBIAN
xsil2graphics
XSIL2GRAPHICS(1) User Contributed Perl Documentation XSIL2GRAPHICS(1)NAME
xsil2graphics - generate scripts to load xsil output data files
SYNOPSIS
xsil2graphics [options] <xsil_file>
DESCRIPTION
Utility program bundled with xmds, used to generate scripts that load simulation output data into either matlab (http://www.mathworks.com)
or scilab (http://www.scilab.org), which are then used to manipulate the results further if necessary and then to present the results
graphically.
Matlab
To generate a matlab m-file, from the xsil file data_file.xsil use the command:
bash$ xsil2graphics data_file.xsil
or
bash$ xsil2graphics --matlab data_file.xsil
Then at the matlab command prompt:
>> data_file
Scilab
To generate a scilab script file, from the xsil file data_file.xsil use the command:
bash$ xsil2graphics --scilab data_file.xsil
Then at the scilab command prompt:
--> exec('data_file.sci')
OPTIONS -m, --matlab generate matlab m-file script to load data from the xsil data file (the default option)
-s, -scilab generate scilab script file to load data from the xsil data file
-o, --outfile <out_file> specify an alternative output script filename to the default which is the input xsil filename with the .xsil
extension changed to either .m for the matlab m-file or .sci for the scilab script file
EXAMPLES
bash$ xsil2graphics nlse.xsil
Generates the output nlse.m to load the data into matlab
bash$ xsil2graphics -m nlse.xsil
Also generates the output nlse.m but explicitly sets matlab to be the output format
bash$ xsil2graphics --scilab nlse.xsil
Generates the output nlse.sci to load the data into scilab
bash$ xsil2graphics --outfile nlse_new.m nlse.xsil
Generates the output nlse_new.m to load the data into matlab
AUTHORS
Originally written by Greg Collecutt
Maintained by Paul Cochrane with code contributed by Joe Hope
BUGS
No known bugs.
SEE ALSO xmds(1), loadxsil(1)
http://www.xmds.org
COPYRIGHT
Copyright (C) 2000-2004
Code contributed by Greg Collecutt, Joseph Hope and Paul Cochrane
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 2 of the License, or (at your option) any later version.
This program 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, write to the Free Software Foundation,
Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
perl v5.8.2 2004-06-21 XSIL2GRAPHICS(1)