07-19-2013
You can create a
CSV to view them in Excel.
10 More Discussions You Might Find Interesting
1. 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
2. Shell Programming and Scripting
Hi all
I have a shell script that uses a stored proc to generate output from some tables and send the same in an e-mail using mailx command. Now I need to convert the output to excel format and send e-mail. How can I achieve this. Please help me in this regard, as it's very urgent and I have been... (5 Replies)
Discussion started by: sanbabu
5 Replies
3. Shell Programming and Scripting
Hi,
I have an excel sheet which has 100000 records. All these records are having 3 columns each with the last column as "Y" or "N". I would like to filter those records which has the value "Y". Can you please let me know how to proceed with that?
Thanks in advance.
-Sri
----------... (8 Replies)
Discussion started by: bhanusri83
8 Replies
4. 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
5. Shell Programming and Scripting
Hi folks,
I am working on assignment that captures all the records(2 columns one column contains names and other contain date of birth) from excel sheet stored in a directory and checks for current date and month.
If it matches current date and month then the matched records are printed as... (1 Reply)
Discussion started by: giridhar276
1 Replies
6. Programming
guys i have data in excel sheet , how do i convert that data to database table (2 Replies)
Discussion started by: Gl@)!aTor
2 Replies
7. Shell Programming and Scripting
Hi All, Firstly I will like to wish A Happy New Year to all.
Now my issue is
I have one csv file say(data.csv) and one excel file say(result.xls)
The result.xls contains two sheet name Sheet1 and Sheet2, Now What I am trying to do is to First I want to delete that data of Sheet2 if present any,... (6 Replies)
Discussion started by: adisky123
6 Replies
8. 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
9. Shell Programming and Scripting
Hello,
I have the following data format in a log file :
a : x1
b : x2
c : x3
d : x4
--------
a : x5
b : x6
c : x7
d : x8
so the same fields ( a ,b ,c,d) repeated many times in the same log file but with different "x" values (x5,x6,x7,x8).
I need a script to save this data in an... (6 Replies)
Discussion started by: mm00123
6 Replies
10. 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
LEARN ABOUT DEBIAN
bti-shrink-urls
BTI-SHRINK-URLS(1) bti-shrink-urls BTI-SHRINK-URLS(1)
NAME
bti-shrink-urls - convert URLs to a shorter form using a web service
SYNOPSIS
bti [--escaped] [--help] [URL]
DESCRIPTION
bti-shrink-urls converts URLs to a shorter form using a web service.
Currently http://2tu.us/ (default) and http://bit.ly / http://j.mp are supported.
OPTIONS
--escaped
Don't escape special characters in the URL any more, they are already percent encoded.
--help
Print help text.
URL
Specify the URL to be converted. If no URL is given bti-shrink-urls waits for input on stdin.
CONFIGURATION
bti-shrink-urls is configured by setting some values in ~/.bti:
shrink_host
Possible values: 2tu.us (default), bit.ly, j.mp
shrink_bitly_login
API login for bit.ly, j.mp, required if shrink_host is set to bit.ly or j.mp. See
https://code.google.com/p/bitly-api/wiki/ApiDocumentation
shrink_bitly_key
API key for bit.ly, j.mp, required if shrink_host is set to bit.ly or j.mp. See
https://code.google.com/p/bitly-api/wiki/ApiDocumentation
AUTHOR
Written by Bart Trojanowski bart@jukie.net.
COPYRIGHT AND LICENSE
Copyright (C) 2009 Bart Trojanowski bart@jukie.net.
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
the Free Software Foundation version 2 of the License.
bti-shrink-urls March 2009 BTI-SHRINK-URLS(1)