Hi David try this update in the mapbasic window (it has to be on one line). It will remove one carriage return evrye time you run it. Update Mytab set MyTxtColm = Left$(MyTxtColm, Instr(1, MyTxtColm, Chr$(10)) - 1 ) & Right$(MyTxtColm, len(MyTxtColm) - Instr(1, MyTxtColm, Chr$(10)) ) Peter "David Eagle" <[EMAIL PROTECTED]> - 2000 06 29 17:06:38 Til: "Dany Bouchard" <[EMAIL PROTECTED]> cc: [EMAIL PROTECTED] (bcc: Peter Laulund/MI/KMS) Vedr�rende: MI Carriage returns, extra! I have a related question...Sorry to intrude Dany, I have a table full of data, one column of which is full of carriage returns, represented by a square symbol. Does anyone know how to delete them, either in MI or in Excel. They are more than an annoyance... Cheers, Dave On 29 Jun 00, at 10:20, Dany Bouchard wrote: This has to be simple ! I am just trying to figure out if a text object textstring (returned by ObjectInfo(obj, OBJ_INFO_TEXTSTRING) has carriage returns. Is there an easy way aside from looping through all characters and checking for carriage returns by converting each character using ASC() ? Thanks in advance ! Salutations. Dany Bouchard DBx Geomatics 38 de l'Orbite Hull, Qu�bec Canada J9A 3C7 T�l�phone/Telephone: 819.743.3870 T�l�copieur/Fax: 819.775.3264 Courrier �lectronique/Email: [EMAIL PROTECTED] Page Web/Web site: http://www.dbxgeomatics.com/home.asp Vitrine technologique SVG / SVG Technology Preview: http://www.dbxgeomatics.com/svg.asp ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
