Regular Expression C#

Question

0.00/5 (No votes)

See more:

Hi Friends..

i have a string "select Code from table where columnname= nvl(#p_name,columnname)"
here i need to replace #p_name as null.
Expecting output shoulb be like "select Code from table where columnname= nvl(null,columnname)"
it is possible to get that output using Regx.Replace

Posted 16-Aug-13 0:25am

SPASWIN

Updated 16-Aug-13 0:27am

v2

Add a Solution

Comments

[no name] 16-Aug-13 6:29am

"it is possible to get that output using Regx.Replace", yes. Yes it is possible.

SPASWIN 16-Aug-13 6:32am

Sir.
i tried to construct Regx like @"^#.,$"
its not working bcoz its wrong.Could you pls help me to do this

Thomas Daniels 16-Aug-13 6:34am

Do you want to replace all #[here something] or do you just want to replace #p_name with null?

SPASWIN 16-Aug-13 6:38am

yes Sir i need to replace #p_name with null...
but i shldnt hardcode p_name anywhere

Ashutosh Mahto 16-Aug-13 6:40am

#p_name is a constant part of string or there can be a pattern like this? If #p_name is a constant part that you want to replace then you can simply do like -
string str = select Code from table where columnname= nvl(#p_name,columnname)";
str = str.Replace("#p_name","null");

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Thomas Daniels · Accepted Answer · 2013-08-16T00:30:00

Solution 1

Yes, it's possible, try this:

C#

string original = "select Code from table where columnname= nvl(#p_name,columnname)";
string result = Regex.Replace(original, "#(.+)( *),", "null,");

Hope this helps.

Posted 16-Aug-13 0:30am

Thomas Daniels

Updated 16-Aug-13 0:39am

v3

Comments

SPASWIN 16-Aug-13 6:37am

Thank you Sir.
here i should't hardcode p_name because p_name will change dynamically.
Is there anyother way to achive this..

Thomas Daniels 16-Aug-13 6:39am

Yes, there's another way, I updated my answer.

SPASWIN 16-Aug-13 6:40am

Thank you Sir.

Thomas Daniels 16-Aug-13 6:41am

You're welcome!