How can i capture a specific column of data with .Net regex when some columns may be empty?
<p>I am currently capturing data with .net version of regex (Using Expresso), and I have some code that works for a lot of the columns, but not in some. I believe the problem is that one of the beginning columns is empty in some cases:</p>

<pre><code>A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T
USER 1  USER 2  USER 3  USER 4  USER 5  General General General General M.O.L.E.(r) M.O.L.E.(r) Oven    Oven    Oven AMB    Oven AMB    Oven AMB
one 14  Zone 14 Zone 14 Zone 14 Zone 14 Zone 14 Zone 15 Zone 15 Zone 15 Zone 15 Zone 15 Zone 15 Zone 15 Zone 16 Zone 16 Zone 16 Zone 16 Zone 16 Zone 16
All All All All All All All All All All All All All All
Pass (Overnrider) NJH 12/7/2015                 SMG20-27527 (OvenRider) 12/07/2015  07:59:16    OR_FCT_ENTRY_000561 34.0    4.863   15  101.17  24.4    23.9
Pass (Rework) NJH 11/25/2015                    SMG20-27641 (Rework)    11/25/2015  11:46:43    OR_FCT_ENTRY_000560 31.0    4.863   15  100.60  21.7    21.1
Passed (Rework Mole) RH 11/17/2015                  SMG20-27641 (Rework)    11/17/2015  18:35:48    OR_FCT_ENTRY_000558 33.0    4.893   15  100.60  23.3
Pass (Overnrider) NJH 12/7/2015                 SMG20-27527 (OvenRider) 12/07/2015  07:59:16    OR_FCT_ENTRY_000561 34.0    4.863   15  101.17  24.4    23.9
Pass (Rework) NJH 11/25/2015                    SMG20-27641 (Rework)    11/25/2015  11:46:43    OR_FCT_ENTRY_000560 31.0    4.863   15  100.60  21.7    21.1
Passed (Rework Mole) RH 11/17/2015                  SMG20-27641 (Rework)    11/17/2015  18:35:48    OR_FCT_ENTRY_000558 33.0    4.893   15  100.60  23.3
</code></pre>

<p>the regex i am currently using is:</p>

<pre><code>^(?:([^\s\n]+)\s+){13}
</code></pre>

<p>and the result is:</p>

<pre><code>101.17
100.6
15
100.6
4.893
</code></pre>

<p>how can i ensure that the data i am capturing is always in the 100.XX row like below(Row H)?</p>

<pre><code>101.17
100.6
101.7
100.6
100.6
</code></pre>

<p>FYI this is pulled from excel into a notepad doc...</p>