Textdatei Zeichen in bestimmter Zeile löschen

[bundy]

Moin Moin

Ich erstelle ein Dumpfile, das mehere Insert´s besitzt.
Jetzt will ich in der vorletzten Zeile folgendes änderen ("," -->";")


Dumpfile

Code:

LOCK TABLES callstemp WRITE;
INSERT INTO callstemp VALUES 
(null,"8040197196","Inland","NB-Neusiedl/See","2006-03-01","02167 2603           ","08:03:57","0.45","0.0167","GZ"),
(null,"8040197196","Inland","NB-Neusiedl/See","2006-03-01","02167 2882           ","09:07:53","0.983333333333333","0.04012","GZ"),
(null,"8040197196","Inland","NB-Nickelsdorf","2006-03-05","02146 20007          ","16:24:30","20.5833333333333","0.8398","GZ"),
(null,"8040197196","Inland","Wien","2006-03-06","01 51215074          ","13:09:41","0.15","0.0167","GZ"),
(null,"8040197196","Inland","NB-Neusiedl/See","2006-03-06","02167 7203           ","15:07:49","2.41666666666667","0.0986","GZ"),  <<====== Dieses Zeichen muss ein ";" werden.
UNLOCK TABLES;

lg
Bundy