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 [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>
>
>
>
--
--
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>
