Hello happy FM hackers

I have a little problem which that I have an address book that is in part culled from the net. When I copy & paste the info into the text field it keeps the web formatting. Does anyone know of a script or how I can make the text field formatting conform to the layout parameters that I initially designed?

Hi

You can do it with "paste Special" or with a script:

copy[select;InField]

paste[select;No style;OutField]

or even with an "auto-enter calculation replaces existing value" and calc:

SerialIncrement ( InField ; "" )

Edited September 23, 200520 yr by Guest

or you can select paste special from edit menu which asks pasting stye (formatted or plain text ... etc)

You can do it with "paste Special"

as I said... ;-)

sorry i did not see it ???

Two more possibilities:

1. Paste holding the Option key down (or Windows equivelant.)

2. Add this auto-entered calc option to the field to always remove any formatting:

Evaluate ( Quote ( field ) )

Oh boo I'm on mac and this function does not exist. I also have 2000 of these entries already.

But is there a script to get rid of the formatting in a doc?

So do a Replace on the existing records using that function.

Sorry? I don't understand. Is this a suggestion of a script or just the find function? Can it apply to all fields?

I see Ender is offline (useful function that). He's given you the formula and method, but perhaps more explanation is needed. Replace is a script step, also an operation in the Records menu. You should read about it in the Help first. Because it is both powerful and dangerous.

It works on the currently active field (where the cursor is), in the current found set. You have to do each relevant field separately.

Use the formula he posted as he said, as an auto-enter by calculation option for the field, with the "Do not replace value" checkbox OFF (in Define Fields). Then simply Replace in the field, by calculation, with itself.

This fixes the text you've got, and ensures that any subsequent pasted text will get formatting stripped upon tabbing out.

Thank you for the explaination. I appreciate. I will digest all the entries carefully before having a crack. Thanks

Hoorah to you all. Thanks for this highly efficient solution.