@kellyyer
So the comma character is a more-common delimiter than yours, but if you replace every comma in the following with your special delimiter, this should work or at least get you started:
Invoke Replace (press ctrl+h).
Find what zone: (?-s)^(?:.+?,){18}(.+?,.+?),.+ <–again replace every comma here!
Replace with zone: \1
Search mode: Regular expression
Action: Press the Replace All button
I encourage you to read about regular expressions, some ways to get started here. Try the above expression in some of the interactive regex sites to see how it works. Perhaps you will end up with a new technique in your data manipulation arsenal.