I have a database of contact information and as the data grows, more and more of it is cut and pasted from emails, spreadsheets etc. Unfortunately a lot of the fonts/sizes/colors of text are also embedded in the text that is getting pasted into the fields. Is there a way to impose standard font/size/color on the text in the field?

I think the thing would be to build a little script that would allow something like this:

Replace Field Contents(textformatremove(current_field))

This way any field could have the formatting removed.

I am not that clear about how to make the replace work on the current field if any one has a suggestion on that I would appreciate it.

You might find this recent tread helpful. I show how to set up a Auto Enter Calculation, which is good for your future pastes,

Link

To change the existing fields formatting, you can either use the Replace from the Menu, or use a script.

Go to Record/Request/Page

[ First ]

Loop

Set Field [ Text; TextFormatRemove (Text ) ]

Go to Record/Request/Page

[ Next; Exit after last ]

End Loop

Note, you would need a separate Set Field for each of the fields involved.

You could also make this generic, and then change the found set for the Current Active Field, by using the Set Variable Script step

Go to Record/Request/Page

[ First ]

Loop

Set Variable [ $CurrentField; Value:Get ( ActiveFieldContents ) ]

Set Field [ TextFormatRemove ( $CurrentField ) ]

Go to Record/Request/Page

[ Next; Exit after last ]

End Loop

HTH

Lee

[color:red]Note:

Be sure to back up your files, or use a copy of them, as you can not UNDO this action.

Edited March 27, 200817 yr by Guest