08-06-2014
Oracle provides SET COLSEP ','. Maybe your system has sth. similar? Try ',' or ';'.
This User Gave Thanks to RudiC For This Post:
10 More Discussions You Might Find Interesting
1. Programming
i hav tried to convert binary 2D data into text using binreader and writing into text file using streamwriter.
i use ReadSingle() function to convert from binary to ascii, although it works good in 1D data but not in more dimensions.
the kind of values i get are
-1.265369923E+038
and like
... (2 Replies)
Discussion started by: geet
2 Replies
2. Shell Programming and Scripting
Hi,
I have a file coming in xxx.txt(csv format) i do some work on it and i need to send out as a .xls format. Is there any way there is some code i can use in my script to convert this?
I'm struggling on this.
Thanks (11 Replies)
Discussion started by: Pablo_beezo
11 Replies
3. Shell Programming and Scripting
Hi does anybody know how to convert xls to csv undex linux.
I need only data (that is log from test, dont need any macro and so on) from xls.
Any idea how to do that? Perl? shell? Could you give me any example?
Thanks in advance for answer.
Gracjan (4 Replies)
Discussion started by: Gracjan
4 Replies
4. Shell Programming and Scripting
Hi,
I have problem..How to convert .xls file to .csv..
Plz help me for this problem.. (1 Reply)
Discussion started by: varma457
1 Replies
5. UNIX and Linux Applications
Hi
I wanted to convert some XLS files into CSV format in my UNIX box. Unix box is handling very important data which are related to data warehouse.It is fully optimized by installing minimum packages since server need more resources to handle reports generating.
Just for convert XLS files... (6 Replies)
Discussion started by: luke_devon
6 Replies
6. Shell Programming and Scripting
Hi,
My requirement is to convert the xls to csv file with utf-8 conversion.
Is there any way please suggest me.
Thanks,
Raja (4 Replies)
Discussion started by: cnraja
4 Replies
7. Shell Programming and Scripting
Hi All,
I have created a BI Publisher report in Oracle apps R12.
It has generated the output with *.EXCEL file extension. I have a shell script to mail this output. in my shell script I have copied this file and saved as *.xls file.
But the R12 generated *.EXCEL file is not a real excel... (5 Replies)
Discussion started by: kalidoss
5 Replies
8. Shell Programming and Scripting
Dear Friends,
I am in urgent need for awk/sed/sh script for converting a specific data format (.txt) to .xls.
The input is as follows:
>gi|1234|ref|
Query = 1 - 65, Target = 1677 - 1733
Score = 8.38, E = 0.6529, P = 0.0001513, GC = 46
fd sdfsdfsdfsdf
fsdfdsfdfdfdfdfdf... (6 Replies)
Discussion started by: Amit1
6 Replies
9. Shell Programming and Scripting
Hi
I am trying one perl script to convert xlsx to xls file but could not able to get all the rows and columns in the xls file . This scriptFILE is basically to convert XLSX to CSV .. I am tweaking the script to convert XLSX to XLS file also
#######################FILE... (3 Replies)
Discussion started by: kshitij
3 Replies
10. UNIX for Beginners Questions & Answers
Hi
i have a problem in my job
i try to convert an excel file (xls extention) to text file (tab delimited), but no result with this comand
cat xxx.xls > xxx.txt
Do you have eny idea?
PS: sorry for my english
Thanks!! (4 Replies)
Discussion started by: frisso
4 Replies
LEARN ABOUT DEBIAN
dbix::compat
Compat(3pm) User Contributed Perl Documentation Compat(3pm)
NAME
DBIx::Compat - Perl extension for Compatibility Infos about DBD Drivers
SYNOPSIS
use DBIx::Compat;
my $HaveTypes = DBIx::Compat::GetItem ($drv, 'HaveTypes') ;
DESCRIPTION
DBIx::Compat contains a hash which gives information about DBD drivers, to allow to write driver independent programs.
Currently there are the following attributes defined:
ListFields
A function which will return information about all fields of an table. Needs an database handle and a tablename as argument. Must at
least return the fieldnames and the fieldtypes.
Example:
$ListFields = $DBIx::Compat::Compat{$Driver}{ListFields} ;
$sth = &{$ListFields}($DBHandle, $Table) or die "Cannot list fields" ;
@{ $sth -> {NAME} } ; # array of fieldnames
@{ $sth -> {TYPE} } ; # array of filedtypes
$sth -> finish ;
ListTables
A function which will return an array of all tables of the datasource. Defaults to $dbh -> "tables".
NumericTypes
Hash which contains one entry for all datatypes that are numeric.
SupportJoin
Set to true if the DBMS supports joins (select with multiple tables)
SupportSQLJoin
Set to 1 if the DBMS supports INNER/LEFT/RIGHT JOIN Syntax in SQL select. Set to 2 if DBMS needs a *= b syntax for inner join (MS-SQL,
Sybase). Set to 3 if DBMS needs a = b (+) syntax for inner join (Oracle syntax).
SQLJoinOnly2Tabs
Set to true if DBMS can only support two tables in inner joins.
HaveTypes
Set to true if DBMS supports datatypes (most DBMS will do)
NeedNullInCreate
Set to 'NULL' if DBMS requires the NULL keyword when creating tables where fields should contains nulls.
EmptyIsNull
Set to true if an empty string ('') and NULL is the same for the DBMS.
LimitOffset
An function which will be used to create a SQL text for limiting the number of fetched rows and selecting the starting row in selects.
Keys that aren't needed anymore
Placeholders
Gives information if and how placeholders are supported:
0 = Not supported
1 = Supported, but not fully, unknown how much
2 = Supported, but perl type must be the same as type in db
3 = Supported, but can not give a string when a numeric type is in the db
10 = Supported under all circumstances
QuoteTypes
Gives information which datatypes must be quoted when passed literal (not via a placeholder). Contains a hash with all type number which
need to be quoted.
$DBIx::Compat::Compat{$Driver}{QuoteTypes}{$Type}
will be true when the type in $Type for the driver $Driver must be quoted.
Supported Drivers
Currently there are entry for
DBD::mSQL
DBD::mysql
DBD::Pg
DBD::Solid
DBD::ODBC
DBD::CSV
DBD::Oracle
DBD::Sysbase
DBD::Informix
if you detect an error in the definition or add an definition for a new DBD driver, please mail it to the author.
AUTHOR
G.Richter <richter*dev.ecos.de>
SEE ALSO
perl(1), DBI(3), DBIx::Recordset(3)
perl v5.10.1 2010-03-05 Compat(3pm)