• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 364
  • Last Modified:

how to use Regex when using find and replace in VS2010

I have a database query which contains am.u###ad_type as a column name. I want to replace with UPPER(am.ad_type). I need to remove u### and make it upper.
Is it possible in Regular expression while doing find and replace in files.
0
Niyas
Asked:
Niyas
  • 2
1 Solution
 
käµfm³d 👽Commented:
Try this (with "Use Regular Expression" checked):

Find
am\.u\#\#\#ad_type

Open in new window


Replace
UPPER(am.ad_type)

Open in new window

0
 
NiyasAuthor Commented:
Excellent
0
 
käµfm³d 👽Commented:
Glad to help  : )
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now