I'm trying to grab BaseItemCode
from the following phrase:
FOREIGN KEY (`BaseItemCode`) REFERENCES `BaseItems`
This is what I currently have, but I don't know how to exclude the characters '`', '(', and ')'
(?<=FOREIGN KEY)\s+\K(\(`[A-Za-z0-9]+`\))
It grabs (`BaseItemCode`)
As per Marty's comment, this gave me:
(?<=FOREIGN KEY)\s+\K\(`([A-Za-z0-9]+)`\)
Which retrieves 'BaseItemCode' in group 2.
Ah! I got one more step ahead, the following grabs exactly what I need:
(?<=FOREIGN KEY \(`)[A-Za-z0-9]+(?=`\))