Exporting fields separated by carriage returns

[Marcel1]

Hi,

I am trying to export found records to a text file with fields separated by standard carriage returns instead of tabs. I am having two problems.

1) I can't seem to get the carriage returns in. I tried creating a global text field, setting this equal to "¶" and then exporting with my other export fields, but when I open the output file in BBedit, I see that it has inserted a "¿" instead of a line break. I also tried copying a BBedit line break, and pasting this into the specify calculation window, but this results in field entries separated by tabs and an empty space, but no line break.

2) I can't get rid of the tabs.

Anyone have any thoughts?

(Accidentally posted this in PDFs forum as well. Sorry for the duplication)

[comment]

See here.

[Marcel1]

Thanks, your two-word response has lead me on a journey into the strange new (for me) world of applescripting. Think I have my solution. I have attached my script below, in case anyone is interested.

Marcel

********************

-- applescript to replace tabs in text with using BBedit

tell application "BBEdit"

activate

open file "HD OS X:Users:marcel:Desktop:DBoutput.tab"

replace "t" using "r" searching in text 1 of text document 1 options {search mode:literal, starting at top:true, wrap around:false, backwards:false, case sensitive:false, match words:false, extend selection:false}

set properties of text document 1 to {line breaks:Unix}

save text document 1

close active document of window 1

end tell

[Lee Smith]

The "Two Word Response" was a link to a similar discussion, did you click on it?

Lee

[Marcel1]

Yes, thanks very much!

Marcel