It would appear the simple thing to do is export to a text file, update the
columns in Excel or Access, then dump the stuff back into MI
In Excel, my solution was to use the following formula:
For column A
=If(find("%%d"),A4),A4,"")
Thanks,
Dave
-----Original Message-----
From: David Reid [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 12, 2005 12:39 PM
To: [email protected]
Subject: MI-L Need IF statement to update column
Greetings List,
I've seen references to this before but never seem to find what will apply
to the need at the time.
I know there's no "IF" statement for use in Mapinfo but realize there's a
way around this but I can't seem to find the path :)
<Do this> IF()
IF() <do this> ELSE(<do this>)
I wish to update a column with specific data from another,
Update BEARING with TEMP If "%%d" is found in TEMP ELSE <don't do anything>
%%d is literal, not wild cards "%". This data was converted from a DWG
file.
Thanks,
David Reid
--
Outgoing mail is certified Virus Free
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.13/47 - Release Date: 07/12/2005
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 17117
--
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.13/47 - Release Date: 07/12/2005
--
Outgoing mail is certified Virus Free
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.13/47 - Release Date: 07/12/2005
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 17122
