Good morning, I am attempting to update a table, preference is an update qry, by removing the numbers and _ from a table field. I am struggling with trying to remove "_", numeric and alpha at the end. In other words, from the numeric to the end needs to be removed (including the preceding "_". The data is inconsistent and struggling with trying to make this work, Can't do a left or right because of the inconsistency in the data. Any Ideas?
Original:
URDNKRECREM_JMA_11162021
URASNRCRSVC_11162021B
BPIN_NRSVEN_BK_11022021
URASNRCRSVC_11022021_actionable
Modified:
URDNKRECREM_JMA
URASNRCRSVC
BPIN_NRSVEN_BK
URASNRCRSVC
Thank you in advance for your assistance