Hello, @jay-alph.
You can do as @Tom-Hartland has suggested, to convert a Pipe Separated Values (PSV) text file, to a Comma Separated Values (CSV) file. However, if your file has any commas in any of the values, you'll not get what you desire.
Numbers has the ability to import PSV files, directly. (I do it rather often, since US Federal Government files often use PSV.)
Simply open the text file into Numbers.
Numbers will, initially, misinterpret the file, defaulting to Comma or Tab or space delimiters.
Don't Edit the File in Numbers!
When you first load the file, there will be an "imported" message that will show up, for a short time. If it goes away before you had the chance to click on "Adjust Settings", don't worry!
Click anywhere in the Table, open the Format->Table control (if it's not already open). Scroll to the bottom, and you should see a button to "Adjust Import Settings".
Within the "Import Settings", deselect all "Tab", Comma, etc. settings, and type a "pipe" character (|) into the "Custom Delimiter" choice.
Then, simply click the "Update Table" button to have the file reread.
No fuss, no muss!
(It also works for other file formats, as I'm sure you'll notice.)
