<div>
Hi.,<br />
<br />
pls try<br />
<br />
[^\d\.]+<br />
to find non num<br />
or <br />
[\d\.]+<br />
to find num<br />
Regards
</div>


Hi.,

pls try

[^\d\.]+
to find non num
or
[\d\.]+
to find num
Regards

<div>
<div class="content wysiwyg-content">
Should be simple. &nbsp;Just need a Reg Expression that would find non-numeric data in a string. &nbsp;<br />
<br />
For example<br />
<br />
Column A<br />
129.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -&gt; Valid. &nbsp;Decimal is OK<br />
ABC &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&gt; Invalid &nbsp;<br />
A23 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;--&gt; Invalid <br />
34 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; --&gt; Valid <br />
9/22 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; --&gt; Invalid because of Slash <br />
12&amp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; --&gt; Invalid because of &amp;<br />
300-AB &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; --&gt; Invalid because of DASH and Alpha Chars
</div>
</div>


Should be simple.  Just need a Reg Expression that would find non-numeric data in a string.  

For example

Column A
129.00                 -> Valid.  Decimal is OK
ABC                      -> Invalid  
A23                      --> Invalid 
34                         --> Valid 
9/22                     --> Invalid because of Slash 
12&3                   --> Invalid because of &
300-AB               --> Invalid because of DASH and Alpha Chars

Regular Express - FInding non-numeric data in strings

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.