I have a list of names and email addresses, like this. The <tab> markers are actually tabs.
joe.blow <tab> joe.blow@wherever.com
tom.t.hall <tab> tom.t.hall@wherever.com
john.r.smith <tab> john.r.smith@wherever.com
sally.jones <tab> sally.jones@state.or.us
I want to parse the data so that... (3 Replies)
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)
Hi everybody:
I have a problem with how I have to manipulate the data which have specific format like this:
249. 0.30727021E+05 0.30601627E+05 0.37470780E-01 -0.44745335E+02 0.82674536E+03
248. 0.30428182E+05 0.30302787E+05 0.40564921E-01 -0.45210293E+02 ... (5 Replies)
hello everyone,
well I have a file which contains data, I want to add the data on hourly basis, like my file contains data for 24 hours, (so a total of 1440 ) lines.
Now i want to add the data on hourly basis to get average values.
like if I use (head) command it is ok for first go, but... (5 Replies)
Input
Participant number: HAC
Position type Location Distance_start Distance_end Range Mark
1 1 + Front 808 1083 276
2 1 + Front 1373 1636 264
3 1 - Back 1837 2047 211
Participant number: BCD
Position type... (6 Replies)
Hello;
I have this rather tricky problem to solve --(to me, anyways) ..
I am processing the following one liner with tcpdump..
tcpdump -i T3501 -A ether host 00:1e:49:29:fc:c9 or ether host 00:1b:2b:86:ec:1b or ether host 00:21:1c:98:a4:08 and net 149.83.6.0/24 | grep --line-buffered -B... (5 Replies)
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)
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)
Hello good afternoon to everyone.
I'm new to the forum and would like to request your help in handling data. I hope my English is clear.
I have a file (Dato01.txt) to contine the following structure.
# Col1 - Col2 - Col3 - Col4
Patricia started Jun 22 05:22:58
Carolina started Jun... (5 Replies)
Discussion started by: kelevra
5 Replies
LEARN ABOUT DEBIAN
odfbuild
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)