Jump to content

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


angelleye
 Share

This topic is 5642 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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!

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5642 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.