AnsweredAssumed Answered

Special characters breaks Copy pasting of CF, corrupt XML DDR

Question asked by Vincent_L on Jul 19, 2010
Latest reply on Jul 30, 2010 by TSGal


Special characters breaks Copy pasting of CF, corrupt XML DDR


FileMaker Pro


FMPa 11v2

Operating system version

Mac OS X 10.6.4

Description of the issue

Hi, My XML DDR export are not ok, you can't open them.

I tracked Down the problem to a CF I wrote meant to get rid of invisible special characters (the one below ascii 30). In the CF those characters have ben cut and pasted.

Fors instance
LeTexte=Substitute ( LeTexte ; "     " ; " " );

Now with FM 11v2 adv., When I create a XML DDR Export, the xml has problem. You can't parse it because those special characters were not converted to xml friendly characters.

I think it will be also the case in calculation or elsewhere (but didn't proved it).

Moreover this CF can't be copy pasted. Only the CF name gets copied, not it's content. That's because FMP internally use XML to copy paste and it seems its' XML engine forgets to converts some characters to their XML friendly code.

I've created a file with that CF called "NettoieTexte", export it's DDR as an XML file and try to open the generated XML, or try to copy pasted the CF : all will fail.

That's terrible because that means we can't use DDR analysis tools anymore (if in your code you deal with such characters).

Steps to reproduce the problem

Create a CF where there's characters whose ascii code is below 30
generate DDR XML export
Try to open that XML file with any XML reader

Expected result

Should open without problem

Actual result

XML malformed so no XML reader can read it

Exact text of any error message(s) that appear


Configuration information

Macbook pro i7