03-10-2009
The excel file works good. But one issue... I have windows directory mounted in unixbox. I am moving the excel files from unix to windows directory. When i open the excel file in windows directory, it is not showing as excel format. The record is showing just comma delimited line. But at the same time, if i ftp the excel file to my local machine, format looks good. Any thoughts...
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I want to read a data from a read command and store it in a file......
Plz send me how I can do that
Ex:
read val
and I want to store this val in a file called temp. (2 Replies)
Discussion started by: krishna_sicsr
2 Replies
2. Shell Programming and Scripting
Hi,
I need to email a data in excel sheet from unix using shell scripting.I could able to generate the data file with tab delimiter with extension .xls could able to email it.
The problem is when a coulmn with 16 digit number is exported, it is showing in scientific format. Any help in... (1 Reply)
Discussion started by: sparan_peddu
1 Replies
3. Shell Programming and Scripting
Hi,
Can any one tell me how to copy data using shell script to a excel file from text file to other columns of excel file,leaving first column unaffected i.e it should not overwrite data in first column.
Say my text file data is:
15-dec-2008 15-dec-2009
16-dec-2008 16-dec-2009
... (7 Replies)
Discussion started by: tucs_123
7 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I need to automate a script.
The process in the script is as follows
Running the script abc.ksh
The report is stored in xyz (flat file)
Need to store the flat file content in an excel sheet.
Your reply is highly appreciated.
Thanks,
Karthick (2 Replies)
Discussion started by: karthickrn
2 Replies
5. Shell Programming and Scripting
Hii friends,
I am a newbie to unix/shell scripting and got stuck in implementing a functionality.Dear experts,kindly spare some time to bring me out of dark pit :confused:..
My requirement is somewhat wierd,let me explain what i have and what i need to do...
1) there are several excel... (1 Reply)
Discussion started by: 5ahen
1 Replies
6. Shell Programming and Scripting
Hi All,
I need to convert the data from excel to database table in sybase. Please provide some sample script..
thanks,
Royal. (1 Reply)
Discussion started by: royal9482
1 Replies
7. Shell Programming and Scripting
hi everybody,
Asking for something that I´m not sure if it´s possible to implement. I hope be clear enough.
Well, my issue is that I´m looking how to copy or extract a particular table content of a website. I get the content from a external feed (Iframe format), the content is updated every... (1 Reply)
Discussion started by: cgkmal
1 Replies
8. Shell Programming and Scripting
I need to write a script to store the contents of a table in a csv file
I'm using Toad, it's a Oracle database. (5 Replies)
Discussion started by: ladyAnne
5 Replies
9. Shell Programming and Scripting
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
10. Shell Programming and Scripting
Hello,
I have a file with the below contents :
Policy Name: Backup_bkp
Policy Type: Catalog_bkp
Active: yes
Effective date: 08/07/2013 02:02:12
Mult. Data Streams: no
Client Encrypt: no
Checkpoint: no
Policy Priority: ... (11 Replies)
Discussion started by: rahul2662
11 Replies
LEARN ABOUT DEBIAN
tangram::type::array::scalar
Tangram::Type::Array::Scalar(3pm) User Contributed Perl Documentation Tangram::Type::Array::Scalar(3pm)
NAME
Tangram::Type/Array/Scalar - map Perl array of strings or numbers
SYNOPSIS
use Tangram::Core;
use Tangram::Type/Array/Scalar; # always
$schema = Tangram::Schema->new(
classes => { NaturalPerson => { fields => {
flat_array =>
{
interests =>
{
table => 'NP_int',
sql => 'VARCHAR(50)',
},
lucky_numbers => 'int', # use defaults
}
DESCRIPTION
Maps references to a Perl array. The persistent fields are grouped in a hash under the "array" key in the field hash.
The array may contain only 'simple' scalars like integers, strings or real numbers. It may not contain references. For arrays of objects,
see Tangram::Type::Array::FromMany and Tangram::Type::Array::FromOne.
Tangram uses a table to save the state of the collection. The table has three columns, which contain
* the id of the container object
* the position of the element in the array
* the value of the element
The field names are passed in a hash that associates a field name with a field descriptor. The field descriptor may be either a hash or a
string. The hash uses the following fields:
* type
* table
* sql
Optional field "type" specifies the type of the elements. If the type is "string"Tangram quotes the values as they are passed to the data-
base. Not specifying a "type" is exactly equivalent to specifying "string".
Optional field "table" sets the name of the table that contains the elements. This defaults to 'C_F', where C is the class of the contain-
ing object and F is the field name.
Optional field "sql" specifies the type that deploy() (see Tangram::Deploy) should use for the column containing the elements. If this
field is not present, the SQL type is derived from the "type" field: if "type" is "string" (or is absent) VARCHAR(255) is used; otherwise,
the "type" field is interpreted as a SQL type.
If the descriptor is a string, it is interpreted as the value of the "type" field and all the other fields take the default value.
perl v5.8.8 2006-03-29 Tangram::Type::Array::Scalar(3pm)