I'll have to read Winifred's response, but I've been struggling with this
one for ages, both with Quark and InDesign destinations.
My solution, which will only work on a Mac platform, is to use Applescript
to change the characters in the exported file. This means replacing ASCII
character 11 with ASCII character 13.
I get the users to run it when importing the file into ID or Quark, rather
than using 'get text' or 'import'. This is because the actual database users
are on PCs. If your solution is entirely Mac-based, you could make the
script a seamless part of the export routine.
Below is the script I use to clean the text:
tell application "Finder"
try
set my_file to choose file
open for access (my_file) with write permission
copy (read my_file) to the_text
set eof my_file to 0
set the_text to my replace_chars(the_text, ASCII character 11, ASCII
character 13)
write the_text to my_file
close access my_file
on error
close access my_file
end try
end tell
on replace_chars(this_text, search_string, replacement_string)
set item_count to 10
repeat until item_count = 1
set AppleScript's text item delimiters to the search_string
set the item_list to every text item of this_text
set item_count to length of item_list
set AppleScript's text item delimiters to the replacement_string
set this_text to the item_list as string
set AppleScript's text item delimiters to ""
end repeat
return this_text
end replace_chars
tell document 1 of application "Adobe InDesign CS3"
make new text frame at beginning with properties {geometric bounds:{0,
-60, 300, -4}}
place my_file on text frame 1
end tell
On 11/10/09 17:51, "Chad Chelius" <[email protected]> wrote:
> I have a FMP database and I've created a calculation field that
> concatenates multiple fields into one field for export. However I need
> to create carriage returns (hard returns) in specific locations so
> that they appear correctly in the InDesign layout. Does anyone have
> any idea what the character code is for an InDesign hard return?
>
> Chad Chelius
>
> --------------------------------
> Inbound email scanned by Mimecast.
> --------------------------------
>
<BR>
Emma Glaisher
Artworker and Database Development
Fourninety Limited
<BR>
Tel: 0113 238 2447
http://www.fourninety.com/
-----------------------------------------------------------------------------------------------------------------------------------------
Fourninety Limited, a member company of the Media Square plc group. Registered
in England No. 3737606. Registered address Clarence Mill, Clarence Road,
Bollington, Cheshire. SK10 5JZ
Confidentiality Notice: The information in this document and any attachments
are confidential. It is intended only for the use of the named recipient. If
you are not the intended recipient please notify us immediately and delete this
document. The contents on this document must not be disclosed to any other
person nor may any copies be taken. The views of the author may not represent
the views of the Company.
Security Warning: This e-mail has been created in the knowledge that Internet
e-mail is not a 100% secure communications medium. All liability for any claims
arising as a result of using this medium to transmit information by us or to us
is excluded to the extent permitted by law.
-----------------------------------------------------------------------------------------------------------------------------------------
