Find replace with Regex adding extra text

Question

I am using a regex within Visual Studio 2005 to turn my SQL statement into a readable string.

I am using the find expression {.*} and the replace expression & "\1 " _.

This should produce results something like: input:

select *
from x

expected

& "select * " _
& "from x " _

The reality is I am getting:

& "select * " _& " "_
& "from x " _& " "_

Have I got my expression wrong?

Ahmad Mageed · Accepted Answer · 2010-10-20 14:50:11Z

1

For your find pattern, use a + instead of a * to ensure at least one character is matched. I think something extra is being picked up with the * approach, perhaps a boundary or line-break despite the documentation.

Try this pattern instead: {.+}

edited Oct 20, 2010 at 14:50

answered Oct 20, 2010 at 14:37

Ahmad Mageed

96.9k20 gold badges170 silver badges177 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

themaninthesuitcase Over a year ago

Perfect. I wonder if the * is treating the line break as a separate match, though this would make the new insert over 2 lines.

Collectives™ on Stack Overflow

Find replace with Regex adding extra text

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related