I use a number of apps and programs that export, and very often import, data as .csv’s. I desperately need a simple and efficient process for finding commas (“,”) and spaces (” “) and replacing them with what I have always called “paragraph marks” “¶” – I’ve just learned these are called PILCROWs.
I think I’ve learned that in the Apple world blank spaces, tabs, etc are called hidden characters. I wiould also very much like to be able to find and replace “special characters” e.g. EM dashes, copyright icons.
I really like the Notes app, but am getting the feeling that doing large find and replace operations using hidden and special characters might be stretching the app’s abilities. I’ve been using TextEdit but it too seems out of its depth.
I am hoping to avoid using MS Word as I really don’t think I need THAT big of a hammer to crack this nut. In the windows world all of the hidden and special characters could be recognized, found and inserted using their ANSI codes and variations thereof.
PS – I am a BIG fan of MacMost. I joyfully contribute monthly through Patreon. Thank you.
I want to export a spreadsheet or database as a CSV, open the CSV in a “text editor” and then quickly remove all of the delineating commas replacing them most commonly with a comma-space combination (e.g. “####,####” becomes “####, ####”) but maybe “#### — ####” (that’s an EM dash).