10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Folks,
Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are
1excel.xslx
2excel.xslx
3excel.xslx
now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies
2. Shell Programming and Scripting
Hi Guyz,
I need to extract only the data/time, uid , and the message at the last " invalid password format", to a spread sheet.
this is one of the lines from a log file from which i need to extract them.
i need this message to be clearly formatted in the spread sheet.
can you please help me... (14 Replies)
Discussion started by: remo850
14 Replies
3. Shell Programming and Scripting
hello everyone,
I have a task to input missing data into a file. example of my data below:
Wed Feb 01 09:00:02 EST 2012,,,0.4,0.3,,0.3,,0.3,,0.5,,0.3,,,0.4,0.3,
Wed Feb 01 09:00:11 EST 2012,,,,,,,0.2,,,,,,,,,,
Wed Feb 01 09:00:22 EST... (23 Replies)
Discussion started by: Nolph
23 Replies
4. Shell Programming and Scripting
Hello,
I am fairly new to awk, and I have the following problem.
My file has missing data in the last column, and the program I am pre-processing this file for cannot interpret correctly shortened rows (it just wraps the data around).
Is there a way to force awk to create the same... (6 Replies)
Discussion started by: timert34
6 Replies
5. Shell Programming and Scripting
Hello all,
first off great forum.
Now for my little problem.
Using RHEL 5.4 and awk. Been doing code since a few month. So just starting.
My problem is handeling data on multiple lines.
{
if ($1 != LASTKEY && h ~ /.*\/s_fr_/) {
checkgecos( h, h )
h=""
... (2 Replies)
Discussion started by: maverick72
2 Replies
6. Shell Programming and Scripting
The awk is giving below output:
SELECT
divrel.child_org_idn org_main_idn
NULL ( VARCHAR(200)) div_nam_2
NULL ( VARCHAR(200)) div_nam_3
NULL ( VARCHAR(200)) div_nam_4
NULL ( VARCHAR(200)) div_nam_5
NULL ( VARCHAR(200)) div_nam_6
NULL ( VARCHAR(200)) div_nam_7
... (2 Replies)
Discussion started by: goutam_igate
2 Replies
7. UNIX for Dummies Questions & Answers
Dear All,
Need your help.
In my day to day activities I have to validate/search Excel Sheet data (eg.say Application No. 0066782345) data into the Unix environment file whether the same data is present in that file or not.
There are hundreds of records coming in excel file and I am doing grep... (1 Reply)
Discussion started by: ravijunghare
1 Replies
8. Shell Programming and Scripting
I need to change a cell in an excel sheet to different background color using perl.I tried SaveParse, but was unable to get it
Please help regarding this.
Thanks and Regards,
Neelam G
https://www.unix.com/images/misc/progress.gif (0 Replies)
Discussion started by: gujrathinr
0 Replies
9. UNIX for Dummies Questions & Answers
I need to change a cell in an excel sheet to different background color using perl.
Please help regarding this.
Thanks and Regards,
Neelam G (1 Reply)
Discussion started by: gujrathinr
1 Replies
10. UNIX for Advanced & Expert Users
I have 3 columns in an excel sheet.
c1 c2 c3
EIP_ACCOUNT SMALL_TS_01 select A.* from acc;
All the above 3 col shoud be passed a variable in the unix code.
1.How to read an excel file
2.How to pass these data as variable to the unic script (1 Reply)
Discussion started by: Anne Grace
1 Replies
ODFBUILD(1p) User Contributed Perl Documentation ODFBUILD(1p)
NAME
odfbuild - OpenDocument file creation utility
SYNOPSIS
odfbuild filename.odt
odfbuild filename.odt --title "My Document" --subject "Test"
odfbuild filename.ods --class spreadsheet --source "data.csv" --tablesize "8x16"
cat data.txt | odfbuild filename.odt -
OPTIONS
--class Document class (text, spreadsheet, drawing, presentation)
Default: text
--opendocument (no value). If this option is on, the document will be in
OpenDocument format. Without this option, the format will
be selected according to the general configuration of the
OpenOffice::OODoc installation.
--creator The author of the document. Default: the current user's
login name.
--date Creation date. Default is current local time.
If provided, must be in ISO-8601 format
(YYYY-MM-DDTHH:MM:SS)
--description The description (abstract) of the document. Default: none.
--force (no value). If this option is on, any existing file with
the same path as the target file will be replaced. Without
this option, the program will fail if the target exists.
--generator Software signature to be stored in the file (not visible
for the end user).
Default: "Genicorp OpenOffice::OODoc <version>"
--keywords A list of comma-separated keywords. Default: none.
--source A text file, to be used as the content of the document.
If the document class is 'text', each line is loaded as a new
paragraph with the standard style. If the document class is
'spreadsheet', the file is processed as CSV data and loaded
in one sheet. If the document class is neither 'text' nor
'spreadsheet', the file is not processed.
If source = '-', or if a '-' argument is provided, the data
file is read through the standard input.
--subject The subject of the document. Default: none.
--tablename The name of the sheet to be created if the document class is
'spreadsheet' and if a data file is provided. Default: the name
of the data file, or "Unnamed Sheet" if the data is read from
the standard input.
--tablesize The size of the sheet to be created if the document class is
'spreadsheet' and if a data file is provided, in 'HxW' format
where H is the number of lines and W the number of columns.
Default: '16x8'
--title The title of the document. Default: "Untitled".
--readable_XML (no value). For debugging only. If this option is on, the XML
content of the target file is indented, in order to be later
edited.
perl v5.14.2 2008-05-07 ODFBUILD(1p)