Been struggling with this filter, attempting to create a file list for export and further manipulation.
I have datasets that are delimited by " - " (space, hyphen, space). I want to find all the files that include a comma before the first delimiter.
I'll spare you the full file listing, and just show a shortened example of what I get with my regex attempt:
Regex ^(?:.+?),(?:.+?)(?: - )
-----
Bee Gees, The - Staying Alive - BL36-02
Cher - Shoop Shoop Song, The - BL36-09
Cocker, Joe - Up Where We Belong - BL36-05
Cocker, Joe - You Can Leave Your Hat On - BL36-06
Collins, Phil - You'll Be In My Heart - BL36-11
Houston, Whitney - Waiting To Exhale - BL36-08
Jackson, Joe - Is She Really Going Out With Him - BL36-01
John, Elton - Circle Of Life, The - BL36-10
McKee, Maria - Show Me Heaven - BL36-14
Midler, Bette - Rose, The - BL36-03
O'jays, The - Love Train - BL36-15
Richie, Lionel - Endless Love - BL36-07
Streisand, Barbra - Evergreen - BL36-04
Withers, Bill - Ain't No Sunshine - BL36-12
--------
If the regex were doing what I wish, this file:
Cher - Shoop Shoop Song, The - BL36-09
Would not appear, as there is no comma before the first delimiter.
All clues welcome - and bonus points for a regex that would also filter out files for which "The", "A", or "An" follows the comma before the first delimiter.