Replace Using Regular Expressions

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
yerbmeld
Posts: 1
Joined: Wed 05 Jan 2022 15:12

Replace Using Regular Expressions

Post by yerbmeld » Wed 05 Jan 2022 16:16

I am trying to remove lines from the SQL text editor that match the regular expression ^ , ut[01][0-9]\.Description\r\n and I receive the message "The specified text was not found," When I remove the \r\n from the text to find, the line of text will be removed leaving a blank line in the SQL text. It appears the CRLF characters are not recognized in regular expressions. Is this true?

alexa

Re: Replace Using Regular Expressions

Post by alexa » Thu 06 Jan 2022 08:43

We will investigate this issue.

alexa

Re: Replace Using Regular Expressions

Post by alexa » Thu 13 Jan 2022 12:50

We were able to reproduce this issue and will fix it in one of the next product builds.

captainscarlett
Posts: 1
Joined: Fri 21 Oct 2022 11:12

Re: Replace Using Regular Expressions

Post by captainscarlett » Fri 21 Oct 2022 11:16

Hi,

Has this been fixed because I am having a similar problem, I want to remove unwanted blank lines from procedures and triggers and \n is unrecognised.

Also, is there another way to achieve this need please (throughout a db).

Thanks

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: Replace Using Regular Expressions

Post by dzhanhira » Wed 26 Oct 2022 10:37

Hi,

Thanks for asking.

Please, be informed that we keep investigating it, once there is the fix ready, we will inform you.

Post Reply