Character subsitute - line break code

[DRoberts]

Hi,

I've got a problem with some data coming in with a line break I can't remove.

When viewed using GetAsCSS it gives the following code & # 8232 ; rather than the expected <br> character of standard line breaks.

This is a problem as the record is not parsing in XML so I need a away of removing it in FM.

Has anyone come across this problem and do you know a way of removing this from a text string?

I've attached a single record which I've copied from a much larger database. This problem is popping up randomly across a number of different fields - and is really difficult to spot when simply viewing the records

I can use substitute & # 8232 ; to remove the 
 code within the returned GetAsCSS calculation - but how do I then return this to be a standard text file?

hope someone can help

kind regards

David

[comment]

Try =

Substitute ( YourField ; Char ( 8232 ) ; ¶ )

[DRoberts]

Hi Comment,

this is giving a "?" in the resultant calculation field - I've checked I'm returning the result as text (also tried as number)

But no joy

best wishes

David

[comment]

Can you attach an example file showing the problem?

[DRoberts]

Hi Comment,

I've attached a small sample - one record which has an example of this character.

My current work round is also included where I use GetAsCSS to make the character "visible" then perform a substitution on the CSS version back to plain text.

Many thanks in advance

David

Character Problem.fp7.zip

[comment]

Does this work for you?

CharacterFix.zip

BTW, I'd suggest you explore Filemaker's built-in XML exporting option.

[DRoberts]

Thanks for the fix - I'm not sure why I was getting the question mark result, but this solves my problem (will investigate further no I can see a master at work).

Re: XML exporting - working on this at the moment as I'm getting fed up of hard coding the tag markers

many thanks

David