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 the WecCompanion external functions to 'scrub' my data. The characters that are giving you trouble are 'HIGH ASCII' as opposed to 'LOW ASCII' you want for the web. In the database that I used this solution in I was exporting articles that had all kinds of High Ascii so I used the Web - ToHTML function 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 have all low asciiThis may not be the exact solution for you, but it may give you a little more 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 the WecCompanion external functions to 'scrub' my data. The characters that are giving you trouble are 'HIGH ASCII' as opposed to 'LOW ASCII' you want for the web. In the database that I used this solution in I was exporting articles that had all kinds of High Ascii so I used the Web - ToHTML function 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 have all low asciiThis may not be the exact solution for you, but it may give you a little more 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:
Some Questions (1997)
MacActivity and PCS (1997)
japanese characters (1997)
WebTen and WebCat (1997)
test (2002)
Re[2]: 2nd WebCatalog2 Feature Request (1996)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
[WebDNA] Win 10 FastCGI not running (2019)
Kaaaaahhhhhhhnnnnnnn! (1997)
MATH PROBLEM (1997)
WML (2000)
POST (1997)
[isfile] ? (1997)
Cookie Crumble (1998)
Grep question [parsing variables] problem (2003)
Remove from list server (1997)
Image editing in browser (2005)
Physical Security for WebCatalog Directories (1997)
Searching with a form (2000)
writefile - continued (1997)