i need to remove the first couple and last few characters of a string.
for example i need to change:
TR ROBINSON RD @ SS
to
ROBINSON RD or
TL LOMBARDY WAY @ END
to
LOMBARDY WAY
the first characters before the space could be several different
strings, i.e. TL, TR, CROSS etc and same for the last characters in
the string. i.e. @ END, @ LITE, (B4 GAS STA) etc

i had success with replace and substitute if i knew exactly what the
leading and trailing chars were going to be. i can't get either to
accept wildcards however.
with a street number, street name and zip code, a link to google maps
is added to the address
what can i do?