Thanks. I sort of knew it was something ridiculous that was causing the
problem. Now I shall hang my head in shame, I kiss your feet in gratitude
and I am going to get all those records updated. I was seriously thinking
of doing it the hard way.
Data base migrations from Oracle or MySQL to TSQL (or the other direction)
must be a seriously miserable process. Even my tiny data base (200+
authors, 560+/_ titles) is unnecessarily brutal.
On Tuesday, August 7, 2012 5:50:37 AM UTC-7, Mic wrote:
>
> You have a missing space after the first comma:
> >>>>>>, '\d\d\d\d-\d\d-\d\d \d\d:\d\d:\d\d',<<<<<< instead of
> >>>>>>,'\d\d\d\d-\d\d-\d\d \d\d:\d\d:\d\d',<<<<<<<<<
>
>
> Le 7 août 2012 à 06:43, Steven a écrit :
>
> A sample line is INSERT INTO books (title, topic_id, description,
> date_aquired, book_id, pages, w_index, w_bibliography, pub_date, subtitle,
> w_illustration, w_maps) VALUES('Humans', 14, 'Then end of the world,
> maybe, maybe not', '2009-01-01 10:52:39', 1, NULL, 0, 0, NULL, NULL, 0, 0);
> and I want to remove the date field gone and replaced with a single comma
>
> I am using ,'\d\d\d\d-\d\d-\d\d \d\d:\d\d:\d\d', . This should work.
> But for some reason it does not. I have show invisibles on and it shows
> only one space between the date and the time, which is what I am using.
>
> At first I assumed that the - had to be escaped. It seems that is not
> the case.
>
> Thanks for the help. I usually have very good luck with advice here.
>
> On Saturday, August 4, 2012 9:20:02 PM UTC-7, Steven wrote:
>>
>> I am trying to remove a date string from an SQL file.
>>
>> I have ,'\d\d\d\d\-\d\d\-\d\d \d\d:\d\d:\d\d', as the string I wish to
>> replace with ,
>>
>> It does not like that.
>>
>> I assume I have to \- because - is a character grep uses
>>
>>
>> Thanks
>>
>
> --
> --
> 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 bbedit@googlegroups.com
> To unsubscribe from this group, send email to
> bbedit+unsubscr...@googlegroups.com
> 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 "supp...@barebones.com" rather than posting to the group.
> Follow @bbedit on Twitter: <http://www.twitter.com/bbedit>
>
>
>
>
>
>
--
--
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 bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscr...@googlegroups.com
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 "supp...@barebones.com" rather than posting to the group.
Follow @bbedit on Twitter: <http://www.twitter.com/bbedit>
