return a value of specific text within a sentence
Is there a function for: If a column contains certain text/sentence, return the value of the specific text?
examples:
A1: 961-San Francisco Giants 1 -25 962-Arizona Diamondbacks
A2: 963-Los Angeles Dodgers 1 PK 964-San Diego Padres
A3: 966-New York Yankees 1 L 965-Baltimore Orioles
A4: 974-Minnesota Twins 1 +5 973-Chicago White Sox
I only want to get:
A6: 1 -25
A7: 1 PK
A8: 1 L
A9: 1 +5
thanks in advance!
|