Then you have to copy/paste special and remove the "formula" from the new column. When you've got all your fields sorted, delete the original, unformatted columns. Then you can copy/paste your text into indesign. You might want to keep your text in the default format for a moment (columns separated by a tab, rows ending with a hard return).
Javascript indesign data merge number of records plus#
If you want to be able to take advantage of this, you can do a find/replace for hard returns, and replace them with a hard return PLUS a "end nested style" special character, or some other specific and unusual non-printing character that you can use to trigger a style change. Then you need to replace your tabs with either soft or hard returns, depending on your data and your preference. Then you'll end up with something that looks like:Īt the end of each entry, you should have a hidden character. Now you can use nested styles to format each entry, or even "next style" rules with paragraph styles if you've used hard returns in place of your original tabs. If you've got 10 entries, it doesn't really make sense to go to all this effort. If you've got 10,000, you can't really afford to do it any other way. The data merge function in indesign doesn't make "next record" merges like word does, but instead merges to fields within fixed text boxes, so one frame = one data merge result. when doing mailing labels in word, there is a field called "next record" which then calls in the next piece of information. The "next record" field is a vital field which indesign doesn't have and i'd like… but that doesn't answer your question. i can see four ways of doing what you want to do:ġ) do a mail merge in word and use the "catalog" feature and do the merge in word. format the word file appropriately using stylesheets, and once the merge is made, save the file and close it.
THEN, place the file in indesign and then change the imported stylesheets into something which resembles more like what you want.Ģ) use indesign's data merge but make sure that multiple record layout is selected in the first dialog box when creating merged document and that when previewing the records, the records appear to be in one column (even though they are still in separate text frames). merge the document, and in the new document, select all the text frames in the page and then run the MergeTextframes_ID.jsx script which can be found at ….-indesign/. this will have to be done page by page and then rethreaded each page, but it's a workaroundģ) if the data in the datamerge is a csv, convert the csv to xml.
if the csv is small (less than 100K) there is a converter online where the contents of the csv is copied into the converter. The next step is complicated and needs some knowledge of XML.
0 kommentar(er)
