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>
