It's just a "word" that marks the start, and end of a "here-document". It could be pretty much anything you like.
Quote:
<<[-]word The shell input is read up to a line that is the same as word after any quoting has been removed,
or to an end-of-file. No parameter substitution, command substitution, arithmetic substitution
or file name generation is performed on word. The resulting document, called a here-document,
becomes the standard input.
By convention, people often use either ! or EOF as "word"
is the same thing.
The XLS file is encoded inside the here-document, and sent as an attachment in the mail.
I am trying to zip and email a .csv file from my unix box to myself and I get corrupt file.
I have used the gzip to zip the file and I am using Winzip to try to unzip it. I'm not sure what I am doing wrong. Should I be using the zip command? (4 Replies)
Hello,
I am trying to return the name of the resulting file from a .zip archive file using unix unzip command.
unzip c07212007.cef7081.zip
Archive: c07212007.cef7081.zip
SecureZIP for z/OS by PKWARE
inflating: CEP/CEM7080/PPVBILL/PASS/G0063V00
I used the following command to unzip in... (5 Replies)
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)
Hi,
New to Unix and trying to do something -
I am trying to zip bunch of file and email -
/sbin/sh
If i use mail then I can not specify subject -
uuencode file.zip file.zip | mail -s "testfile" mailadd@group.com
Error is - mail: illegal option -- s
If i use mailx then I can specify... (7 Replies)
I am getting an xls file in the dir errorpath. I would like to zip it. Kindly help me on this.
The code is as below.
sqllst=$errorpath/$run_pgm.${date_stamp}".xls" sqlstatus=$errorpath/$run_pgm"."${date_stamp}".sqlstatus" sqlscript=$binpath"/im_rpt.sql" (2 Replies)
i want to zip the 2GB file
and send it via email from unix machine using uuencode.
could you please suggest whether it will possible or not
and also command to do it. (3 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)
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)
Hi ,
I have one excel file in zipped format which contains data with size 157 MB. It's original size is 2.6 GB so to send to user I zipped the file.
Now user is saying unable to open the file at once because of huge size and want to split the excel file into 3 files randaonly and zip them.... (1 Reply)
I need something to say if these two file extensions exist in this directory *err and *rpt
zip up these files into one zip file and email them to me.
If they don't exist wait 2 hours and check again.... Not sure how to determine if I need to do an if then statement or a while true or a for... (1 Reply)
Discussion started by: xgringo
1 Replies
LEARN ABOUT DEBIAN
xls2csv
xls2csv(1) General Commands Manual xls2csv(1)NAME
xls2csv - reads MS-Excel file and puts its content as comma-separated data on standard output
SYNOPSIS
xls2csv [-xlV] [-f format ] [-b string ] [-s charset ] [-d charset ] [-q number ] [-c char] files
DESCRIPTION
xls2csv reads MS-Excel spreadsheet and dumps its content as comma-separated values to stdout. Numbers are printed without delimiters,
strings are enclosed in the double quotes. Double-quotes inside string are doubled.
OPTIONS -x print unknown Unicode chars as xNNNN, rather than as question marks
-l list known charsets and exit successfully
-cchar cell separator char. By default - comma.
-bstring
sheet break string. This string (by default - formfeed) would be output at the end of each workbook page. This string is printed
after page starting at start of line, but no linefeed would be automatically added at the end of string. Include newline at the ent
of sheet separator if you want it to appear on separate line by itself
-gnumber number of decimal digits in the numbers. By default maximal double precision (system-dependent macro DBL_DIG) is used.
-qnumber
set quote mode. In quote mode 0 cell contents is never quoted. In quote mode 1 only strings which contain spaces, double quotes or
commas are quoted. In quote mode 2 (default) all cells with type string are quoted. In quote mode 3 all cells are quoted.
-dcharset`
- specifies destination charset name. Charset file has format described in CHARACTER SETS section of catdoc(1) manual page. By
default, current locale charset would be used if langinfo support was enabled at the compile time.
-scharset
- specifies source charset. Typically, Excel files have CODE PAGE record, which denotes input charset, but for some reason you may
wish to override it.
-fformat
- specifies date/time format to use for output of all Excel date and time values. If this option is not specified, format, speci-
fied in the spreadsheet is used. On POSIX system any format, allowed by strftime(3) can be used as value of this option. Under MS-
DOS xls2csv implements limited set of strftime formats, namely m, d, y, Y, b, l, p, H, M, S.
-V outputs version number
FILES
${HOME}/.catdocrc, catdoc charset files and substitution map files (see catdoc(1) manual page for details,
SEE ALSO cat(1), catdoc(1), strings(1), utf8(7), unicode(7)AUTHOR
V.B.Wagner <vitus@45.free.net>, based on biffview by David Rysdam
MS-Word reader Version 0.94.4 xls2csv(1)