Globally set a field's font

[Charlie Kilo]

Hello!

My colleague cut and pasted some data into my database. This means that I have some data in my default font, and some in a weird font from the internet.

Is there a way to unify the font across all the records in my database?

[John Mark Osborne]

Yes, you can use the following formula in a Set Field on a single record:

Set Field [MYTABLE::myfield; TextFormatRemove(MYTABLE::myfield)]

If you want to perform the formula on multiple records, use the Replace Field Contents feature.

In case you make a mistake, create a backup before you run the Replace Field Contents script step.

[Charlie Kilo]

Great, thanks John.