Easy Populate and Semi semi-colon

[Guest]

Hi Everybody

 

With Easy populate I download and save, then open in Excel with the import wizard. I tick the semi colon box as this gives a readable page in columns. When I'm finished I save it and upload it with Easy Populate and get the error:

 

File uploaded.

Temporary filename: /tmp/phpVLeP2F

User filename: EP2005Jun10-391.txt

Size: 1477

 

When I open in excel and tick no boxs , I get a page that's to hard to read. But with I save it and upload it it works fine.

 

 

So where do I change it?? I have read the easypopulate.php page

// **** Field Separator ****
// change this if you can't use the default of tabs
// Tab is the default, comma and semicolon are commonly supported by various progs
// Remember, if your descriptions contain this character, you will confuse EP!
global $separator;
//$separator = "\t"; // tab is default
//$separator = ","; // comma
$separator = ";"; // semi-colon
//$separator = "~"; // tilde
//$separator = "-"; // dash
//$separator = "*"; // splat

 

And to me this is what needs to be change. And this is where it gets change

 

$thetext = $row[$key];
	 // kill the carriage returns and tabs in the descriptions, they're killing me!
	 $thetext = str_replace("\r",' ',$thetext);
	 $thetext = str_replace("\n",' ',$thetext);
	 $thetext = str_replace(";",' ',$thetext);
	 // and put the text into the output separated by tabs
	 $therow .= $thetext . $separator;

 

But that's not working, so I'm totally stuck on where to change it.

 

Any help would be great

 

Rich