Assuming the database field (column) is called "xxx", you can label with the following expression:
Left$ (xxx,InStr( InStr( 1,xxx," " )+1,xxx," " )-1) Regards Bo Thomsen GeoConsult I/S Denmark -----Oprindelig meddelelse----- Fra: David Reid [mailto:[EMAIL PROTECTED] Sendt: 18. maj 2004 03:44 Til: 'MapInfo-L' Emne: MI-L Labelling expression help needed Greetings List, I wish to label a map with an expression that would display all characters of a string until a second space is encountered. Example: "Lot 1 in blk 2 of Mapinfo Estates" I need to extract "Lot XX". To return: Lot 5 Lot 34 Etc. Thanks in advance. David Reid --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11802 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11813
