pre-editing text files

[Anon]

For a constantly updated database, I need to get a supposed CSV file to be just that.
Unfortunantly the reccording programm spits the file out with 2 colums of data seperated by merely a space and the other two seperated by a comma and a space. Using the following code I was attempting to remove the comma. this should be able to be done in PHP correct?

function readfromfile(){
$filename = "Sp200103.wet";
$openb = fopen ($filename, "w+");
$string = file ($filename);
for ($n = 0; $n < count($string);
$n++) {
$getline = explode(" ", $string[$n]);
print ("$getline[0]<br>\n$getline[1]<p>\n");
}
}
function writetofile($string){
$nfilename = "whatevernew.rnf";
$open = fopen ($nfilename, "w+");
fwrite ($open, "$string");
fclose ($open);
}
readfromfile();
Print ("$string<br>\n");
$string = eregi_replace (",", "", $string);
Print ("$string<br>\n");
writetofile($string);

All I am getting currently is a blank file in both the original and new .rnf files.

[Anon]

I'm no php expert so I can't answer your problem with definity, however, I had a similar problem once with the file() command because it returned the contents of the argument line by line including the new line command.
ie
$eg = file(./stuff.data)
returned each line in stuff as an element in $eg but included the new line command at the end (sometimes looks like a space)
I had to use trim() to trim the \n from the end
eg $eg[1] = trim($eg[1]);
wonder if this could be of help

[jesus_hairdo]

my first spot is that "$string" bit, should you not just use $string (ie no quotes)?
I'm not sure the procedure is correct (i could be wrong i'm fairly new to php).
:
open file, get a line, do the ereg replace, write the line, get next line, do the ereg, write line etc until you have done all of the lines, then fclose ($file).
something like this maybe ??

$filename = "Sp200103.wet";
$openb = fopen ($filename, "w+");
$string = file ($filename);
for ($n = 0; $n < count($string);
$n++)
{
$string[$i] = eregi_replace (",", " ", $string[$i]);
fwrite ($open, "$string[$i]");
}
fclose ($openb);

Not sure if it works, i think it should do, give it a go & let me know what happens
Jamie

[Anon]

nope that one also reports an empty file.
File permissions are set correctly, so it must be somewhere in my syntax. Any other ideas would be appreciated.

[jesus_hairdo]

hmm. not sure, what happens if you do a print "the line is = $string[$i]"; just before the fwrite and before the eregi ?
Do you get any output, we can then tell at which point the problem lies.

[Anon]

I get blank lines... as if it is not reading any rows to cycle through. Yet it erases all contents of the original file, and will write to a seperate file if I ask it too thought that file too is blank.

the line is = 

does not even get shown.

[jesus_hairdo]

if the 'the line is = ' bit isn't being shown that means that the for loop isn't looping. this means that the $string var is empty.
try changing the line $string = file ($filename);
to $string = file ($openb);
see if that makes any difference

jamie

[Anon]

I had actually already attempted that once and I get a "no such file or directory" error then.
Thanks for the help anyway I am going to try this problem through another route. Ill post if it works any better.