[SOLVED] Replacing "Co.Kildare," with "Co.Kildare"

[mikebyrne]

I have a comma separated file with all rows ending with the word Co.Kildare but on a large number of theses rows the word appears with a comma at the end ie Co.Kildare,

 

How could I code the replacement of Co.Kildare, with Co.Kildare?

 

<?php
$test = file_get_contents("C:\Users\Mike\Desktop\AthyDB.txt");

Replacement code??

file_put_contents('C:\Users\Mike\Desktop\test.txt', $test);
?>

[revraz]

http://php.net/str_replace

[mikebyrne]

Something like

 

<?php
$test = file_get_contents("C:\Users\Mike\Desktop\AthyDB.txt");
$field=str_replace('Co.Kildare,','Co.Kildare');
file_put_contents('C:\Users\Mike\Desktop\test.txt', $test)
?>

 

[Maq]

This will get rid of any comma that is at the end of a string:

 

$d = "D,2796,Son,OlerCo.Kildare,";
$currentline=preg_replace('/,$/','', $d);
echo $currentline;

 

[mikebyrne]

How would I apply

 

$currentline=preg_replace('/,$/','', $d);

 

when taking in a file?

[Maq]

Add a '\n' after the comma in the regex and it will pick up the comma then newline.

[mikebyrne]

Something like this?

 

<?php
$test = file_get_contents("C:\Users\Mike\Desktop\AthyDB.txt");
$currentline=preg_replace('/,$/',\n'', $test);
file_put_contents('C:\Users\Mike\Desktop\test.txt', $currentline);
?>

[Maq]

$currentline=preg_replace('/(,\n)$/',n'', $test);

[mikebyrne]

Im getting an error Parse error: parse error in C:\xampp\htdocs\remove.php on line 3

 

with

 

$currentline=preg_replace('/(,\n)$/''', $test)