I need to build a regular expression that will take a string and get all the numerics up to an alpha, then cut off everything from the alpha to the end including ending numerics. The numerics up to the alpha can be between 8 and 11 positions. Example:
or it could be
I want all the numerics at the beginning and i dont want any value after the S. The beginning can be anywere from 8 positions to 11 positions. I am doing this in a hospital system that can utilize regular expressions, so i dont want to do a seperate VB program to clean up the data.