Hi - Wondering if someone might help with this. I've got some data in Access and using the SQL view to write my query.
I've got a column with data parsed by semicolons. I am trying to extract out any string between semicolons that meet certain criteria. There is no pattern to the data at all (it is a bunch of paths that vary).
Example Data of the column
I'm looking to pull the full string between the semicolons for dude2. The problem is dude2 could be anywhere in the column.