I have outputs of vehicles of a client that detail the trim level of the car.
in this case luxury business/med is in luxury business/media as luxury business/media is in luxury business/media/cherry
i want to be able to find luxury business/media/cherry and remove the other two.
not sure how to do that or if its even possible
of course i would know the current row words in the string so maybe i could build up a new string as the recordset is already sorted.
i would be doing this in vba in access