On Jan 29, 2012, at 4:15 AM, Jakob Peterhänsel wrote:
>
> Also note: MySQL accept double quotes, so you could also have it like:
>
> ("The Riddler's False Notion","87312","1966-04-28T00:00:00Z",null),
>
In the end, I changed the template used to generate the data to have it produc
double quotes as field delimiters -- escaped double quotes.
> (\"The Riddler's False Notion\",\"87312\",\"1966-04-28T00:00:00Z\",null),
I was then able to do a pure Applescript find/replace of the apostrophes to
escape them, following which I unescaped the double quotes before sending the
text to a do shell script command line for populating the MySQL database.
--
You received this message because you are subscribed to the
"BBEdit Talk" discussion group on Google Groups.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
<http://groups.google.com/group/bbedit?hl=en>
If you have a feature request or would like to report a problem,
please email "[email protected]" rather than posting to the group.
Follow @bbedit on Twitter: <http://www.twitter.com/bbedit>
