Hello,
When I run it with multiple files as you guided yesterday, output barisprep.sql seems like (just excerpted related field):
Instead of bold video_id in line including SELECT, I am trying to insert value of related video_id grabbed from the table for related $1 at each line....
Let's say
If video_id of Mr.SmithGoes.to.Washington.mkv is 655, I am trying to replace video_id text shown in bold as 655
If video_id of Human.Traffic.mkv is 1233, I am trying to replace video_id text shown in bold as 1233
i am using the below script and trying to move files in that directory in that pattern to archive. But it doesn;t seem to take the metacharacters. Please sugggest.
Code
Debug output: (1 Reply)
I heard this was possible but from my research I haven't been able to figure it out yet. Seems it should be simple enough. Basically from a high level view I'm trying to accomplish...
. $X='grep foo blah.log'
then 'mysql command SELECT foo FROM bar WHERE ' . $X
or something like that.
... (2 Replies)
Hi Gurus
I have a file called /tmp/CMDB which looks like this
serial: 0623AN1208
hostname: server1
model: x4100
assetID: 1234
I am writing a for loop that will go through this file line by line creating a variable of itself. Using the first iteration of the loop (i.e. the first line) as... (6 Replies)
Hi all,
I have a variable say var1 (output from somewhere, which I can't change)which store something like this:
echo $var1
name=fred
age=25
address="123 abc"
password=pass1234
how can I make the variable $name, $age, $address and $password contain the info?
I mean do this in a... (1 Reply)
I'm running a bash script query and assigning the output to a variable like this:
exists=`mysql -u $USER_NAME --password=$PASSWORD -D "somedb" \
-e "SELECT * FROM somedb.sometable WHERE field1 ='$a' \
AND field2 ='$b' LIMIT 0 , 30";`
which returns something like:
echo... (2 Replies)
Hello. I am writing a simple script that reads a text file and removes records from a mysql database. The items in the text file are of the format:
firstname.middle.lastXXX, where XXX is a 3 digit number. The table has an email field that will match the firstname.middle.last. So, I thought I... (1 Reply)
Is FreeBSD and OpenBSD considered Unix? What O.S does Most of the forum members use? How popular are Licensed Unix operating systems for home users?
Additionally I thought Linux was a Minux fork and BSD was a Unix fork.
Thanks in ... (7 Replies)
Hi all,
I'm bit new to the advanced bash shell scripting.
When I'm looking at some of the existing code in my organization, got confused with a few variable definings.
For ex:
var1={1:-30}
var2="abc def ghi"
var3={xyz:-$var2}
In above, 1st and last lines are confusing me.... (4 Replies)
I'm a bit confused about the term ‘environment variables'.
Within your shell you can set two types of variables:
1. Shell variable - affecting functionality within your shell
2. User defined variable
When using the ‘export' command on a variable you make sure it's being inherited by new sub... (2 Replies)
Discussion started by: niels
2 Replies
LEARN ABOUT DEBIAN
gcap
GCAP.1(1p) User Contributed Perl Documentation GCAP.1(1p)NAME
gcap - Youtube closed caption downloader
SYNOPSIS
gcap [-i] [-t] [-r <regexp>] [--proxy=<addr> | --no-proxy]
[--help] <url> | <video_id>
DESCRIPTION
gcap is a command line tool for downloading Youtube closed captions. The downloaded closed captions are saved in SubRip (srt) file format.
The srt files are saved as "$videoid_$langid.srt" by default.
OPTIONS --help
Print help and exit.
--version
Print version and exit.
-q, --quiet
Be quiet.
-i, --interactive
Open the interactive prompt which can be used to select the items. gcap selects all items by default. See also "INTERACTIVE PROMPT".
-t, --title
Parse video title and use it in the output filename(s) instead of video ID. The default is no.
-r, --regexp=arg
Cleanup video title using the specified arg regular expression. The default is "/(w|s)/g".
--proxy arg
Use arg for HTTP proxy, e.g. "http://foo:1234". Overrides the http_proxy environment setting.
--no-proxy
Disable use of HTTP proxy. Overrides both "--proxy" and http_proxy environment settings.
INTERACTIVE PROMPT
Use the "--interactive" switch to open the prompt. Note that gcap uses (as of 0.1.0) the Umph::Prompt module for this. Once the prompt
opens, type "help" to get a list of commands available to the prompt.
EXAMPLES
gcap 0QRO3gKj3qw
gcap "http://www.youtube.com/watch?v=0QRO3gKj3qw"
Both yield the same results.
gcap -ti 0QRO3gKj3qw
Same as above two but use video title in the filename and choose which of the closed captions should be downloaded.
EXIT STATUS
Exits 0 on success, otherwise 1.
FILES
$HOME/.gcaprc, for example:
echo "--interactive" >> ~/.gcaprc
NOTES
Availability
The following error message produced by gcap (or the XML::DOM module) typically indicates that the video does not have any closed
captions available for it (URL omitted for brewity):
Couldn't parsefile [...] with LWP: no element found at line 1,
column 0, byte -1 at [...]/XML/Parser.pm [...]
http_proxy
gcap depends on XML::DOM which uses LWP::UserAgent to download the data. Note that LWP::UserAgent reads http_proxy environment setting.
e.g.:
env http_proxy=http://foo:1234 gcap video_id
WWW
<http://gcap.googlecode.com/>
<http://repo.or.cz/w/gcap.git>
AUTHOR
Toni Gundogdu <legatvs at sign cpan org>
perl v5.12.4 2011-11-15 GCAP.1(1p)