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=canada&userlinearunit=km&civicNumber=680&street=charest+est&city=quebec&code=G1K+3J4&province=qc> Montréal <http://www.mapanswer.com/07_localisation/LocalisationDemoNav.jsp?profile=canada&userlinearunit=km&civicNumber=1010&street=Sherbrooke+Ouest&city=Montr%25E9al&code=H3A+2R7+&province=qc> __________________________________ _______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l