Hello Philippe, I'm afraid you need to write your own version of Proper$() that handles capitals after hyphens, plus has rules for "mid-words" like "de", "des", etc. I think I know have a few dozens word(s) in our function which handles places names all over the world.
Regards, Warren Vick Europa Technologies Ltd. http://www.europa-tech.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of "Solomon Côté, Philippe" Sent: 18 January 2006 20:33 To: [email protected] Subject: [MI-L] Reformatting character field Hi, I would like to reformat city names that are capitalized such as: SAINT-GEORGES-DE-CACOUNA into a proper format such as: Saint-Georges-de-Cacouna. When using the function Proper$ in an update statement, I get: Saint-georges-de-cacouna, which is not good to me. I tried using the MapInfo's Search and Replace tool for adding a space character after each "-", but this tool seems to only find the first appearance of "-" and I get this result : SAINT- GEORGES-DE-CACOUNA If I could have SAINT- GEORGES- DE- CACOUNA, I would be able to use the Proper$ function effectively. Does anyone know a tool or a function I could use to solve this problem? Thanks a lot. Kind regards, __________________________________ Philippe Solomon Côté MSc Geography Consultant [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> KOREM inc. www.korem.com <http://www.korem.com/> MapInfo Québec, opéré par KOREM inc. www.mapinfo.qc.ca <http://www.mapinfo.qc.ca/> __________________________________ 680, boul. Charest Est, bureau 120 Québec (Québec) G1K 3J4 Canada Tél. : (418) 647-1555 Téléc. : (418) 647-1666 Sans frais : 1 888 440-1MAP Localisation : Québec <http://www.mapanswer.com/07_localisation/LocalisationDemoNav.jsp?profile=ca nada&userlinearunit=km&civicNumber=680&street=charest+est&city=quebec&code=G 1K+3J4&province=qc> Montréal <http://www.mapanswer.com/07_localisation/LocalisationDemoNav.jsp?profile=ca nada&userlinearunit=km&civicNumber=1010&street=Sherbrooke+Ouest&city=Montr%2 5E9al&code=H3A+2R7+&province=qc> __________________________________ _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
