filemaker >> Removing Text Formatting

by David Kelly » Sun, 02 Apr 2006 06:02:56 GMT

In my data entry layout I do not wish to allow or retain user-applied
formatting to data. Haven't figured out a viable way to enforce "plain
text" format, that which I selected when defining the layout, 12 point

What has happened is some data was copy/pasted from email and brought
undesired text formatting with it. MacOS X 10.4.5

Suggestions? FM 7. Also have the 8 upgrade but not installed yet.

filemaker >> Removing Text Formatting

by Helpful Harry » Sun, 02 Apr 2006 06:27:13 GMT

In article < XXXX@XXXXX.COM >,

If it's only a prblem for printouts, then you can create a second
Calculation field,

UnformatedField = FormattedField

and use this new field on the printouts.

In newer versions of FileMaker you can evidently do something similar
using the auto-enter abilities of the same field, but I'm not sure
exactly how.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

filemaker >> Removing Text Formatting

by Michael Paine » Sun, 02 Apr 2006 07:44:17 GMT

See Help for
TextFormatRemove - Text with the formatting reverted to the default text
format for the field.

When browsing records go to Records/Replace field contents/
Replace with calculated result
and enter the expression TextFormatRemove(<fieldname>)
Click on REPLACE to apply this expression to all the records.

Michael Paine

filemaker >> Removing Text Formatting

by RubyTuesday » Mon, 03 Apr 2006 03:40:22 GMT

In article <020420061027130982% XXXX@XXXXX.COM >,

SerialIncrement ( <fieldname> ; "" )


filemaker >> Removing Text Formatting

by David Kelly » Tue, 04 Apr 2006 00:40:56 GMT

In article <442f105a$0$7527$ XXXX@XXXXX.COM >,

Apparently its TextStyleRemove( text ; style ) in FM7.

Followed by TextFont( text ; "Veranda" ; "Roman" ) to remove Monoco.

The above allows me to correct the existing database. Experimenting the
following Auto-Enter Calculated Value formula added to each field
definition filters unwanted formatting. Example shown for field "city":

TextSize( TextFont( TextStyleRemove( city ; AllStyles ); "Veranda" ;
"Roman" ) ; 12 )

Looks as if when the field is set to the font/size which is set in the
Layout, that no font is listed on right-click -> Font while the data is
displayed using the Layout settings. But if data is typed in the same
field without the above Auto-Enter formula, the layout settings of
Veranda 12-point is indicated.

Curious as this suggests the above formula strips formatting information
(rather than set to as-specified) while normal entry applies formatting.
Could be useful for setting format in a layout for printing without
having to copy/modify to another field. This no-format is probably a
fragile thing to depend on.

Its a bit clumsier than I had hoped for, but many thanks to everyone, it
solved my issue.

filemaker >> Removing Text Formatting

by ardpuntjonkeratxs4allpuntnl » Tue, 04 Apr 2006 01:39:38 GMT

To remove formatting whilst entering data, do cmd-option-v rather than
cmd-v. This will paste text as defined in the layout. That works in
earlier versions too.

filemaker >> Removing Text Formatting

by David Kelly » Tue, 04 Apr 2006 05:44:43 GMT

In article < XXXX@XXXXX.COM >,

Silly me. Replied to soon.

What I had before was that most data did not have formatting. So my
layout format applied when displaying data and printing. Print envelope
with different font & size than membership card than report.

Having globally applied the TextSize(TextFont(TextStyleRemove())) filter
to my data ADDED the specified font type and size to the data. Database
file size grew 15%.

Now faced with the need for either more scripts and temporary fields to
reformat for printing, or to export my data, wipe my database, and
re-import without formatting. More web searching turned up this solution
which works:

Do a global replace with evaluate(quote(fieldname)) to truly strip
formatting off text.

Have also added that formula to my Auto-Enter rules for the critical

What would be nicer if I could replace fieldname with
Get(ActiveFieldContents) or Get(ActiveFieldName). Tried both but neither
worked. Would have made things easier to Copy, Paste, Paste, Paste, ...,
when editing my database that I wouldn't have to change the field in
each paste which is subject to error.

filemaker >> Removing Text Formatting

by FP » Tue, 04 Apr 2006 11:20:16 GMT

Assuming your field is called "Name", do the following:
- go to define fields
- select auto enter calculated value with formula
TextFormatRemove ( Name )
- deselect "Do not replace existing value of field if any" checkbox
Any NEWLY entered text will have its formating removed.

To remove the formating from existing records
- find all records
- click into the "Name" field
- select "Replace Field Contents" from the "Records" menu
- enter the formula
TextFormatRemove ( Name )
- repeat with every other field substituting the proper field name in
the above function

Similar Threads

1. interval output format available that removes ambiguity ?

I have the need to output intervals (ages in this case).
PostgreSQL takes great care to handle months correctly (eg
take into account varying months lengths). This is only
possible if either end point or start point of an interval are
known. For post processing some of the ambiguity of what
"2 mons" means would be removed if "61 days" was returned.

Is there a way to tell PostgreSQL to return that type of
interval (eg use weeks, days, hours, minutes, seconds, ...
but not months and perhaps not even years [leap years, etc]) ?
to_char(interval, text) doesn't work as it is applied after
the fact.

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

2. Remove character at end of text string

3. Remove text


I have made a mistake in my set up. When I created my Invoice #
(kp_InvoiceID) I include the text 'Inv' as in Inv 10-00010, an on
creation serial number. I would like to remove the Inv from all the
Invoice serials without loosing the serial number. This would allow me
to search a kp_InvoiceID based value list without having to write Inv
each time. Can you help me?


4. pgsql-server: Remove asymetrical word processing in query and text

5. press - pr: Fixed text of Backup section on press page to remove

6. Copying formatted text

7. default text formatting

I have a stanard database with Name, Address, Phone etc etc and I'm
having the following problem:

People cut and paste text in from their email and the internet, and
that formatted text goes into the fields of the database and doesn't
match the settings for the field.

I tried to insist on specific formatting using the calucated result
field, but then it's permanently formatted that way in every instance
of the text in question.

Is there some calculated result that REMOVES FORMATTING--kind of like
paste unformatted text so that the formatting will merely be the
formatting of the field they are pasting into?


David Averbach

8. Keeping text format