replace carriage returns

[Richard D. Williams]

Thanks to all,

Yes, I am aware of my php options.  Unfortunately, this is not my 
database and I don't think they will give me access.

The xlate solution seems the best, as the data is being imported and 
written out to a filepro file.

Thanks again,

Richard D. Williams

Walter Vaughan wrote:

> Richard D. Williams wrote:
>
>> When importing data from a mysql database, is there any way in 
>> filepro to find and replace a carriage-return in a field?
>>
>> I can nont get the programmer I am dealing with to do it on his end.
>
>
> Do you have an account on the machine that has the MySQL database?
> Can you run phpMyAdmin on that database?
> Can you get the MySQL admin to give you a SQL dump via phpMyAdmin?
>     - if so, you can import it into a MySQL database on a machine
>           that you control, and can export it as you see fit.
>
> The bigger question is, why is the carriage-return a problem?
> There are serveral tools that convert dos <-> unix carriage returns
> without involving filePro.
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
>