RE: specifying a delimiter

2001-05-03 Thread Don Read
On 04-May-01 [EMAIL PROTECTED] wrote: > Hi Paul, > > I am now confronted with another problem. I need to also provide a CSV > version. > I need to use , seperated and " protected text. I have a copy of phpMyAdmin > that will > export to this format, but I need to use this at the shell. > I h

RE: specifying a delimiter

2001-05-03 Thread Paul DuBois
>Hi Paul, >Thanks for the help. I was hoping to accomplish this with MySQl, but in the >end a script works just as good and this is just the first of several I am >using. For what it's worth I ended up using sed. Here is is if somone else >could use it: >sed "s/ /|/g" >^This is

RE: specifying a delimiter

2001-05-03 Thread admin
age- > From: Paul DuBois [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 02, 2001 9:38 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: specifying a delimiter > > > At 9:11 PM -0500 5/2/01, Paul DuBois wrote: > >At 10:01 AM -0500 5/2/01, [EMAIL PROTECTED] wrote:

Re: specifying a delimiter

2001-05-02 Thread Paul DuBois
At 9:11 PM -0500 5/2/01, Paul DuBois wrote: >At 10:01 AM -0500 5/2/01, [EMAIL PROTECTED] wrote: >>Hi, >>Being new to MySQL, I am having a problem getting output from it to the >>shell that is formatted the way I need. I need a table to be written to a >>file with a delimiter. >>something like : >

Re: specifying a delimiter

2001-05-02 Thread Paul DuBois
At 10:01 AM -0500 5/2/01, [EMAIL PROTECTED] wrote: >Hi, >Being new to MySQL, I am having a problem getting output from it to the >shell that is formatted the way I need. I need a table to be written to a >file with a delimiter. >something like : > >#!/bin/sh >mysql -uroot -ptest database < sql >