Line Break produces a square in FM...???

[angelleye]

I've got an ASP web script that runs updates on some Filemaker records. One of the things it does is includes notes in the Invoice records. It includes line-breaks in the notes to keep it nice and clean and that does work, however, in FM you end up with a little square at the end of each line where my script put in a line break. Is there any way to make this stop happening? It's a little annoying. Any information would be greatly appreciated. If you'd like a look at what I'm talking about you can see an example here: http://www.dealsdirectinc.com/temp/fmNotes.jpg

Thanks!

[John Mark Osborne]

You could use the Substitute function to remove the line breaks.

Substitute(MYTABLE::myfield; "The Line Break Character"; "")

This could be use in an auto-enter calculation or a script.

Or, you can remove the line break character from the ASP script.

[angelleye]

Well, I can't remove the line break from the script because then all of the notes would be all smashed together on that one line. You see how they're nicely broken apart with a date for the notes, and a name, etc? I can't lose that.

Wouldn't using substitute do the same thing? Remove the line-break, thus bring everything together?

[Wim Decorte]

Not sure what language you're using in your ASP page but I'm going to assume it's VBscript.

FM uses chr(13) internally for line breaks, so if you replace vbCrLf in your text with chr(13) before you put the data into FM you'll have your line breaks without the squares.

[angelleye]

You are exactly right and that fixed the problem beautifully. Thanks!

[Wim Decorte]

For those who have no idea what we're talking about here:

FM uses Ascii 13 (CR - carriage return) for returns. Windows uses Ascii 13 + Ascii 10 (carriage return + line feed, hence the vbCrLf). When you put the Windows line break inside a FM field the Ascii 10 shows up as a white square.