Newbies Michael Pazurik Posted October 9, 2003 Newbies Share Posted October 9, 2003 I have several thousand records in my FM db which are created from "cut and paste" methods in various fonts and sizes. I am looking for a style sheet which converts my data as formed (and added to each day) for xml EXPORT to replace "bad characters" then be read by server which has SQL (windows) environment. The "bad characters" are four; the apostrophe, the start quote (NOT using smart quotes), the end quote and the smart quote (both start and end are same). I am told it will take only two lines added to a stylesheet. Interested in finding developer who sells that stylesheet but prefer I test it first to see if it works. Link to comment Share on other sites More sharing options...
cjaeger Posted October 15, 2003 Share Posted October 15, 2003 Hi Michael, since my FM2MySQL styleshhet is open source & totally free, I gather you change it yourself. No need to pay for it. You can use the stylesheet unaltered if you use a Filemaker calculation Substitute(Substitute(field,""","""")"'","') ( escape all the other illigal characters with a as well). Or you can use the attached improved FM2MySQL Stylesheet. FMP2Mysql_new.txt Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7522 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now