Hello Jocelyn, Try this:
rtrim$(left$(YourField, 2))+mid$(YourField, 4, 2)+"/"+right$(YourField, 4) Assumptions: - The prefix part is one or two letters only. - The gap between the prefix and main body is padded with spaces, not tabs. - The main part of the code starts from character position 4. - The main part of the code is always 7 characters. I'd recommend keeping a copy of the old field just in case there are some cases where the code does not conform to the assumptions above. Also, if the source field is blank, the output will be "/". Regards, Warren Vick Europa Technologies Ltd. http://www.europa-tech.com -----Original Message----- From: Jocelyn O'Byrne [mailto:[EMAIL PROTECTED] Sent: 27 February 2005 07:23 To: [email protected] Subject: MI-L HELP WITH EXPRESSION TO UPDATE COLUMN VALUES Hi Mapinfo Guru's, Was hoping someone may be able to supply me with an expression statement that I can use to update the format and appearance of name attributes in a polygon table. I have many records that require the same change so was hoping to use table>update column and enter the appropriate expression. The change required for values is: E 1500574 would become E15/0574 P 2603033 would become P26/3033 ML 7000751 would become ML70/0751 M 3800431 would become M38/0431 Etc. Thank you all in advance. Hope everyone is having a fantastic weekend!! Kind regards Jocelyn O'Byrne --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15450
