<div>
Change it where/how? Using Find/Replace in Visual Studio? In C# code? Other?<br />
<br />
In any event, the pattern to match would be:<br />
<br />

<pre><code id="code-20-39912865-1">&lt;meaning&gt;([^&lt;]+)&lt;/meaning&gt;</code></pre>
<br />
...and the replacement would be:<br />
<br />

<pre><code id="code-20-39912865-2">&lt;meaning text=&quot;$1&quot; TextAR=&quot;&quot; /&gt;</code></pre>
<br />
...assuming the utility that you are using to execute the replacement supports $n syntax. You might need to exchange &quot;$1&quot; for &quot;\1&quot; instead:<br />
<br />
i.e.<br />
<br />

<pre><code id="code-20-39912865-3">&lt;meaning text=&quot;\1&quot; TextAR=&quot;&quot; /&gt;</code></pre>
</div>


Change it where/how? Using Find/Replace in Visual Studio? In C# code? Other?

In any event, the pattern to match would be:



<meaning>([^<]+)</meaning>


...and the replacement would be:



<meaning text="$1" TextAR="" />


...assuming the utility that you are using to execute the replacement supports $n syntax. You might need to exchange "$1" for "\1" instead:

i.e.



<meaning text="\1" TextAR="" />

<div>
Thanks for your reply, <br />
I am using c# VS 2013
</div>


Thanks for your reply,
I am using c# VS 2013

<div>
So the replacement is taking place via C# code, using the <a href="http://msdn.microsoft.com/en-us/library/system.text.regularexpressions.regex(v=vs.110).aspx" rel="ugc nofollow">Regex class</a>?
</div>


So the replacement is taking place via C# code, using the Regex class [http://msdn.microsoft.com/en-us/library/system.text.regularexpressions.regex(v=vs.110).aspx]?

<div>
<div class="content wysiwyg-content">
Dear all, <br />
using c# can I change all database rows contains this:<br />

<blockquote>
&lt;meaning&gt;xxxxx&lt;/meaning&gt;
</blockquote>
TO<br />

<blockquote>
&lt;meaning text=&quot;xxxxx&quot; TextAR=&quot;&quot;/&gt;
</blockquote>
<br />
I prefer to use regular expression.<br />
( I just need the regular expression &nbsp;implementation or even MS SQL SP)<br />
Thanks,
</div>
</div>


Dear all, 
using c# can I change all database rows contains this:
<meaning>xxxxx</meaning>
TO
<meaning text="xxxxx" TextAR=""/>

I prefer to use regular expression.
( I just need the regular expression  implementation or even MS SQL SP)
Thanks,

use regular expression to change text

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

A regular expression ("regex") is a sequence of characters that define a search pattern, mainly for use in pattern matching with strings, or string matching, i.e. "find and replace"-like operations. Regular expression processors are found in several search engines, search and replace dialogs of several word processors and text editors, and in the command lines of text processing utilities, such as sed and AWK. Many programming languages provide regular expression capabilities, some built-in, for example Perl, JavaScript, Ruby, AWK, and Tcl, and others via a standard library, for example .NET languages, Java, Python and C++ (since C++11). Most other languages offer regular expressions via a library.

Regular Expressions

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.