09-07-2007
hey prasee,
just let me know what xactly u need ???
i can optimized the query in order to return the o/p(no duplicate), in single excel sheet.
but even i am not sure how you are going to export the 2 different queries o/p to a single excel sheet with different tabs ????
can u let me know, whether table1 and table2 are same????
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Everyone,
I need a shell/perl script to bring selected columns from all the files located in a directory and place them in a new file side by side.
File1:
a b c d
2 3 4 5
f g h i
..........
File2:
I II III IV
w x y z
..............
and so on many files are there...... (8 Replies)
Discussion started by: ks_reddy
8 Replies
2. Shell Programming and Scripting
I have 2 text files, both have one simple, single column. The 2 files might be the same length, or might not, and if not, it's unknown which one would be longer.
For this example, file1 is longer:
---file1
Joe
Bob
Mary
Sally
Fred
Elmer
David
---file2
Tomato
House
Car... (3 Replies)
Discussion started by: cajunfries
3 Replies
3. Web Development
I have installed WAMPSERVER 2.0 on my windows vista x64 system but still am having issues with getting the webserver to be seen outside my local network. It is working fine within my local network.
Been through several setup tutorials so far, no dice still.
For testing purposes I have... (1 Reply)
Discussion started by: davidmanvell
1 Replies
4. Shell Programming and Scripting
Input file_1:
P78811
P40108
O17861
Q6NTW1
P40986
Q6PBK1
P38264
Q6PBK1
Q9CZ49
Q1GZI0
Input file_2: (6 Replies)
Discussion started by: patrick87
6 Replies
5. Shell Programming and Scripting
Hi I'm trying to compare 3 or more files based on similar values and outputting them into 3 columns.
For example:
file1
ABC
DEF
GHI
file2
DEF
DER
file3
ABC
DER
The output should come out like this
file1 file2 file3
ABC ABC (4 Replies)
Discussion started by: zerofire123
4 Replies
6. Shell Programming and Scripting
I have about 100s of files of type text in a known directory. I want to merge all files side by side. Number of lines in all the files will remain same.
For example file1 contains
cat
dog
File 2 contains
rat
mat
Output file should be
cat rat
dog mat
Using awk I was able to... (5 Replies)
Discussion started by: kanthrajgowda
5 Replies
7. Shell Programming and Scripting
Hi Team,
I have input like
Input file.txt
Contents:
Total: 939720704 bytes
Total: 521142272 bytes
Total: 262144 bytes
Total: 786432 bytes
Total: 9043968 bytes
Total: 9371648 bytes
I need out put like the content of file should be side by side.that is 1st line beside... (3 Replies)
Discussion started by: rocking77
3 Replies
8. Shell Programming and Scripting
Dear all,
How can I print any variable or string value side by side for each line within a loop? For example I have 300 zeros and I want to get an output like below lines. Each line have to be truncated at the end of the lines ( eg. 80 characters).
0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0... (4 Replies)
Discussion started by: bulpak
4 Replies
9. Shell Programming and Scripting
Hello,
I know it is too simple but I do not know..
:/
#!/bin/bash
for file in *.mp4
do
echo "$file"
ffmpeg -i $file 2>&1 | grep Duration |cut -d ' ' -f 4 | sed s/,//
done
Expected Output:
NF_-_Let_You_Down-fbHbTBP_u7U.mp4 00:03:35.74
NF_-_WHY-zuJV-DAv_wE.mp4 00:03:11.87... (7 Replies)
Discussion started by: baris35
7 Replies
10. Shell Programming and Scripting
Could I run 2 python scripts at the same time side by side output on the same line in this same format but with scripts?
from itertools import izip_longest
with open("file1") as textfile1, open("file2") as textfile2:
for x, y in izip_longest(textfile1, textfile2, fillvalue=""):
x =... (4 Replies)
Discussion started by: bigvito19
4 Replies
LEARN ABOUT DEBIAN
swac-get
SWAC-GET(1) General Commands Manual SWAC-GET(1)
NAME
swac-get - audio collections of words (SWAC) manager
SYNOPSIS
swac-get [-t] [clear] [update] | [upgrade] | [select <url|packid>] | [deselect <url|packid>] | [list] | [list-sources] | [list-available] |
[sql <query>] | [--help] | [--version]
DESCRIPTION
Swac-get is a simple command line program which allows to download and install audio collections of words (SWAC) in a SQLite3 database.
Audio collections can be imported from the hard drive or directly from the Internet using the HTTP protocol. Swac-get is designed to be
used with swac-explore, a GTK+ interface which allows the browsing of the created SQLite3 database. An important set of free audio collec-
tions of words (SWAC) is available at: http://swac-collections.org/
For more information, please, visit the Shtooka Project homepage at: http://shtooka.net/ .
COMMANDS
clear clear database
deselect <url|packid>
delete records of the package <url|packid> from the database
list list installed packages
list-available
list available packages
list-sources
list source repositories
sql <query>
execute a sql query in the database
select <url|packid>
insert records of the package <url|packid> in the database
ex: swac-get select file:///home/<my directory>/
swac-get select http://packs.shtooka.net/<my package>/ogg/
swac-get select fra-balm-voc
select source-delete <url>
delete <url> from the repositories list
source-deselect <url>
deselect <url> from the repositories list
source-select <url>
add <url> to the repositories list
ex: swac-get source-select http://packs.shtooka.net/
swac-get source-select file:///home/<my directory>/
update update the list of available packages
upgrade
upgrade installed packages
OPTIONS
-t, --target <path>
set the SQLite3 database path (default path is ~/.swac/swac.db)
-v, --version
print version information and exit
-h, --help
print this help and exit
EXAMPLES
swac-get source-select http://packs.shtooka.net/
swac-get update
swac-get select chi-balm-hsk1
swac-get select fra-balm-voc
BUGS
swac-get doesn't care about the version number for the upgrade command.
AUTHOR
swac-get and this manual page were written by Nicolas Vion <nico@picapo.net>.
mai 25, 2008 SWAC-GET(1)