Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Filemaker > Substitute for ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 8005 of 8177
Post > Topic >>

Substitute for UNICODE characters, especially quotes

by William Maslin <CATmaslin@[EMAIL PROTECTED] > Apr 24, 2008 at 07:29 PM

I have a Filemaker Pro solution that im****ts 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.
 




 5 Posts in Topic:
Substitute for UNICODE characters, especially quotes
William Maslin <CATmas  2008-04-24 19:29:56 
Re: Substitute for UNICODE characters, especially quotes
Helpful Harry <helpful  2008-04-25 15:09:36 
Re: Substitute for UNICODE characters, especially quotes
William Maslin <CATmas  2008-04-25 10:10:23 
Re: Substitute for UNICODE characters, especially quotes
Jens Teich <spamtrap@[  2008-04-25 17:59:28 
Re: Substitute for UNICODE characters, especially quotes
William Maslin <CATmas  2008-04-25 11:18:31 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 2:47:23 CDT 2008.