Problems Exporting Line Breaks (Carriage Returns)

[ronpalmer2000]

I am building an export file in a single field using "Paste Literal" and "Paste Results." When I export the text information the line breaks are changed and appear as squares.

My Hex reader show that Filemaker Export has changed the line breaks to 0B when I need them to remain 0D 0A.

I can copy and paste the data to MS-Notepad - the line breaks are OK = 0D 0A

If I export in Filemaker - the line breaks are changed to 0B

Any Ideas how I can fix or override this problem.

export.txt

[BertBoye]

You will need to get a plug-in to fix this problem. Try troi or www.wmotion.com

[cjaeger]

you could also write a script wich copies evey line of your field to a record in another database and export as tab-delimited file.

Or use Dave McKees free file-plugin (search for protolight at www.filemaker.com/plugins).

or use the file attachment. copy your field using the setfield() skript step into "input_text" and press the "export" button ...

the_exporter.zip

[ronpalmer2000]

I tired your FM program and it works. However I need to do it directly in my solution if possible. Can you answer a couple of questions please.

1. Regarding the Mckees plug-in: Will it work when the solution is bound?

2. I write in v4.3 and convert to v5.3 then bind in v5.3. This sounds screwy, but I cannot program my solution once it is converted to v5 (it will crash), however once bound the program runs fine. I think I will need to install the plug in in v4 and v5. Do you agree or what would you suggest.

3. If I need some advise, can I call you directly. If so please send by e-mail to [email protected]

Thank you very much for your help.

[DanBrill]

Hi,

I've been having the same problem. I have a text field that I want to export as raw html and javascript. None of the carriage returns were coming out right. I don't want to use plugins as this will be a widely-distribued runtime solution when I'm done, and I don't want to drive up the costs.

I went with the solution of writing each line to a record in a file, then exporting that as tab-dlimited text, as was suggested. It is a pain to get set up because you need to script each line of the html using "set field", but it works fine once it is done.

I'd consider this more of a work-around than a solution, but I guess it is viable. Anyone else have a cleaner method?

Dan

[ronpalmer2000]

EXCELLENT >>>>

I am able to create a Text export file with line breaks from a single field.

I copied and incorporated the sample attachment you sent and it works great.

Thanks for your help.

Ron

[ronpalmer2000]

Filemaker uses line breaks to separate records when exporting.

Here is an solution that was sent to me by cjager that I incorporated into my solution and it works perfectly.

Start the related file with a script step, it then takes the text date and creates a separate record for each line and exports it in as *.txt - you should choose the tab export option. After exporting all the files created are deleted.

I named mine export.txt

Anyway you will see how it works.

Ron with thanks to cjager

cjaeger-solution.zip

[cjaeger]

I tired your FM program and it works. However I need to do it directly in my solution if possible. Can you answer a couple of questions please.

1. Regarding the Mckees plug-in: Will it work when the solution is bound?

2. I write in v4.3 and convert to v5.3 then bind in v5.3. This sounds screwy, but I cannot program my solution once it is converted to v5 (it will crash), however once bound the program runs fine. I think I will need to install the plug in in v4 and v5. Do you agree or what would you suggest.

3. If I need some advise, can I call you directly. If so please send by e-mail to [email protected]

Thank you very much for your help.

1 - have used the plugin in bound solutions no problem. Only drawback: no MacOS X version.

2 - you probably have both FileMaker 4 and 5 installed on the same machine. On the Mac, this is no problem, but on certain windows installations, there seems to be a conflict with some dlls installed bey each Filemaker versions. try to reinstall both versions, but in nonstandard locations (one in c:ProgramsFileMaker, the other in C:ProgramsFM5).

3. use private mail feature in this forum to contact me ....

[cjaeger]

Hi,

I've been having the same problem. I have a text field that I want to export as raw html and javascript. None of the carriage returns were coming out right. I don't want to use plugins as this will be a widely-distribued runtime solution when I'm done, and I don't want to drive up the costs.

I went with the solution of writing each line to a record in a file, then exporting that as tab-dlimited text, as was suggested. It is a pain to get set up because you need to script each line of the html using "set field", but it works fine once it is done.

I'd consider this more of a work-around than a solution, but I guess it is viable. Anyone else have a cleaner method?

Dan

in most cases, HTML does not need the line breaks. Try replace(export_field,"q|";"").

This -might- break your javascript code, but maybe not.

try replacing the "q||" with "r" or "n" in the script section