Stripslashes before Outfile???

[ehask]

Hey all I just ran into a snag and I cant seem to get around it. I have a
query to select sales by a repID number and export info into an outfile so it
can be imported to ACT!.

Is there anyway to stripslashes before it is put into the outfile?? the
slashes will cause the ACH company to fail the transactions based on Bad
Address. Or strip all the \ out of the outfile

Here is my query

$rpt = "Select * From customers Where rep_id='".$repid."' And ".$rptkind."
= '".$yn."' AND processed ='n' INTO OUTFILE
'/home/callcenter/www/rptdwn/$filename' FIELDS TERMINATED BY ' , ' LINES
TERMINATED BY ' ,[1]\n'";

an address typed : 1234 Any St. would be 1234\ Any\St. or even worse Eric\ Haskins would cause ACH to fail as Acct# would not match Name

[LordShryku]

Look here
You may be able to use trim or replace to strip them out

[ehask]

I dont think that will work. Trim seems to only affect beginning or end. and replace wants a field name.

Also when you run a query from command line the escape chars arent there. So something tells me I am going to have to find a way to open the text file that is created via the SELECT... INTO OUTFILE and remove all the \ chars from the text file.

Any ideas??

Thanks

[LordShryku]

Well, the easiest thing would probably be to do the query in PHP, manipulate the data as you want to, then use touch/fwrite