I have a plain text field that I use to store HTML code in.

I usually paste it from Dreamweaver and or sometimes Frontpage.

The thing is that when I paste it into the field it adds couple of characters at the end; couple of rows of what looks like small squares.

I thought it was some add-on from the DM or FP but it is not, I tried it on couple of different computers and with different HTML and it always happens.

Any idea why it is happening or what I could do to fix it?

Try copying to notepad.exe then from there to FileMaker -- if you still get the squares at the end then its not front page or Dreamweaver (could you just check first, then i'll go into possible solutions).

Thanks, you are right. It was DW. Why would it do that?

I tested as follows:

Opened DW and copied the HTML

Opened FM and pasted - the squares showed up

Opened NP and pasted - no squares, selected all and copied again

Pasted into FM and no squares showed up

Any idea why it is happening - takes time to delete squares when doing a lot of records.

No clue, i find it just happens,

I think that dreamweaver plants special chars all over the place so it know's what it's editing... that or when you select to copy the code, you are also copying the actual table structure...

As for a solution, though i'm not sure it will work, Try setting your field to auto enter, replace existing:

Substitute( YourField ; "TheSquareCharHere" ; "" )

Thanks, will try it out - will post when I test it out.

That's good to know especially considering how so much is headed to or already using the web.

I have only seen the squares when pasting text from Generic Cadd(apple) or when printing from it on certain printers. I always assumed it was a font issue. I wonder what the actual culprit is.

Michael

Edited June 23, 200718 yr by Guest

Tried the calculation recommended by Genx - could not do it as when I tried to paste the square char I got "" - no chars in between.

I cannot paste it here as well - I copied it and have the paste option when I right click however when I click on it nothing gets pasted.

Here is the small gif of how it looks.

Can you post an FM file with the content in the text box?

Will do, in an 1 hrs about, office is closing for the weekend, good thing I got remote access, might be even sooner, depending on traffic.

OK., here is the file. I just opened DW and copied the HTML that DW auto generates one you hit new button. I get a lot of squares.

It can be seen on the layout called ProductsDescription.

Please disregard the file, it is my first real db in FM.

A-SYS.zip

I can't tell you if it's the same on a PC, but on my Mac that file ends with 740 ASCII 0 characters, which is a control character; not a good thing to put into FileMaker, IMHO. And I can't seem to Find/Replace it either.

Thanks, the thing is if you saw my file I use the text field to store html description of my item which i copy from DW once I make it. If I need to copy and paste it to notepad and then to FM in order to not get the chars, I'll do it but it just does not seem practical as it creates an extra step.

I think you could put a specimen of the character in a global field, and use that in a calculation to substitute it out. That is assuming it's always the same control character.

... or use a filter in case that character isn't the same:

Filter( yourTextFieldHere ; "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890`~!@#$%^&*()_+=-[];',./{}|:"<>? " )

Thank you., both methods worked.