tmajor99
asked on
Regular Expression to Extract Numbers and Fractions
I need a regular expression that will extract numbers and "/", ".".
Data Example: Results:
---------------------- -----------
3.66 3.66
1-1/34 1-3/4
N/A [null]
Test 3.55 3.55
5 5
Data Example: Results:
---------------------- -----------
3.66 3.66
1-1/34 1-3/4
N/A [null]
Test 3.55 3.55
5 5
Is it a typo that 1-1/34 becomes 1-3/4?
Subodh Tiwari (Neeraj); your not catching the plain text record of "N/A"
by adding a NULL to your expression results.
by adding a NULL to your expression results.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
\d+[\.-]?(\d+)?(\/\d+)?