more examples of the variables

--
Don Guillett
SalesAid Software

"laralea" wrote in message
...
For example:

I need this...
/USA/NORTH CAROLINA/MOORESBORO/CLIFFSIDE STEAM STATION, MOORESB/CLIFFSIDE
#5
SHOP-WAREHOUSE/001/0141/

to look like this...
/USA/NORTH CAROLINA/MOORESBORO/CLIFFSIDE STEAM STATION, MOORESB/

Is there code that will do this? Also, there are 56,000 records and the
data
baries slight in the different records.