Export losing text formatting.

[stefanshotton]

I have a calculated text field with text styles added ie. customer name with title format.

I am exporting to a text file that is loosely set up as xml format to be taken into another external program.

However when exporting the title format is lost, is there a way around this?

Edited October 11, 2006 by Guest

[Fitch]

By title format do you mean a calculation: Proper ( text ) ? If you exported that calculation it should work just fine.

But I think you mean the style was added directly to the text via the Format menu. Those changes don't affect the underlying data, so they wont export.

You might be able to work around this using the GetAsCSS function, which returns a result like:

It is  

title 

 case.  

Since you're working with XML that may fit in with what you're already doing.

[stefanshotton]

Title format , sry meant Titlecase

ie TextStyleAdd (Clients::First Name C ; Titlecase

) included in calc text field.

changes stefan shotton to Stefan Shotton

[BobWeaver]

The text formatting functions do not change the actual text in the field. They just add text formatting tags which are stripped off when you do an export or use them in calculations. You can either do as Fitch suggests and export a calculated field with the GetAsCSS, or change your original calculation from:

TextStyleAdd (Clients::First Name C ; Titlecase)

to:

Proper(Clients::First Name C )

The Proper() function physically changes the text itself.