I have a big list of parts with prefixes and suffixes to be stripped so they can be compared to another list. How would I use the Replace() function in a query to do that? Ex:
HX01 AH154704 E returns AH154704
AX01 19M7805 -- returns 19M7805
JL01 DE20999 C_242828 returns DE20999
Removes everything before first space and after last space. Would a nested Replace function work? How would that look?