Web Developer, specialising in WordPress

Terry Woods

tmajor99

<div>
a comma as the last character of the text possibly followed by spaces<br />
<br />
&nbsp; &nbsp; /, *$/
</div>


a comma as the last character of the text possibly followed by spaces

    /, *$/

<div>
If your regex engine supports typical replacement syntax, these should work:<br />

<pre><code id="code-20-42976816-1">s/\s*,\s*/,/g
s/,$//g</code></pre>
<br />
If your regex engine supports a little more, you could do:<br />

<pre><code id="code-20-42976816-2">s/\s*(?:(,)\s*(?=\S)|,\s*$)/$1/g</code></pre>
</div>


If your regex engine supports typical replacement syntax, these should work:


s/\s*,\s*/,/g
s/,$//g


If your regex engine supports a little more, you could do:


s/\s*(?:(,)\s*(?=\S)|,\s*$)/$1/g

<div>
another short approach since the data does not contain spaces<br />
s/ //g<br />
s/,$//
</div>


another short approach since the data does not contain spaces
s/ //g
s/,$//

<div>
<div class="content wysiwyg-content">
need a regular expression that will check and remove a space before and after a comma and remove the comma if value is null following the comma. &nbsp;<br />
<br />
Data &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Expected Results<br />
------------ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; --------------<br />
CHN, USA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CHN,USA<br />
CHN , USA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CHN,USA<br />
CHN,USA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CHN,USA<br />
CHN, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CHN<br />
CHN , &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CHN<br />
CHN , USA, LBB &nbsp; CHN,USA,LBB
</div>
</div>


need a regular expression that will check and remove a space before and after a comma and remove the comma if value is null following the comma.  

Data                   Expected Results
------------             --------------
CHN, USA             CHN,USA
CHN , USA            CHN,USA
CHN,USA              CHN,USA
CHN,                     CHN
CHN ,                    CHN
CHN , USA, LBB   CHN,USA,LBB

Regular Expression to check for spaces before and after a comma

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.