Re: Filemaker Pro and [convertchars]

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 29592
interpreted = N
texte = on 03/24/00 2:42 PM, Timothy W. Killian at evlist@eventure.com wrote:> I use FMPRO v. 4 to build news databases. Of course, when I export the > tab-delimited file and upload as a database, I get bad characters.I swear by FMP4 and use it for a lot of things that have nothing to do with WC.I suspect that bad characters you're referring to are caused by curly quotes. Make sure the FMP Document prefs are set to not use them.When you export from FMP, it creates a SimpleText document and pastes the data into it. SimpleText converts all quotes and apostrophes into curly ones, even if they were straight in FMP. That's what causes my bad character problem. Since I store my WC database info in a BBEdit doc, I copy the info from the SimpleText doc into it and use the Replace All command to convert the curly quotes and apostrophes into non-curly ones.I'm sure this could be automated with AppleScript, but it's really not a chore to do it manually. I'm also sure the [convertchars] feature of WC will work, but I've never tried it.Glenn ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Associated Messages, from the most recent to the oldest:

    
  1. Re: Filemaker Pro and [convertchars] (Joseph D'Andrea 2000)
  2. Re: Filemaker Pro and [convertchars] (Eric Ridgley 2000)
  3. Re: Filemaker Pro and [convertchars] (John Davies 2000)
  4. Re: Filemaker Pro and [convertchars] (Glenn Busbin 2000)
  5. Re: Filemaker Pro and [convertchars] (John Butler 2000)
  6. Re: Filemaker Pro and [convertchars] (Kenneth Grome 2000)
  7. Filemaker Pro and [convertchars] (Timothy W. Killian 2000)
on 03/24/00 2:42 PM, Timothy W. Killian at evlist@eventure.com wrote:> I use FMPRO v. 4 to build news databases. Of course, when I export the > tab-delimited file and upload as a database, I get bad characters.I swear by FMP4 and use it for a lot of things that have nothing to do with WC.I suspect that bad characters you're referring to are caused by curly quotes. Make sure the FMP Document prefs are set to not use them.When you export from FMP, it creates a SimpleText document and pastes the data into it. SimpleText converts all quotes and apostrophes into curly ones, even if they were straight in FMP. That's what causes my bad character problem. Since I store my WC database info in a BBEdit doc, I copy the info from the SimpleText doc into it and use the Replace All command to convert the curly quotes and apostrophes into non-curly ones.I'm sure this could be automated with AppleScript, but it's really not a chore to do it manually. I'm also sure the [convertchars] feature of WC will work, but I've never tried it.Glenn ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Glenn Busbin

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Emailer setup (1997) [WebDNA] TCPCONNECT & Timeout (2015) Big Databases (1997) OT: Euros to Dollars (2008) I try hard to think positively (1998) Q: old cart serial problem (2000) wo search help (1999) RE:ShowIf & HideIf Question? (1998) Setting up the server (1997) [orderfile Orders/[cart]] (2000) [ShowNext] feature in 2.0 (1997) WebCat Contest Please Clarify (1998) random in arizona (2003) minimalist shopping cart. (1997) Major Security Hole (1998) shipCost not working v2.1b4 (1997) encrypt (2000) Moving Files (2000) Re[3]: 2nd WebCatalog2 Feature Request (1996) [format] (1998)