<div>
^\d*<br />
<br />
<a href="https://regex101.com/r/tHktl8/1" rel="ugc">https://regex101.com/r/tHk<wbr />tl8/1</a><br />
^ asserts position at start of the string<br />
\d matches a digit (equal to [0-9])<br />
* Quantifier — Matches between zero and unlimited times, as many times as possible, giving back as needed (greedy)<br />
Global pattern flags<br />
g modifier: global. All matches (don't return after first match)<br />
m modifier: multi line. Causes ^ and $ to match the begin/end of each line (not only begin/end of string)
</div>


^\d*

https://regex101.com/r/tHktl8/1 [https://regex101.com/r/tHktl8/1]
^ asserts position at start of the string
\d matches a digit (equal to [0-9])
* Quantifier — Matches between zero and unlimited times, as many times as possible, giving back as needed (greedy)
Global pattern flags
g modifier: global. All matches (don't return after first match)
m modifier: multi line. Causes ^ and $ to match the begin/end of each line (not only begin/end of string)

<div>
Thank you, great solution! &nbsp;Sometimes you forget the easier way.
</div>


Thank you, great solution!  Sometimes you forget the easier way.

<div>
<div class="content wysiwyg-content">
MS ACCESS 2010<br />
I have a table with a field called CodeLineTxt. &nbsp;That needs to be pasred into fields LineNbr and LineTxt.<br />
<br />
Using a query and RegEX how can I Do this?<br />
<br />
I need to get the numeric values for data that looks like this:<br />
<br />
10090 &nbsp;If something &gt;&nbsp;10 then<br />
10091 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SET something = 40<br />
10092 &nbsp;End if<br />
<br />
If want just<br />
10090<br />
10091<br />
10092<br />
<br />
The numeric does not always have a length of five. &nbsp;Any numeric value in the remainder of the string is to be ignored.
</div>
</div>


MS ACCESS 2010
I have a table with a field called CodeLineTxt.  That needs to be pasred into fields LineNbr and LineTxt.

Using a query and RegEX how can I Do this?

I need to get the numeric values for data that looks like this:

10090  If something > 10 then
10091                 SET something = 40
10092  End if

If want just
10090
10091
10092

The numeric does not always have a length of five.  Any numeric value in the remainder of the string is to be ignored.

What would be the RegEx pattern in an Access query to return the numeric values until the first alpha?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

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.