RE: specifying a delimiter

2001-05-03 Thread admin
] 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: 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

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 a tab,

RE: specifying a delimiter

2001-05-03 Thread Don Read
On 04-May-01 [EMAIL PROTECTED] wrote: random snipage ahead 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

specifying a delimiter

2001-05-02 Thread admin
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 Then I run that script like this: ./script.sh output.txt

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 Then I