[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

create a text file from a text field and maintain the carriage returns.

Posted on 2012-09-07
4
Medium Priority
?
564 Views
Last Modified: 2013-04-10
I setup a text field that contins the following. I would liket to export it to a text file and keep the carriage returns. I tried export field content . I tried export in general. I cannot get it to work . thanks
S,856SOPI,
O,3705862,,FL,,0010,CTN25,5,.05,0272
P,,,
I,657274001051,1,,EA
O,3705862,,FL,,0012,CTN25,4,.05,0272
P,,,
I,657274001051,1,,EA
O,3705862,,FL,,0014,CTN25,4,.05,0272
P,,,
I,657274001051,1,,EA
O,3705862,,FL,,0015,CTN25,4,.05,0272
P,,,
I,657274001051,1,,EA
0
Comment
Question by:RALPHQC
  • 2
4 Comments
 
LVL 9

Expert Comment

by:jvaldes
ID: 38379399
The only way I can think off will require post processing on the text file. Since Filemaker exports Carriage returns as ASCII (11) or CTRL (K), you may want to replace CTRL (K)'s with CTRL(M)'s which is a carriage return, with the text editor after export. Since you haven't provided the platform you intend to use the file, I don't know if you need a Line Feed or not , I presume CTRL(M) will take you to the next line in your text editor.
0
 
LVL 2

Expert Comment

by:ozbigben
ID: 38712610
The only way to get the right text encoding is to export the data as XML using a basic XSLT file like:
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
xmlns:fm="http://www.filemaker.com/fmpxmlresult" exclude-result-prefixes="fm" >
	<xsl:output method="html" version="1.0" encoding="utf-8" indent="yes"/>
	<xsl:template match="/">
		<xsl:value-of select="fm:FMPXMLRESULT/fm:RESULTSET/fm:ROW/fm:COL/fm:DATA" disable-output-escaping="yes"/>
	</xsl:template>
</xsl:stylesheet>

Open in new window


If it's just for a single record I usually do this via a script and a secondary table with only one record and a global text field. Using a global text field allows you to set its value from unrelated tables.
0
 

Accepted Solution

by:
RALPHQC earned 0 total points
ID: 39052070
I found a dacon plugin that did the job perfectly.
0
 

Author Closing Comment

by:RALPHQC
ID: 39065149
that's the solution that i used.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question