Hi, I'm trying to comment some statements from a database sql dump.

I have som data like this:

--

--
-- Role Membership
--

EXEC sp_addrolemember 'aspnet_ChangeNotification_ReceiveNotificationsOnlyAccess', 'User'
GO

EXEC sp_addrolemember 'aspnet_ChangeNotification_ReceiveNotificationsOnlyAccess', 'User'
GO

--
-- Definition for user  :
--

So I get this: .*?--\n-- Role Membership\n--\n(.*?) selecting the first block

I try to selec the  end with this: .*?--\n-- Role Membership\n--\n(.*?)\n--\n but it doesn't work.

 What am I doing wrong ?

palpu:

...

I try to selec the  end with this: .*?--\n-- Role Membership\n--\n(.*?)\n--\n but it doesn't work.

 What am I doing wrong ?

There are two new lines: so it's not --\n-- Role Membership\n--\n(.*?)\n but --\n-- Role Membership\n--\n\n(.*?)\n

Also, if you want the . (dot) to match new lines as well, you need to tell your regex engine that: consult the API docs for your regex-tool/language/library, or tell us what tool/language/library you're using.

I'm using Ruby, and i use /m switch for multiline.

Here is my expression : http://www.rubular.com/regexes/1053

So, with your tip I manage to get what I want, but, how can I select al the content I want, "--"  being the limit, like in the link, but without having that last "--" in the match ?

Thank you.

palpu:

I'm using Ruby, and i use /m switch for multiline.

Here is my expression : http://www.rubular.com/regexes/1053

So, with your tip I manage to get what I want, but, how can I select al the content I want, "--"  being the limit, like in the link, but without having that last "--" in the match ?

 

Thank you.

 

Note that multi-line and dot-all are two different things. Dot-all is usually depicted with a 's' flag.

Could you post what you're trying to extract from the example from your original post? That is still a bit unclear to me.

Thanks.

Don't bother, I got it.

Thank you !!!