(I have seen a similar problem addressed/resolved at EE)
In the process of syncing my Google contacts and my Apple contacts (aka iCloud contacts) hundreds of blank lines have been inserted with individual's notes.
What sounds like merely an antithetical concern, is growing into a serious problem. These blank lines are so copious that navigating my contacts brings my iPad and iPhone to a crawl. Often I can't even use the contacts without a 15-second lag from when I try to scroll or edit.
Within the notes section, I keep very important lists for each contact. There are nearly 1000 such contacts. Recently, blank spaces, like return paragraphs have begun appearing within each client's list. Removing these by hand is not an option -- too slow and jeopardizes good content.
I have read that this has to do with a difference in coding language (I think). Something do with CR LF (Windows), LF (Unix) and CR (Macintosh) line break types.
Anyway, it has ruined my address book.
My ultimate goals:
Remove blank lines with Notes in iPad / iPhone / Mac
Have a functional address book on my iOS devices with lists in the notes section that I may continue to expand.
I have little time, but a lot of resources, including, but not limited to:
- Apple Mail
- iCloud (web-based)
- iPhone running 8
- iPad (3rd gen running iOS 8)
- MS Office and Office 365 (in case using Excel or Word would help)
- a good working knowledge of Mac and PC and all items above
Please help. This is kicking my behind.
NOTE: I have already . . . .
. . . exported the contacts from gmail, imported into Excel, did a fair job of find/replace "newlines" (\N) with nothing. That seemed to help, but I messed up the mapping when I brought it back into the address book.
. . . vcf to excel ... worked a little but inconsistent results, likely due to the complex spreadsheet it created that was unmanageable.
. . . tried several 3rd-party iOS and MacOS and W7 apps/programs for converting / "cleaning" address books. No luck. Often just messed up my mapping.
. . . manually deleting hundreds of thousands of new lines -- causing insanity.
I am confident you experts can walk me step by step through resolving this. I'm a good student with Apple Certification. So, this should be a cake walk. Start the music.