Hello!
I'm new at this, and hoping to fix what I think was an error I made when importing a list.
I have a large list of radio stations. They represent a variety of formats, signal strength, etc. When I imported, I combined all of that "extra" information into a single field called "Description." At the time, I didn't think I'd need those elements called out individually.
Now, I'd like to be able to pull out the FORMAT information, and create a field that allows me to select stations based on that.
Here's what the description field might look like for one station:
FQ: 1600 PWR: 6000 FORMAT: REL (GOSPEL) SAT: NOTES: DUPE WAS KATZ KMJM SOME CAMPBELL
I'm interested in pulling out everything between FORMAT: and SAT: to create a new field. There are a number of different formats, for example:
REL (GOSPEL)
REL (CC)
CHR
AOR (REL)
N/T (SPORTS)
I'd like to be able to select stations based on Format (for example, those that contain CC or CHR).
Ideas? I'd like to know how many of each I have.