Pulling string between two identical characters
Posted on 2014-11-24
We have a software system that allows users to enter "Production notes", which are then stored in a SQL database.
I have the view 'qryproductionnotes' set up, which displays the 'productionnotes' column, where the notes are stored.
The symbol they're using is "@", so they could, potentially, have something like the following as a record in the 'productionnotes' column:
Part will be in QC for machine inspection by mid morning.BKB 10/6/14 @ W2552-001 sample going to Lab 10/8 and will qualify 002, 003. EDS @
What I'm trying to do is pull ONLY the data between the "@" symbols, so in this case everything "W2552-001" through "EDS".
Here's the caveat:
In some cases, there will be a SINGLE "@" in the string; in the event someone used the symbol for another meaning, like "Part was sent out @ 2:00PM". If there's just a single "@" in the string, we want to ignore it. Same goes for if there's more than 2 "@"s in the string
Hope that makes sense, and hopefully it's not going to be TOO difficult :)
Thanks in advance!