1 person found this helpful
I don't think your csv is corrupt, but I do think there is a problem with how it is built.
Any paragraph returns within a cell will cause InDesign to see the start of new Record.
The places where you have listings like
94 pts Wine Advocate
90 pts Wine Enthusiast
90 puts Wine Spectator
with a return after each within the same cell, it throws the whole thing off. Put some kind of placeholder symbol in the spreadsheet to indicate the returns, and then do find-and-replace to get the returns into the InDesign document later.
I wish that was the case. The "94 pts Wine Advocate" portion is its own data ( <<Proscore>> ) and is only separated by a space in the InDesign template. In the csv, there are no paragraph returns within any of the cells. I'm mainly concerned with the consistency of the information within the cells being inserted or replacing other data placeholders. It's strange because I've been duplicating the same csv and switching around the information for the last 5 projects and they've all been fine, except for this current one. If anyone has ANY direction on what I should do, please please help!
I'm starting to wonder, is it a cache or a memory related issue?
Here is the csv in word form.
After further investigation, SJRiegel You are absolutely correct. The invisible Carriage Returns are near impossible to spot. A bit of advice, when using Google Sheets, you can:
... (for more options)
search for "\r\n|\n|\r"
Search using Reg expressions
Replace with whatever.
YT link below on how it's done.