Substitute for UNICODE characters, especially quotes

I have a Filemaker Pro solution that imports data from an Oracle
database and reformats the information. It works great with one
exception. When the information is entered into the Oracle DB, it is
linked somehow with Microsoft word presumably because of Oracle's
primitive text capabilities. In other words, when the transcriptionist
clicks into the Oracle field to enter data, Word opens up and she types
into it. Closing the Word window shoots the data into Oracle.

I've been using Filemaker 6 and the issue is that the fancy quotes that
Word generates are seen as question marks by FMP 6. Today I installed
Filemaker 8 (which has been sitting on my shelf since I bought it!) and
converted my solution.

FMP 8 sees the quotes as boxes. Now I know that this can be solved with
the substitute function, but the FMP 8 help file and the Filemaker Inc
Knowledge Base are completely unhelpful with regard to how to embed
Unicode into the Substitute function. The goal is to convert whatever
Oracle is using to plain or fancy quotes that Filemaker can display.

Or perhaps it's not possible to embed Unicode into a FMP calculation.
I'd like to avoid the copy and paste method (of oddball characters)
since I have a hard time getting it to work on XP. The last time I had
to do something like this it was replacing linefeeds with soft returns.
I never could get it working with XP. I had to do it on the Mac (with
the help of Tex-Edit Plus) and then copy the calculation and paste it
into the calculation field dialog in XP. It seems to me that it would
be much easier to simply use embedded Unicode.

Thanks.
.

Relevant Pages

  • Re: Substitute for UNICODE characters, especially quotes
    ... When the information is entered into the Oracle DB, ... I've been using Filemaker 6 and the issue is that the fancy quotes that ... Word generates are seen as question marks by FMP 6. ... Or perhaps it's not possible to embed Unicode into a FMP calculation. ...
    (comp.databases.filemaker)
  • Re: loosing records and fields...
    ... views of some aspects of FileMaker handling characteristics. ... operations at the user' workstation level. ... I think it's even well described in the FMP ... on each workstation of the network. ...
    (comp.databases.filemaker)
  • Re: loosing records and fields...
    ... I will add a note that it is not "impossible" to corrupt a FileMaker file, ... but the corruption usually results from the situation where the person who ... I think it's even well described in the FMP ... on each workstation of the network. ...
    (comp.databases.filemaker)
  • Re: decoder ring for a former Access user?
    ... script steps, similar to saving quieries. ... I don't think your question about using GTRR to create subforms quite makes ... (such as it is in Filemaker anyway), deal mostly with the technical aspects ... The FMP manuals I've ...
    (comp.databases.filemaker)
  • Re: decoder ring for a former Access user?
    ... I have a lot of sympathy for developers coming from the SQL world, ... script steps, similar to saving quieries. ... (such as it is in Filemaker anyway), deal mostly with the technical aspects ... The FMP manuals I've ...
    (comp.databases.filemaker)