View Single Post
  #1   Report Post  
top00001 top00001 is offline
Junior Member
 
Posts: 1
Default 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!