Is there a way in RegEx to say 'replace all of these except...'? In the following text:
('The Riddler's False Notion','87312','1966-04-28T00:00:00Z',null), ('Scat, Darn Catwoman','87251','1966-03-30T00:00:00Z',null), ('Surf's Up! Joker's Under!','97151','1966-12-28T00:00:00Z',null), ('I'll Be a Mummy's Uncle!','97091','1966-09-28T00:00:00Z',null), ('The Purr-Fect Crime','97091','1966-09-28T00:00:00Z',null), ('Tut's Case Is Shut','97091','1966-09-28T00:00:00Z',null), ('The Devil's Fingers','17031','1967-10-05T00:00:00Z',null); single-quote characters are used both as field delimiters and as apostrophes. So that the text can be inserted into a MySQL database, the apostrophes must be escaped (\') (Maybe some other characters as well.) I wonder if I can use a Regular Expression to do the escaping. For example, the text: ('Surf's Up! Joker's Under!','97151','1966-12-28T00:00:00Z',null), should be changed to: ('Surf\'s Up! Joker\'s Under!','97151','1966-12-28T00:00:00Z',null), Now, I *could* try to think of every possible letter or letter combination that might follow an apostrophe: 's 't 're etc. but I might miss some and upon encountering the missed character possibility, the text would not be properly escaped. So, I'm wondering, in RegEx, is there a way to specify change ' to \' in all instances EXCEPT where adjacent to a comma or parentheses? That is, I know that I need not escape the single-quote characters in these situations: (' ',' ', In those instances, the single-quote is a field delimiter and needed. All other instances are indeed apostrophes and need to be escaped. Can RegEx specify that? -- 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>