You will need to use a combination of these two functions: InStr( num , str1 , str2 ) Searches the string str1 starting at character position num, and looks for an occurrence of the string str2. Returns the position where str2 was found, or zero if not found. To start search at beginning, use a num value of one (1).
Mid$( str, num1, num2 ) Returns a portion of the string str starting at character position num1 and extending for num2 characters. -----Original Message----- From: Alan Gunn [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 29, 2005 1:55 PM To: MapInfo-L (E-mail) Subject: MI-L Trim in the middle Hello all, Does anyone know how to take a whitespace character out of the middle of a string? Thanks, Alan --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15851
