๐Ÿš€ go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: pl.comp.lang.perl
Article #52293

podstawienie

#52293
From: robert.giedrowiczWYTNIJTO
Date: Mon, 03 Oct 2011 10:45
21 lines
1690 bytes
Jak powinien wygladac skrypt ktory zrealizuje nastepujaca robote.
plik dane.txt zawiera:
103091;16,5;2011-03-01
103107;16;2011-03-10
103126;17,67;2011-02-22
plik ktory ma sie wykonac zawiera wpis:
update tablica_tab t set widok_A = '16,5', widok_B = '2011-03-01' where widok_C
= '103091';
no i jak widac podstawiam w widok_A  B i C, dane z w/w pliku, ale jak to
najprosciej zautomatyzowac, aby koncowym efektem byl plik z zawartoscia

update tablica_tab t set widok_A = '16,5', widok_B = '2011-03-01' where widok_C
= '103091';
update tablica_tab t set widok_A = '16', widok_B = '2011-03-10' where widok_C =
'103107';
update tablica_tab t set widok_A = '17', widok_B = '2011-02-22' where widok_C =
'103126';
itd. itd.

-- 
Wysล‚ano z serwisu OnetNiusy: http://niusy.onet.pl
Technical Details
Message-ID: <2ca0.00000125.4e899264@newsgate.onet.pl>
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!news.onet.pl!newsgate.m10r2.onet.pl!niusy.onet.pl

Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!news.onet.pl!newsgate.m10r2.onet.pl!niusy.onet.pl
From: robert.giedrowiczWYTNIJTO@poczta.onet.pl
Newsgroups: pl.comp.lang.perl
Subject: podstawienie
Date: Mon, 03 Oct 2011 12:45:56 +0200
Organization: Onet.pl
Lines: 21
Sender: news@newsgate.onet.pl
Message-ID: <2ca0.00000125.4e899264@newsgate.onet.pl>
NNTP-Posting-Host: newsgate.m10r2.onet.pl
Mime-Version: 1.0
X-Trace: newsgate.onet.pl 1317638757 3031 213.180.150.14 (3 Oct 2011 10:45:57 GMT)
X-Complaints-To: niusy@onet.pl
NNTP-Posting-Date: Mon, 3 Oct 2011 10:45:57 +0000 (UTC)
X-Mailer: http://niusy.onet.pl
X-Forwarded-For: 128.1.0.104, 213.17.192.179, 10.174.28.52
X-User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; pl; rv:1.9.2.23) Gecko/20110920 Firefox/3.6.23 (.NET CLR 3.5.30729)
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit