Hi,
I am trying to find a way to read an excel work book with multiple worksheets.
And write each worksheet into a new excel file using perl. My environment is Unix.
For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
Hi,
I am using Solaris 8. My script outputs 4 .csv files. Currently I am SFTPing the files and creating a new excel file with the 4 files as sheets.
Can anyone suggest ways to do this in UNIX ?
Thanks,
David. (2 Replies)
Hi,
I Have a directory(views) and i have 100 .sql files in the same directory.
I need to be add 8 rows in each file.
The format 8 rows has like:
grant select on file_name to User1
/
grant select on file_name to User2
/
grant select on file_name to User3
/
grant select on file_name to... (1 Reply)
Hi Friends,
How to add if data is in different rows.
Input:
1;20091102;20170930;-9.00;|
1;20091026;20170930;-2.00;|
1;20100720;20170930;-25.00;|
1;20090901;20211227;-10.00;|
Output
9+2+25+10 = 46
Thx
Suresh (4 Replies)
i need to write script to copy the txt file to excel. (data can be 2000+), data may not be in order
ex:
my name: abc
age: 20
add: xyz
DOB: 17-mar-2010
add1: adf
add2: guioth
my name: cat
age: 35
DOB: 11-oct-2005
city: yeshjl
add: opq
DOB: 17-mar-2010
add1: atg
add2: gth
add3:ert
... (2 Replies)
Hi All,
i have an excel sheet as below:
day
-----
monday
tuesday
wenesday
thursday
friday
i need to append the two more columns in this existing file below:
insert date should be todays date---
day insert date insert user
---- ---------- ... (3 Replies)
Hi,
Is there a way to find the count of number of rows of a.txt please? Where a.txt is as follows:
/usr/bin/uuencode /tmp/a.csv a.csv > /tmp/a.txt
#a.csv is a comma separated variable file
Cheers,
Girish. (7 Replies)
I am working on an assignment to pull all the records from excel sheet programatically and use the data for further calculations.
In this process, I first defined 10 records in excel sheet and executed the below code.
In the first run it is OK. But after deleting last few rows in excel sheet and... (0 Replies)
All,
I have an excel sheet Excel1.xls that has some entries.
I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls
These may be in different workbooks. They are totally independent made by 2 different users.
I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies
LEARN ABOUT HPUX
split
split(1) General Commands Manual split(1)NAME
split - split a file into pieces
SYNOPSIS
line_count] suffix_length] [file [name]]
nsuffix_length] [file [name]]
Obsolescent
n] [file [name]]
DESCRIPTION
reads file and writes it in pieces (default 1000 lines) onto a set of output files. The name of the first output file is name with
appended, and so on lexicographically, up to (only ASCII letters are used, a maximum of 676 files). If no output name is given, is the
default.
If no input file is given, or if is given instead, the standard input file is used.
Options
recognizes the following command-line options and arguments:
The input file is split into pieces
line_count lines in size.
suffix_length letters are used to form the suffix of the output filenames. This option allows creation of more than 676 output
files. The output file names created cannot exceed the maximum file name length allowed in the directory containing
the files.
The input file is split into pieces
n bytes in size.
The input file is split into pieces
n x 1024 bytes in size. No space separates the n from the
The input file is split into pieces
n x 1048576 bytes in size. No space separates the n from the
The input file is split into pieces
n lines in size. This option is obsolescent and is equivalent to using the option.
EXTERNAL INFLUENCES
Environment Variables
determines the locale for the interpretation of text as single- and/or multi-byte characters.
determines the language in which messages are displayed.
If or is not specified in the environment or is set to the empty string, the value of is used as a default for each unspecified or empty
variable. If is not specified or is set to the empty string, a default of "C" (see lang(5)) is used instead of
If any internationalization variable contains an invalid setting, behaves as if all internationalization variables are set to "C". See
environ(5).
International Code Set Support
Single- and multi-byte character code sets are supported.
SEE ALSO csplit(1).
STANDARDS CONFORMANCE split(1)