Shoguo

Thank you SOOO much. That worked exactly like I wanted it to, now to find all the other fields which have carriage returns!! You have saved me a lot of grief!

I mean, tell it to replace it with something OTHER than a vertical tab. So I can search for say "#####" in InDesign and replace it with a return there. Or can I do that with a vertical tab? All my searches for the vertical tab haven't been very successful, as far as replacing it with something else after it's been exported.

Is there a way to tell Filemaker to replace carriage returns with another character?

I will check out the link. And by formatting I mean, instead of displaying like: It displays like: Which is not as easy to read and doesn't look as nice in the book itself. It's sort of like a reference manual, so being able to find the area needed quickly is what i'm looking for. I would also like to use the merge feature of InDesign, as that's how it has been done in previous years, not sure why we're having issues with it this year.

I have a database table which I import from an external source. The table has 127 fields, some can be blank, and some have only one line of text while 2 or 3 of the fields will have a few paragraphs. I need to export it as a merge file or comma separated to be used in InDesign. My problem occurs when I try to use the exported file in InDesign, it complains that "The data source file you selected either has no records or is not a supported file format. Please fix the file, select a file that contains records, or select a supported file type." I've narrowed it down to the carriage returns and/or line feeds in the 2 or 3 fields that have them. There are roughly 1250 records. All of which will be used by InDesign to put a book together. I need to keep the spaces between paragraphs so that it is more easily read. Is there a way to preserve or change the returns so that they remain, but InDesign can use the file? I read after a quick google search that it might have something to do with Filemaker converting in-field carriage returns to vertical tabs because carriage returns are reserved? All of the work is/will be done on mac's, so it doesn't have to be multiple platforms. Also, if I remove the carriage returns and line feeds, InDesign can use the file just fine, but again, the formatting is stripped away making it hard to read. Any help that can be provided is appreciated. If necessary I can provide examples of the table data(It's various drugs/supplements and their effect on the baby through breastfeeding)