I used to do this with text funnels and the option-7 ¶ character back in the day. Now, I understand with Unix, I would have to search & replace Line Feeds (rather than carriage returns). But, of course, I’m stuck.
Here is a song list - single record in a single field:
We Are The Champions3:30
All My Loving2:15
Last Train to Clarksville3:03
I want to essentially strip away non-alphabetic characters…and replace the line feeds with a comma+space so that I end up with:
We Are The Champions, All My Loving, Last Train to Clarksville
Can anyone point me to a function, or a way to achieve this?