Sponsored Content
Full Discussion: Extract UNIX data to excel
Top Forums UNIX for Beginners Questions & Answers Extract UNIX data to excel Post 302975006 by Don Cragun on Tuesday 7th of June 2016 04:19:37 AM
Old 06-07-2016
Without knowing what data you want to extract, how a datum comes from a date, what date, and what you mean by "Extract from unix command ... to excel" there is little chance that we can help you.

Is this a homework assignment?

If not, give us details about what you are trying to do with sample inputs and corresponding sample outputs, and show us the code that you have written to try to do this on your own.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to extract data using UNIX shell script?

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

how to read the data from an excel sheet and use those data as variable in the unix c

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

Help on email data file as excel from unix!!

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

UNIX -> send data as excel in seperate cells

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

HOWTO create in UNIX a Microsoft Excel-Sheet (with data from Oracle)

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

How to extract data into excel from a database in unix

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

How to write text file data to excel using UNIX shell script?

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

Load UNIX data into excel sheet

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

UNIX data to be updated to ms excel sheet

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

How to extract UNIX output to excel CSV file?

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
BINS(1) 						      General Commands Manual							   BINS(1)

NAME
bins_edit -- Set fields in XML picture description files for BINS SYNOPSIS
bins_edit [-a | --album ] [-m | --html ] [-t title | --title title ] [-e event | --event event ] [-l location | --location loca- tion ] [-p people | --people people ] [-y date | --date date ] [-d description | --description description ] [--longdesc longDe- scription] [--shortdesc shortDescription] [--sample pictureFileName] [-g tag=value | --generic tag=value ] [-h | --help ] [-v | --verbose ] [-q | --quiet ] [file] [files ...] DESCRIPTION
This manual page documents briefly the bins_edit command. This manual page was written for the Debian distribution because the original program does not have a manual page. Instead, it has docu- mentation in HTML in /usr/share/doc/bins/index.html as well as a --help option. bins_edit sets values in the XML picture description files that bins(1) uses to generate galleries. OPTIONS
This program follows the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options is included below. file By default, file is the filename of the XML file with the image properties. If the argument has no .xml suffix, it is added, so you can directly give picture names on the command line. Spaces and other special characters (even newlines) can be used in val- ues given as parameters as long as they are enclosed between quotes. If the --album option is given, the filename refers to the directory of images, and the album.xml in that directory will be modi- fied instead. -a --album edit album description (instead of the default of editing the image description.) In this case, the file parameter must be the source directory of the album. Only the --title, --longdesc, --shortdesc and --sample switches make sense with this option. -m --html input value will be interpreted as HTML code, thus, no HTML encoding or quoting will be done. -t title --title title Set the title (of an image.) -e event --event event Set the event name (of an album or image.) -l location --location location Set the location (of an image.) -p people --people people Set the list of people (of an image.) -y date --date date Set the date (of an image.) -d description --description description Set the description (of an image.) --longdesc longDescription Set the long description (of an album.) --shortdesc shortDescription Set the short description (of an album.) --sample pictureFileName Select the sample picture, within this album, to be used on the album list (template subalbum.html.) Note that the filename is relative to the album directory, and thus doesn't have a directory component. -g tag=value --generic tag=value This lets you set arbitrary fields in the relevant XML file (of the image or the album.) Generic tags appear inside description which appears inside image; the tag appears as the name attribute of a field element, and the value appears as the content of the element. -h --help Gives quick help (which this man page is based on.) -v --verbose This switch can appear several times to increase verbosity level. -q --quiet Suppress output. EXAMPLES
Set the title of the Image.jpg file to "My picture": bins_edit -t "My picture" Image.jpg Set the title and location of all JPEG pictures in the directory: bins_edit --title Holiday --location Paris *.jpg Use of HTML values: bins_edit --html --description '<b>BINS</b> is cool' file.jpg Set the title short description and sample image of the album in the current directory (note the dot as final parameter): bins_edit -a -t "My Album" --sample image.jpg --shortdesc "This is my album" . SEE ALSO
bins (1). AUTHOR
This manual page was written by Mark W. Eichin eichin@thok.org for the Debian system (but may be used by others). As it is mostly derived from the bins_edit program itself, it is covered by the GNU General Public License. BINS(1)
All times are GMT -4. The time now is 10:49 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy