Does Microsoft require quotes for csv file imports?
Microsoft Excel can use different types of delimiters, like comma, double quotes, tab, and many other ASCII characters, like even spaces. For the carriage return, Excel often easily makes use of CRLF - I use it all the time. In fact, most Windows text editors use CRLF for line ending/ carriage returns.
Note: there are different types of file encoding for text files. One of the most common in text files on Windows computers is ANSI; a less common encoding type for text files is UTF-8.
I opened
@pdhall54 file "p25rx_talkgroup_backup_2020-11-04.tgp" in a recent version of Excel. Unfortunately, the binary characters made the file appear mostly unreadable/ unusable in Excel. Binary characters are typically seen as one of many non-ASCII characters or symbols, as seen in this cropped screenshot of what it looks like in Excel:
If possible, I'd strongly suggest removing the binary characters, so TGP files can be easily edited, cleaned up, etc with Excel and with most text editors in Windows. There's at least one open source text editor in Windows that can read these TGP files: Notepad++. However, even with Notepad++, binary characters show up as NUL characters - in other words, they cannot be interpreted correctly; the program simply doesn't give an error when showing the file.
Todd, if you'd like someone to review any TGP files for readability etc, look into character and file types for Windows, let me know and I'll be glad to help. If ASCII characters can be used instead of binary, that would alleviate most issues.