Conforming / formatting pasted info into a field

On 12/29/2008 20:00:39 Buckbuck wrote:

Hello

> When I paste a block of nformation from a source into FM it carries the
> original formatting. Is there a way to direct filemaker to convert all
> pasted information to the field's own formatting. In my case my backgound
> colour is black and I want all info to appear white when pasted. I though
> perhapd 'field/control' 'behaviour' would do this but it doesn't. Are
> there any options?

> Thanks Matthew

Hi Matthew,

Since FileMaker 9 you can "fix" this directly, without any further "programming".

After you paste in formatted content, do "Undo" (Command-Z on a Mac) and the formatting will be removed, leaving only the unformatted "data".

I found this out by accident, I don't know if it is even mentioned in the manual.

If you check the Edit menu directly after pasting (again on a Mac, don't know on a PC), you will see the undo menu option listed as "Undo formatting". If you select this option, the undo menu option will change to "Undo paste", and a redo menu option will be added "Redo formatting".

Apparently the paste process is cut into 2 pieces, first pasting in the data, and secondly applying the formatting, thereby making it possible to remove the formatting as decribed.


If you have a database with formatting already in the fields, you will have make a script (or a calculation field) to remove this formatting.
In FileMaker there are now several functions available to aid in removing all or part of any stored formatting, although I am not sure exaclty in which FileMaker version these functions appeared in first.

Go to the online help and type in "format remove"...

In FileMaker version 9 there are:

TextColorRemove
TextFontRemove
TextFormatRemove
TextSizeRemove
TextStyleRemove

Hans Besjes
 >> Stay informed about: Conforming / formatting pasted info into a field 

On Dec 29, 11:00 am, Buckbuck wrote:
> FM 8.5 Adv
>
> Hello
>
> When I paste a block of nformation from a source into FM it carries
> the original formatting. Is there a way to direct filemaker to convert
> all pasted information to the field's own formatting. In my case my
> backgound colour is black and I want all info to appear white when
> pasted. I though perhapd 'field/control' 'behaviour' would do this but
> it doesn't. Are there any options?
>
> Thanks
> Matthew

Hi Matthew
I have a script that looks up Postal Codes that are then pasted into a
field. Their text format is inconsistent with mine.

Here is a solution that works on my Mac.
Go to Define > Database > Fields

Select the field you want to reformat itself automatically

Auto-Enter > Calculated value

And use this argument

TextFormatRemove ( YourField )

Danielle
 >> Stay informed about: Conforming / formatting pasted info into a field 

Buckbuck wrote:

> Is there a way to direct filemaker to convert
> all pasted information to the field's own formatting.

If you can arrange for the formatting with a calculation using the text
format functions (depending on your version), you can put in an
auto-enter calculation which uses the field itself.

I use such a caclulation in order to get rid of any text format that
comes with the clipboard's contents.
--
http://clk.ch
 >> Stay informed about: Conforming / formatting pasted info into a field