Black diamond with white question mark in imported text.
I have imported text from an Excel spreadsheet that was the result of an export of data from our Open Text Teams DAM (using Crystal Reports I think). TEAMS is running on an Oracle database running in Windows Server.
Unfortunately, I'm getting some format errors. For example, an apostrophe in the word "Journal's" puts a black diamond with a question mark where the apostrophe is when viewing in Filemaker Pro. But when I copy that and paste it here, it comes out as: Journals.
Any idea what's going on?