troubleshooting Question

Visual Studio Replace to Change Delimiters

Avatar of D B
D BFlag for United States of America asked on
Microsoft Visual StudioRegular Expressions
3 Comments2 Solutions6 ViewsLast Modified:

I have code open and want to change string delimiters from single quotes to square brackets using Visual Studio I want to search for the pattern (double quotes are NOT part of the string/pattern):
" AS 'something here'"

and replace it with: 

" AS [something here]"

So basically looking for a single space the word AS, another space, a single quote, a string, another single quote and want to replace the first quote with [ and the second with ]. I want to do this within the search/replace box (Ctrl-H) in VS with regualar expressions selected. I'm a LONG way from being a RegEx expert so looking for some help. Might mention, if not adding a lot of complication to the search string, the space surrounding the AS keyword could be more than one space or could be tab(s). Multiple spaces and/or tab characters can be replaced with just a single space.


TIA

SOLUTION
Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 2 Answers and 3 Comments.
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>

Mike

Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 2 Answers and 3 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004