06-07-2016
Extract UNIX data to excel
Hi,
I would like to extract the data from particular date,
1. may i know which command i need to use?
2. Extract from unix command (those extracted above) to excel?
Please assist.
Thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello All,
I am starting with UNIX. Any help is highly appreciated.
How to extract data using UNIX shell script? And how do you export data using UNIX shell scripts into Microsoft Excel format?
Thank you. (3 Replies)
Discussion started by: desiondarun
3 Replies
2. 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
3. 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
4. Shell Programming and Scripting
Hi
I have a data file in UNIX as follows. I need to send this file in Mail as excel format. but the problem i face is i get the data all in single cells per row. what can i do to get the data in seperate cells.
File -> attachment.xls
data data data data
data1 data1 ... (1 Reply)
Discussion started by: vj8436
1 Replies
5. Shell Programming and Scripting
Hi
HOWTO create in UNIX a Microsoft Excel sheet (with data from Oracle). At the moment I am making CSV files (using SQL statemens with || ';'), but search for more advanced formatting. Don't wish to use Perl.
cheers (4 Replies)
Discussion started by: slashdotweenie
4 Replies
6. Shell Programming and Scripting
Hello viewers,
I am connecting to db2 database from unix. I am executing a query for example
select * from emp.
I need to export the data obtained from the above command to a excel file. Could you please suggest how to proceed on this?
thanks and regards,
k.n.v.santosh (3 Replies)
Discussion started by: santoshaarudhra
3 Replies
7. Shell Programming and Scripting
Hi All,
I have the requirement in unix shell script.
I want to write the "ls -ltr" command out put to excel file as below.
Input :text file data :
drwxr-xr-x 5 root root 4096 Oct 2 12:26
drwxr-xr-x 2 apx aim 4096 Nov 29 18:40
drwxr-xr-x 5 root root 4096 Oct 2 12:26
drwxr-xr-x... (10 Replies)
Discussion started by: Balasankar
10 Replies
8. UNIX for Dummies Questions & Answers
Hi,
i have some data in a temporary file in Unix (the data is taken from the result of an SQL query). Now i want to dump that data into an excel sheet. How to do that. Someone please advise. Thanks
Regards,
Vinit (3 Replies)
Discussion started by: vinit raj
3 Replies
9. UNIX for Dummies Questions & Answers
hi,
i wanted to add unix data to be updated to the excel sheet. (3 Replies)
Discussion started by: rupesh.bombale
3 Replies
10. UNIX for Dummies Questions & Answers
Hi guys - I have a file and output like this below:
File: myfile.dat
File has content like this: ABCD, 34, 456, 2324
I would like excel to have this:
Name (ABCD) Quantity (34), Type (456), Status (2324)
(Name, Quantity, Type and Status are columns)
I would like to export... (4 Replies)
Discussion started by: DallasT
4 Replies
LEARN ABOUT DEBIAN
innoextract
innoextract(1) General Commands Manual innoextract(1)
NAME
innoextract - tool to extract installers created by Inno Setup
SYNOPSIS
innoextract [-behlLqstv] [-ccolor] [-pprogress] installers ...
DESCRIPTION
innoextract is a tool that can extract installer executables created by Inno Setup.
innoextract will extract files from a installers specified on the command line.
To extract a multi-part installer with external data files, only the executable (.exe) file needs to be given as an argument to innoex-
tract.
OPTIONS
-c --color [enable]
By default innoextract will try to detect if the terminal supports shell escape codes and enable or disable color output accord-
ingly. Pass 1 or true to --color to force color output. Pass 0 or false to never output color codes.
--dump Don't convert Windows paths to UNIX paths and don't substitute variables in paths.
-e --extract
Extract all files to the current directory. This is the default action. You may only specify one of --extract , --list and --test
-h --help
Show a list of the supported options.
--language [lang]
Extract only language-independent files and files for the given language. By default all files are extracted.
--license
Show license information.
-l --list
List files contained in the installer but don't extract anything. You may only specify one of --extract , --list and --test
-L --lowercase
Convert filenames stored in the installer to lower-case before extracting.
-p --progress [enable]
By default innoextract will try to detect if the terminal supports shell escape codes and enable or disable progress bar output
accordingly. Pass 1 or true to --progress to force progress bar output. Pass 0 or false to never show a progress bar.
-q --quiet
Less verbose output.
-s --silent
Don't output anything except errors and warnings.
-t --test
Test archive integrity but don't write any output files. You may only specify one of --extract , --list and --test
-v --version
Show the innoextract version number and supported Inno Setup versions.
LIMITATIONS
innoextract currently only supports extracting all the data. There is no support for extracting individual files, components or languages.
Included scripts and checks are not executed.
Data is always extracted to the current directory and the mapping from Inno Setup variables like the application directory to subdirecto-
ries is hard-coded.
innoextract does not check if an installer includes multiple files with the same name and will continually overwrite the destination file
when extracting.
Names for data files in multi-file installers must follow the standard naming scheme.
Encrypted installers are not supported.
SEE ALSO
cabextract(1), unshield(1)
BUGS
No known bugs.
AUTHOR
Daniel Scharrer (daniel@constexpr.org)
1.2 2012-04-01 innoextract(1)