Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 7869 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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

Posted

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.

Posted

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

Posted

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

Posted

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

Posted

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 ....

Posted

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

This topic is 7869 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.