Is this formatting applied to the field while in layout mode or to the text itself while in Browse mode?
I haven't tested this, but believe you can get the formatting to appear in your exported file if you use the second option. You can use text formatting functions from within a replace field contents calculation to apply a format to the text in all the fields in your table or found set all in one step if you need to.
I'm doing both. I apply a bold to the field itself in Layout mode then modify the text and add italics to a portion of the text within Browse mode.
The issue is that I *don't* want to apply the same formatting to the whole field just portions of it, I just want to retain and export the changes I make within Browse mode.
For example, "Carole King's Tapestry is considered one of the greatest albums of all time. Which of these songs was not on it?"
You didn't say what's the format of your ultimate destination. Most of the export formats are plain text, and have no room for style information. The exception is Excel - but Filemaker discards styles when exporting to Excel anyway.
However, you can add a calculation field = GetAsCSS ( YourField ) and export it instead.
So I've added a calculation field for each field that I want to retain style formatting, however if Filemaker discards styles when exporting to Excel which format do I export as? I tried Excel and it did not work.
You can export to practically any format. The calculation using GetAsCSS returns information about the formatting - not formatted text. The real question here is what is your purpose?
Ah, got it....
I need to export the date from Filemaker and import into a SQL database that is powering a Facebook application.
So I need to transfer data that was created and edited by an editorial team using Filemaker to our software engineer. He in turn needs to render this data intact within a Facebook app written in .Net with the data fed in from a back-end SQL database.
Well, then the GetAsCSS() route sounds like the best-suited solution - since the ultimate destination is HTML anyway.
Ok, I created a new layout with calculation fields derived from the original text fields. However, I am still unable to export the data with all the CSS info.
The data appears properly in each calculation field with the appropriate <span style=> tags, however I'm not clear as to how to export this into one document that contains all the CSS info for the contents of my found set.
Any instructions as to how to export this as a CSS file?
This is somewhat of a related question
I'm not the most experienced Filemaker user. I'm a medical lexicographer who for years was trying to use Quark Xpress to manage my data which is now about 300 Mb; stupid, but there you have it. I am slowly inputting the information into filemaker
Here's the question: How do I export from filemaker into the DTP environment so that the file retains all the font changes and is recognised in DTP as different fonts.
Like the other guy, it would also be ideal if the text formatting was retained in the export
I am not sure where you're stuck with this. Once you have the calculation field/s, you can export them instead of the styled text field/s. You don't really need a special layout for this - exported fields don't have to be on any layout. As I said, you can export in any text format - it would probably be best to coordinate the exact format with your recipient.
You can also export as HTML (using XML export with a custom XSLT stylesheet). This will render all styling when the output is viewed in a browser - but I doubt your recipient will thank you for that if they need to parse the data into a database.
I am afraid I cannot answer that without knowing what your DTP application will accept. From the very little I know about this, I think you would need to convert the CSS tags to your own, then export the result - perhaps as XML?