Re: Filemaker Pro and [convertchars]
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 29610
interpreted = N
texte = Tim- One solution I came up with (on a more elaborate site) was to use theWecCompanion external functions to 'scrub' my data. The characters that aregiving you trouble are 'HIGH ASCII' as opposed to 'LOW ASCII' you want forthe web. In the database that I used this solution in I was exportingarticles that had all kinds of High Ascii so I used the Web - ToHTMLfunction in a separate field that would be a calculation like so:article_field='text entered by user'web_article_field=External (Web-ToHTML, article_field)then I would only export the 'web_article_field' with it's 'scrubbed' data.Note: and ampersand (&) is converted to & but your database will haveall low asciiThis may not be the exact solution for you, but it may give you a littlemore perspective on how FMP deals with it's data---------->From: John Butler
>To: (WebCatalog Talk)>Subject: Re: Filemaker Pro and [convertchars]>Date: Fri, Mar 24, 2000, 4:41 PM>> what about simply zapping gremlins in BBedit?>> Timothy W. Killian wrote:>>> Hi All:>>>> I have just read through the archives regarding Filemaker Pro and>> [convertchars] issues. And, I didn't see this question asked/answered>> specifically.>>>> 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. Now, I am>> aware that I can (and do) use [convertchars] to change these>> characters...but this seems like a tedious way to accomplish this. This>> means that I have to add the [convertchars] tag everywhere that I call to a>> field or record that has been exported from FMPro. Tedious.>>>> Is there no other solution? Some way to convert the entire database each>> time I export from FMPRO? If I have to dump FMPro, what is a better program>> to use? (mac-compatible)...>>>> Any suggestions would be appreciated...and then of course, there is always>> the Excel issue with adding quotation marks!>>>> Timothy W. Killian>> --------------------------->> wb: http://www.eventure.com>> ph: 206.559.2200>> --------------------------->>>> ------------------------------------------------------------->> 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> >>> -------------------------------------------------------------> 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 -------------------------------------------------------------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:
Tim- One solution I came up with (on a more elaborate site) was to use theWecCompanion external functions to 'scrub' my data. The characters that aregiving you trouble are 'HIGH ASCII' as opposed to 'LOW ASCII' you want forthe web. In the database that I used this solution in I was exportingarticles that had all kinds of High Ascii so I used the Web - ToHTMLfunction in a separate field that would be a calculation like so:article_field='text entered by user'web_article_field=External (Web-ToHTML, article_field)then I would only export the 'web_article_field' with it's 'scrubbed' data.Note: and ampersand (&) is converted to & but your database will haveall low asciiThis may not be the exact solution for you, but it may give you a littlemore perspective on how FMP deals with it's data---------->From: John Butler >To: (WebCatalog Talk)>Subject: Re: Filemaker Pro and [convertchars]>Date: Fri, Mar 24, 2000, 4:41 PM>> what about simply zapping gremlins in BBedit?>> Timothy W. Killian wrote:>>> Hi All:>>>> I have just read through the archives regarding Filemaker Pro and>> [convertchars] issues. And, I didn't see this question asked/answered>> specifically.>>>> 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. Now, I am>> aware that I can (and do) use [convertchars] to change these>> characters...but this seems like a tedious way to accomplish this. This>> means that I have to add the [convertchars] tag everywhere that I call to a>> field or record that has been exported from FMPro. Tedious.>>>> Is there no other solution? Some way to convert the entire database each>> time I export from FMPRO? If I have to dump FMPro, what is a better program>> to use? (mac-compatible)...>>>> Any suggestions would be appreciated...and then of course, there is always>> the Excel issue with adding quotation marks!>>>> Timothy W. Killian>> --------------------------->> wb: http://www.eventure.com>> ph: 206.559.2200>> --------------------------->>>> ------------------------------------------------------------->> 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> >>> -------------------------------------------------------------> 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 -------------------------------------------------------------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
Eric Ridgley
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:
Help with Shipping Costs (1997)
Multiple SSL Keys (1998)
page redirect in webDNA (1997)
[ShowCart] and GET vs. POST (1997)
Time limit to WebDNA solution (2001)
remotely add + sign (1997)
[OT] Weird Characters (2004)
Shipping formula problem (1997)
Newbie problem blah blah blah (1997)
Multiple catalog databases and showcart (1997)
RE: too many nested [xxx] (1997)
Putting a page between checkout and invoice (1999)
Server Jumping and Web-networking (2000)
[MATH] and Dates (1998)
Sample Tearoom Search Error (1997)
Dubble Sku's in a Database (1999)
Cumulative Shipping charge calculations - your help please. (1997)
WebCat2 - storing unformatted date data? (1997)
RE: E-mailer error codes (1997)
For those of you not on the WebCatalog Beta... (1997)