Hi, I've tried to search the forum without luck, so I'm hoping someone can help me out...
I have a group of folders named according to the following structure:
Lastname,Firstname,Date-of-Birth,RecordID
For example, "Mouse,Mickey,1950-12-31,98765"
I want to remove the Date-of-Birth (ie the string between the 2nd and 3rd comma) from the folder name, leaving the preceeding and succeeding commas, such that the example above would become:
"Mouse,Mickey,,98765" (with two commas after Firstname).
So far, the closest I have tried is
Match: (?:([^,]*),){3}
Replace: \1
However, this does the exact opposite of what I want (it removes everything other than the Date-of-Birth).
I appreciate any help!
Chris