<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://wiki.tuflow.com/w/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Ari+Craven</id>
	<title>Tuflow - User contributions [en]</title>
	<link rel="self" type="application/atom+xml" href="https://wiki.tuflow.com/w/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Ari+Craven"/>
	<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/Special:Contributions/Ari_Craven"/>
	<updated>2026-04-28T19:11:27Z</updated>
	<subtitle>User contributions</subtitle>
	<generator>MediaWiki 1.43.8</generator>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Hotlinking&amp;diff=2287</id>
		<title>MI Hotlinking</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Hotlinking&amp;diff=2287"/>
		<updated>2011-09-05T22:53:21Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Introduction ==&lt;br /&gt;
The MI hotlinking function can be used to link a external file to objects in a MI table. For example, this is very useful for checking which cross sections are being used for a particular section of channel or to link images of structures or locations. Once a table is hotlinked the user can click on an object and the external file will be opened. &lt;br /&gt;
== Method ==&lt;br /&gt;
Highlight the desired table in the layer control window, then select the &#039;hotlinks options&#039; button at the top of the window as shown below.&lt;br /&gt;
[[File:hotlink_1.png|frame|none]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
This will open the dialogue box as shown below. In the example shown hotlinks have been added to a 1d_tab cross section table. &#039;Filename Expression&#039; is the location of the file and can be set to one of the attribute columns or can be an expression. In this case the &#039;Source&#039; attribute of the 1d_tab table has been used and relative path has been selected. &#039;Activation Mode&#039; refers to whether the user needs to click on the object or the label (or both) to access the linked file. &#039;Alias Expression&#039; is what will appear when the user hovers the mouse cursor over a particular object.&lt;br /&gt;
[[File:hotlink_2.png|frame|none]]&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Hotlinking&amp;diff=2286</id>
		<title>MI Hotlinking</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Hotlinking&amp;diff=2286"/>
		<updated>2011-09-05T22:48:57Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Introduction ==&lt;br /&gt;
Blah blah blah&lt;br /&gt;
== Method ==&lt;br /&gt;
Highlight the desired table in the layer control window, then select the &#039;hotlinks options&#039; button at the top of the window as shown below.&lt;br /&gt;
[[File:hotlink_1.png|frame|none]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
This will open the dialogue box as shown below. In the example shown hotlinks have been added to a 1d_tab cross section table. &#039;Filename Expression&#039; is the location of the file and can be set to one of the attribute columns or can be an expression. In this case the &#039;Source&#039; attribute of the 1d_tab table has been used and relative path has been selected. &#039;Activation Mode&#039; refers to whether the user needs to click on the object or the label (or both) to access the linked file. &#039;Alias Expression&#039; is what will appear when the user hovers the mouse cursor over a particular object.&lt;br /&gt;
[[File:hotlink_2.png|frame|none]]&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=File:Hotlink_2.png&amp;diff=2285</id>
		<title>File:Hotlink 2.png</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=File:Hotlink_2.png&amp;diff=2285"/>
		<updated>2011-09-05T22:35:51Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=File:Hotlink_1.png&amp;diff=2284</id>
		<title>File:Hotlink 1.png</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=File:Hotlink_1.png&amp;diff=2284"/>
		<updated>2011-09-05T22:31:07Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: uploaded a new version of &amp;amp;quot;File:Hotlink 1.png&amp;amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=File:Hotlink_1.png&amp;diff=2283</id>
		<title>File:Hotlink 1.png</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=File:Hotlink_1.png&amp;diff=2283"/>
		<updated>2011-09-05T22:31:02Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: uploaded a new version of &amp;amp;quot;File:Hotlink 1.png&amp;amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Using_String_Functions&amp;diff=2282</id>
		<title>MI Using String Functions</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Using_String_Functions&amp;diff=2282"/>
		<updated>2011-09-05T11:06:37Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;MapInfo has a range of string (text) functions that offer the user excellent query and text manipulation opportunities.  The string functions from the MapInfo help are documented below, and an example of using a few of these string functions for selecting and manipulating a GIS dataset is presented.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
{| align=&amp;quot;center&amp;quot; class=&amp;quot;wikitable&amp;quot;&lt;br /&gt;
&lt;br /&gt;
! Function&lt;br /&gt;
! width=75% | Description&lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;Chr$&#039;&#039;&#039;( num ) || Returns a character that corresponds to a character code (e.g. Chr$(65) returns the string &amp;quot;A&amp;quot;).&lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;DeformatNumber$&#039;&#039;&#039;( str ) || Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators. &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;Format$&#039;&#039;&#039;( num , str ) || Returns a string representing a formatted number. Example: Format$( 12345.678, &amp;quot;$,#.##&amp;quot;) returns &amp;quot;$12,345.68&amp;quot;. &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;FormatNumber$&#039;&#039;&#039;( num ) || Returns a string representing a formatted number. This function is simpler to use than Format$, but it gives you less control over formatting (e.g. you always get thousands separators). &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;InStr&#039;&#039;&#039;( 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). &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;LCase$&#039;&#039;&#039;( str ) || Returns a lowercase version of the string str. &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;Left$&#039;&#039;&#039;( str , num ) || Returns the first num characters of the string str. &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;Len&#039;&#039;&#039;( str ) || Returns the number of characters in a string. &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;LTrim$&#039;&#039;&#039;( str ) || Trims any spaces from the start of str and returns result. &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;Mid$&#039;&#039;&#039;( str, num1, num2 ) || Returns a portion of the string str starting at character position num1 and extending for num2 characters. &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;Proper$&#039;&#039;&#039;( str ) || Returns a string with proper capitalization (first letter of each word capitalized). &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;Right$&#039;&#039;&#039;( str , num ) || Returns the last num characters of the string str. &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;RTrim$&#039;&#039;&#039;( str ) || Trims any spaces from the end of str and returns result. &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;Str$&#039;&#039;&#039;( expr ) || Returns a string approximation of an expression. &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;UCase$&#039;&#039;&#039;( str ) || Returns an uppercase (all capitalized) version of str. &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;Val&#039;&#039;&#039;( str ) || Returns the numeric value of the string; for example, Val(&amp;quot;18&amp;quot;) returns the number 18. &lt;br /&gt;
|-&lt;br /&gt;
|}&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Using_String_Functions&amp;diff=2281</id>
		<title>MI Using String Functions</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Using_String_Functions&amp;diff=2281"/>
		<updated>2011-09-05T10:58:50Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;MapInfo has a range of string (text) functions that offer the user excellent query and text manipulation opportunities.  The string functions from the MapInfo help are documented below, and an example of using a few of these string functions for selecting and manipulating a GIS dataset is presented.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
{| align=&amp;quot;center&amp;quot; class=&amp;quot;wikitable&amp;quot;&lt;br /&gt;
&lt;br /&gt;
! Function&lt;br /&gt;
! width=75% | Description&lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;Chr$&#039;&#039;&#039;( num ) || Returns a character that corresponds to a character code (e.g. Chr$(65) returns the string &amp;quot;A&amp;quot;).&lt;br /&gt;
|-&lt;br /&gt;
|align=&amp;quot;center&amp;quot;|&#039;&#039;&#039;DeformatNumber$&#039;&#039;&#039;( str ) || Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators. &lt;br /&gt;
|-&lt;br /&gt;
|align=&amp;quot;center&amp;quot;|&#039;&#039;&#039;Format$&#039;&#039;&#039;( num , str ) || Returns a string representing a formatted number. Example: Format$( 12345.678, &amp;quot;$,#.##&amp;quot;) returns &amp;quot;$12,345.68&amp;quot;. &lt;br /&gt;
|-&lt;br /&gt;
|align=&amp;quot;center&amp;quot;|&#039;&#039;&#039;FormatNumber$&#039;&#039;&#039;( num ) || Returns a string representing a formatted number. This function is simpler to use than Format$, but it gives you less control over formatting (e.g. you always get thousands separators). &lt;br /&gt;
|-&lt;br /&gt;
|align=&amp;quot;center&amp;quot;|&#039;&#039;&#039;InStr&#039;&#039;&#039;( 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). &lt;br /&gt;
|}&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Using_String_Functions&amp;diff=2280</id>
		<title>MI Using String Functions</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Using_String_Functions&amp;diff=2280"/>
		<updated>2011-09-05T10:58:21Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;MapInfo has a range of string (text) functions that offer the user excellent query and text manipulation opportunities.  The string functions from the MapInfo help are documented below, and an example of using a few of these string functions for selecting and manipulating a GIS dataset is presented.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
{| align=&amp;quot;center&amp;quot; class=&amp;quot;wikitable&amp;quot;&lt;br /&gt;
&lt;br /&gt;
! Function&lt;br /&gt;
! width=75% | Description&lt;br /&gt;
|-&lt;br /&gt;
|align=&amp;quot;center&amp;quot;|&#039;&#039;&#039;Chr$&#039;&#039;&#039;( num ) || Returns a character that corresponds to a character code (e.g. Chr$(65) returns the string &amp;quot;A&amp;quot;).&lt;br /&gt;
|-&lt;br /&gt;
|align=&amp;quot;center&amp;quot;|&#039;&#039;&#039;DeformatNumber$&#039;&#039;&#039;( str ) || Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators. &lt;br /&gt;
|-&lt;br /&gt;
|align=&amp;quot;center&amp;quot;|&#039;&#039;&#039;Format$&#039;&#039;&#039;( num , str ) || Returns a string representing a formatted number. Example: Format$( 12345.678, &amp;quot;$,#.##&amp;quot;) returns &amp;quot;$12,345.68&amp;quot;. &lt;br /&gt;
|-&lt;br /&gt;
|align=&amp;quot;center&amp;quot;|&#039;&#039;&#039;FormatNumber$&#039;&#039;&#039;( num ) || Returns a string representing a formatted number. This function is simpler to use than Format$, but it gives you less control over formatting (e.g. you always get thousands separators). &lt;br /&gt;
|-&lt;br /&gt;
|align=&amp;quot;center&amp;quot;|&#039;&#039;&#039;InStr&#039;&#039;&#039;( 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). &lt;br /&gt;
|}&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Using_String_Functions&amp;diff=2279</id>
		<title>MI Using String Functions</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Using_String_Functions&amp;diff=2279"/>
		<updated>2011-09-05T10:57:33Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;MapInfo has a range of string (text) functions that offer the user excellent query and text manipulation opportunities.  The string functions from the MapInfo help are documented below, and an example of using a few of these string functions for selecting and manipulating a GIS dataset is presented.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
{| align=&amp;quot;center&amp;quot; class=&amp;quot;wikitable&amp;quot;&lt;br /&gt;
&lt;br /&gt;
! Function&lt;br /&gt;
! width=50% | Description&lt;br /&gt;
|-&lt;br /&gt;
|align=&amp;quot;center&amp;quot;|&#039;&#039;&#039;Chr$&#039;&#039;&#039;( num ) || Returns a character that corresponds to a character code (e.g. Chr$(65) returns the string &amp;quot;A&amp;quot;).&lt;br /&gt;
|-&lt;br /&gt;
|align=&amp;quot;center&amp;quot;|&#039;&#039;&#039;DeformatNumber$&#039;&#039;&#039;( str ) || Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators. &lt;br /&gt;
|-&lt;br /&gt;
|align=&amp;quot;center&amp;quot;|&#039;&#039;&#039;Format$&#039;&#039;&#039;( num , str ) || Returns a string representing a formatted number. Example: Format$( 12345.678, &amp;quot;$,#.##&amp;quot;) returns &amp;quot;$12,345.68&amp;quot;. &lt;br /&gt;
|-&lt;br /&gt;
|align=&amp;quot;center&amp;quot;|&#039;&#039;&#039;FormatNumber$&#039;&#039;&#039;( num ) || Returns a string representing a formatted number. This function is simpler to use than Format$, but it gives you less control over formatting (e.g. you always get thousands separators). &lt;br /&gt;
|-&lt;br /&gt;
|align=&amp;quot;center&amp;quot;|&#039;&#039;&#039;InStr&#039;&#039;&#039;( 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). &lt;br /&gt;
|}&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Using_String_Functions&amp;diff=2278</id>
		<title>MI Using String Functions</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Using_String_Functions&amp;diff=2278"/>
		<updated>2011-09-05T10:56:33Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;MapInfo has a range of string (text) functions that offer the user excellent query and text manipulation opportunities.  The string functions from the MapInfo help are documented below, and an example of using a few of these string functions for selecting and manipulating a GIS dataset is presented.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
{| align=&amp;quot;center&amp;quot; class=&amp;quot;wikitable&amp;quot;&lt;br /&gt;
&lt;br /&gt;
! Function&lt;br /&gt;
! width=50% | Description&lt;br /&gt;
|-&lt;br /&gt;
|align=&amp;quot;center&amp;quot;|&#039;&#039;&#039;Chr$&#039;&#039;&#039;( num ) || Returns a character that corresponds to a character code (e.g. Chr$(65) returns the string &amp;quot;A&amp;quot;).&lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;DeformatNumber$&#039;&#039;&#039;( str ) || Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators. &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;Format$&#039;&#039;&#039;( num , str ) || Returns a string representing a formatted number. Example: Format$( 12345.678, &amp;quot;$,#.##&amp;quot;) returns &amp;quot;$12,345.68&amp;quot;. &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;FormatNumber$&#039;&#039;&#039;( num ) || Returns a string representing a formatted number. This function is simpler to use than Format$, but it gives you less control over formatting (e.g. you always get thousands separators). &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;InStr&#039;&#039;&#039;( 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). &lt;br /&gt;
|}&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Using_String_Functions&amp;diff=2277</id>
		<title>MI Using String Functions</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Using_String_Functions&amp;diff=2277"/>
		<updated>2011-09-05T10:51:32Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;MapInfo has a range of string (text) functions that offer the user excellent query and text manipulation opportunities.  The string functions from the MapInfo help are documented below, and an example of using a few of these string functions for selecting and manipulating a GIS dataset is presented.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
{| align=&amp;quot;center&amp;quot; class=&amp;quot;wikitable&amp;quot;&lt;br /&gt;
&lt;br /&gt;
! Function&lt;br /&gt;
! width=50% | Description&lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;Chr$&#039;&#039;&#039;( num ) || Returns a character that corresponds to a character code (e.g. Chr$(65) returns the string &amp;quot;A&amp;quot;).&lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;DeformatNumber$&#039;&#039;&#039;( str ) || Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators. &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;Format$&#039;&#039;&#039;( num , str ) || Returns a string representing a formatted number. Example: Format$( 12345.678, &amp;quot;$,#.##&amp;quot;) returns &amp;quot;$12,345.68&amp;quot;. &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;FormatNumber$&#039;&#039;&#039;( num ) || Returns a string representing a formatted number. This function is simpler to use than Format$, but it gives you less control over formatting (e.g. you always get thousands separators). &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;InStr&#039;&#039;&#039;( 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). &lt;br /&gt;
|}&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Using_String_Functions&amp;diff=2276</id>
		<title>MI Using String Functions</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Using_String_Functions&amp;diff=2276"/>
		<updated>2011-09-05T10:49:54Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;MapInfo has a range of string (text) functions that offer the user excellent query and text manipulation opportunities.  The string functions from the MapInfo help are documented below, and an example of using a few of these string functions for selecting and manipulating a GIS dataset is presented.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
{| align=&amp;quot;center&amp;quot; class=&amp;quot;wikitable&amp;quot;&lt;br /&gt;
&lt;br /&gt;
! Function&lt;br /&gt;
! width=50% | Description&lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;Chr$&#039;&#039;&#039;( num ) || Returns a character that corresponds to a character code &amp;lt;br&amp;gt; (e.g. Chr$(65) returns the string &amp;quot;A&amp;quot;).&lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;DeformatNumber$&#039;&#039;&#039;( str ) || Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators. &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;Format$&#039;&#039;&#039;( num , str ) || Returns a string representing a formatted number. Example: Format$( 12345.678, &amp;quot;$,#.##&amp;quot;) returns &amp;quot;$12,345.68&amp;quot;. &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;FormatNumber$&#039;&#039;&#039;( num ) || Returns a string representing a formatted number. This function is simpler to use than Format$, but it gives you less control over formatting (e.g. you always get thousands separators). &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;InStr&#039;&#039;&#039;( 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). &lt;br /&gt;
|}&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Using_String_Functions&amp;diff=2275</id>
		<title>MI Using String Functions</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Using_String_Functions&amp;diff=2275"/>
		<updated>2011-09-05T10:45:25Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: Created page with &amp;quot;MapInfo has a range of string (text) functions that offer the user excellent query and text manipulation opportunities.  The string functions from the MapInfo help are documented...&amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;MapInfo has a range of string (text) functions that offer the user excellent query and text manipulation opportunities.  The string functions from the MapInfo help are documented below, and an example of using a few of these string functions for selecting and manipulating a GIS dataset is presented.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
{| align=&amp;quot;center&amp;quot; class=&amp;quot;wikitable&amp;quot;&lt;br /&gt;
&lt;br /&gt;
! Function&lt;br /&gt;
! width=50% | Description&lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;Chr$&#039;&#039;&#039;( num ) || Returns a character that corresponds to a character code (e.g. Chr$(65) returns the string &amp;quot;A&amp;quot;).&lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;DeformatNumber$&#039;&#039;&#039;( str ) || Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators. &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;Format$&#039;&#039;&#039;( num , str ) || Returns a string representing a formatted number. Example: Format$( 12345.678, &amp;quot;$,#.##&amp;quot;) returns &amp;quot;$12,345.68&amp;quot;. &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;FormatNumber$&#039;&#039;&#039;( num ) || Returns a string representing a formatted number. This function is simpler to use than Format$, but it gives you less control over formatting (e.g. you always get thousands separators). &lt;br /&gt;
|-&lt;br /&gt;
|&#039;&#039;&#039;InStr&#039;&#039;&#039;( 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). &lt;br /&gt;
|}&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Selecting_Subsets&amp;diff=2274</id>
		<title>MI Selecting Subsets</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Selecting_Subsets&amp;diff=2274"/>
		<updated>2011-09-05T06:59:11Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Introduction ==&lt;br /&gt;
MapInfo offers two methods for selecting subsets of other tables; the basic &#039;Select&#039; tool and the more powerful &#039;SQL select&#039;. This example illustrates how the pipes (Type = “C”) in a 1d_nwk_check.mif layer are selected.&lt;br /&gt;
== Basic Select ==&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt;Import the 1d_nwk_check.mif layer into MapInfo. &amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt;To select all channels of Type “C” (ie. pipes or circular culverts) go to Query, Select… to display the dialog below. Ensure the correct table is selected in the &#039;Select Records from Table&#039; drop down box. In the dialogue box type the following: Type = &amp;quot;C&amp;quot;. Click &#039;OK&#039;.&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
[[File:Basic Select.png|frame|none]] &lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
There will now be a temporary table called &#039;selection&#039; which can be added to a map window opened in a new browser window.&lt;br /&gt;
&lt;br /&gt;
== SQL Select ==&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt;Import the 1d_nwk_check.mif layer into MapInfo. &amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt;To select all channels of Type “C” (ie. pipes or circular culverts) go to Query, SQL Select… to display the dialog below.  Click in the “from Tables:” field and use the “Tables” drop down list on the top right to select the 1d_nwk_check layer.  Click in the “where Condition:” field and using the Columns drop down list select Type (or Channel_Type for older 1d_nwk_check layers) and complete the expression as per below: &amp;lt;br&amp;gt;&lt;br /&gt;
Type = “C” &lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
ensuring that quotes are placed around the C.  Finally, for the “into Table Named:” field, instead of “Selection” enter “Pipes”.  Use Verify to check your entries and press OK to select all circular culverts and place them in a virtual table (ie. a subset table of the 1d_nwk_check layer) called Pipes. &amp;lt;/li&amp;gt;&lt;br /&gt;
[[File:SQL Select.png|frame|none]]&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=File:SQL_Select.png&amp;diff=2273</id>
		<title>File:SQL Select.png</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=File:SQL_Select.png&amp;diff=2273"/>
		<updated>2011-09-05T06:58:37Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Selecting_Subsets&amp;diff=2272</id>
		<title>MI Selecting Subsets</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Selecting_Subsets&amp;diff=2272"/>
		<updated>2011-09-05T06:42:05Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Introduction ==&lt;br /&gt;
MapInfo offers two methods for selecting subsets of other tables; the basic &#039;Select&#039; tool and the more powerful &#039;SQL select&#039;. This example illustrates how the pipes (Type = “C”) in a 1d_nwk_check.mif layer are selected.&lt;br /&gt;
== Basic Select ==&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt;Import the 1d_nwk_check.mif layer into MapInfo. &amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt;To select all channels of Type “C” (ie. pipes or circular culverts) go to Query, Select… to display the dialog below. Ensure the correct table is selected in the &#039;Select Records from Table&#039; drop down box. In the dialogue box type the following: Type = &amp;quot;C&amp;quot;. Click &#039;OK&#039;.&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
[[File:Basic Select.png|frame|none]] &lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
There will now be a temporary table called &#039;selection&#039; which can be added to a map window opened in a new browser window.&lt;br /&gt;
&lt;br /&gt;
== SQL Select ==&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt;Import the 1d_nwk_check.mif layer into MapInfo. &amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt;To select all channels of Type “C” (ie. pipes or circular culverts) go to Query, SQL Select… to display the dialog below.  Click in the “from Tables:” field and use the “Tables” drop down list on the top right to select the 1d_nwk_check layer.  Click in the “where Condition:” field and using the Columns drop down list select Type (or Channel_Type for older 1d_nwk_check layers) and complete the expression as per below: &amp;lt;br&amp;gt;&lt;br /&gt;
Type = “C” &lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
ensuring that quotes are placed around the C.  Finally, for the “into Table Named:” field, instead of “Selection” enter “Pipes”.  Use Verify to check your entries and press OK to select all circular culverts and place them in a virtual table (ie. a subset table of the 1d_nwk_check layer) called Pipes. &amp;lt;/li&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Selecting_Subsets&amp;diff=2271</id>
		<title>MI Selecting Subsets</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Selecting_Subsets&amp;diff=2271"/>
		<updated>2011-09-05T06:40:01Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Introduction ==&lt;br /&gt;
MapInfo offers two methods for selecting subsets of other tables; the basic &#039;Select&#039; tool and the more powerful &#039;SQL select&#039;. This example illustrates how the pipes (Type = “C”) in a 1d_nwk_check.mif layer are selected.&lt;br /&gt;
== Basic Select ==&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt;Import the 1d_nwk_check.mif layer into MapInfo. &amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt;To select all channels of Type “C” (ie. pipes or circular culverts) go to Query, Select… to display the dialog below. Ensure the correct table is selected in the &#039;Select Records from Table&#039; drop down box. In the dialogue box type the following: Type = &amp;quot;C&amp;quot;. Click &#039;OK&#039;.&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
[[File:Basic Select.png|frame|none]] &lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
There will now be a temporary table called &#039;selection&#039; which can be added to a map window opened in a new browser window.&lt;br /&gt;
&lt;br /&gt;
== SQL Select ==&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt;Import the 1d_nwk_check.mif layer into MapInfo. &amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Selecting_Subsets&amp;diff=2270</id>
		<title>MI Selecting Subsets</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Selecting_Subsets&amp;diff=2270"/>
		<updated>2011-09-05T05:10:03Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Introduction ==&lt;br /&gt;
MapInfo offers two methods for selecting subsets of other tables; the basic &#039;Select&#039; tool and the more powerful &#039;SQL select&#039;. This example illustrates how the pipes (Type = “C”) in a 1d_nwk_check.mif layer are selected.&lt;br /&gt;
== Basic Select ==&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt;Import the 1d_nwk_check.mif layer into MapInfo. &amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt;To select all channels of Type “C” (ie. pipes or circular culverts) go to Query, Select… to display the dialog below. Ensure the correct table is selected in the &#039;Select Records from Table&#039; drop down box. In the dialogue box type the following: Type = &amp;quot;C&amp;quot;. Click &#039;OK&#039;.&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
[[File:Basic Select.png|frame|none]] &lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
There will now be a temporary table called &#039;selection&#039; which can be added to a map window opened in a new browser window.&lt;br /&gt;
&lt;br /&gt;
== SQL Select ==&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Selecting_Subsets&amp;diff=2269</id>
		<title>MI Selecting Subsets</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Selecting_Subsets&amp;diff=2269"/>
		<updated>2011-09-05T05:07:48Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Introduction ==&lt;br /&gt;
MapInfo offers two methods for selecting subsets of other tables; the basic &#039;Select&#039; tool and the more powerful &#039;SQL select&#039;. This example illustrates how the pipes (Type = “C”) in a 1d_nwk_check.mif layer are selected.&lt;br /&gt;
== Basic Select ==&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt;Import the 1d_nwk_check.mif layer into MapInfo. &amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt;To select all channels of Type “C” (ie. pipes or circular culverts) go to Query, Select… to display the dialog below. Ensure the correct table is selected in the &#039;Select Records from Table&#039; drop down box. In the dialogue box type the following: Type = &amp;quot;C&amp;quot;. Click &#039;OK&#039;.&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
[[File:Basic Select.png|frame|none]] &lt;br /&gt;
&lt;br /&gt;
== SQL Select ==&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=File:Basic_Select.png&amp;diff=2268</id>
		<title>File:Basic Select.png</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=File:Basic_Select.png&amp;diff=2268"/>
		<updated>2011-09-05T05:06:24Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Selecting_Subsets&amp;diff=2267</id>
		<title>MI Selecting Subsets</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Selecting_Subsets&amp;diff=2267"/>
		<updated>2011-09-05T05:05:58Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Introduction ==&lt;br /&gt;
MapInfo offers two methods for selecting subsets of other tables; the basic &#039;Select&#039; tool and the more powerful &#039;SQL select&#039;. This example illustrates how the pipes (Type = “C”) in a 1d_nwk_check.mif layer are selected.&lt;br /&gt;
== Basic Select ==&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt;Import the 1d_nwk_check.mif layer into MapInfo. &amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt;To select all channels of Type “C” (ie. pipes or circular culverts) go to Query, Select… to display the dialog below. Ensure the correct table is selected in the &#039;Select Records from Table&#039; drop down box. In the dialogue box type the following: Type = &amp;quot;C&amp;quot;. Click &#039;OK&#039;.&lt;br /&gt;
 &lt;br /&gt;
&lt;br /&gt;
== SQL Select ==&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Selecting_Subsets&amp;diff=2266</id>
		<title>MI Selecting Subsets</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Selecting_Subsets&amp;diff=2266"/>
		<updated>2011-09-05T04:38:11Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Introduction ==&lt;br /&gt;
MapInfo offers two methods for selecting subsets of other tables; the basic select tool and the more powerful &#039;sql select&#039;. This example illustrates how the pipes (Type = “C”) in a 1d_nwk_check.mif layer are selected.&lt;br /&gt;
== Basic Select ==&lt;br /&gt;
&lt;br /&gt;
== SQL Select ==&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Selecting_Subsets&amp;diff=2265</id>
		<title>MI Selecting Subsets</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Selecting_Subsets&amp;diff=2265"/>
		<updated>2011-09-05T04:37:26Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: Created page with &amp;quot;== Introduction == MapInfo offers two methods for selecting subsets of other tables; the basic select tool and the more powerful &amp;#039;sql select&amp;#039;. This example illustrates how the pi...&amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Introduction ==&lt;br /&gt;
MapInfo offers two methods for selecting subsets of other tables; the basic select tool and the more powerful &#039;sql select&#039;. This example illustrates how the pipes (Type = “C”) in a 1d_nwk_check.mif layer are selected.&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2264</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2264"/>
		<updated>2011-09-05T03:39:01Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;=Introduction=&lt;br /&gt;
To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
=With miTools=&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt;Press the button&amp;lt;/li&amp;gt;&lt;br /&gt;
Describe how to change the format with the .ini file.&lt;br /&gt;
Image here&lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;br /&gt;
=Without miTools=&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression… &lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
[[File:12.1.6.png|frame|none]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; The dialog below should now be displayed.  For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog).  The first argument is the attribute (Elevation in the example below), and the second is a format string.&lt;br /&gt;
&amp;lt;/li&amp;gt;  &lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
The attribute can be entered by using the Columns drop down list.  For the format string, use something like “0.00” making sure that you provide the quotes.  MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell.  Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place.  Examples from the MapInfo help are shown further below.  The line entered in the dialog below is:  Format$(Elevation,&amp;quot;0.00&amp;quot;)&lt;br /&gt;
[[File:12.1.6-2.png|frame|none]]&lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
Other Examples:&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
Format$( 12345, &amp;quot;,#&amp;quot;) &#039; returns &amp;quot;12,345&amp;quot;&amp;lt;br&amp;gt;&lt;br /&gt;
Format$(-12345, &amp;quot;$#&amp;quot;) &#039; returns &amp;quot;-$12345&amp;quot;&amp;lt;br&amp;gt;&lt;br /&gt;
Format$( 12345.678, &amp;quot;$,#.##&amp;quot;) &#039; returns &amp;quot;$12,345.68&amp;quot;&amp;lt;br&amp;gt;&lt;br /&gt;
Format$( 12345.678, &amp;quot;$,#.##;($,#.##)&amp;quot;) &#039;returns &amp;quot;$12,345.68&amp;quot;&amp;lt;br&amp;gt;&lt;br /&gt;
Format$(-12345.678, &amp;quot;$,#.##;($,#.##)&amp;quot;) &#039;returns &amp;quot;($12,345.68)&amp;quot;&amp;lt;br&amp;gt;&lt;br /&gt;
Format$(12345.6789, &amp;quot;,#.###&amp;quot;) &#039; returns &amp;quot;12,345.679&amp;quot;&amp;lt;br&amp;gt;&lt;br /&gt;
Format$(12345.6789, &amp;quot;,#.#&amp;quot;) &#039; returns &amp;quot;12,345.7&amp;quot; &amp;lt;br&amp;gt;&lt;br /&gt;
Format$(-12345.6789, &amp;quot;#.###E+00&amp;quot;) &#039; returns &amp;quot;-1.235e+04&amp;quot;&amp;lt;br&amp;gt;&lt;br /&gt;
Format$(-12345.6789, &amp;quot;#.###E-00&amp;quot;) &#039; returns &amp;quot;-1.235e04&amp;quot;&amp;lt;br&amp;gt;&lt;br /&gt;
Format$( 0.054321, &amp;quot;#.###E-00&amp;quot;) &#039; returns &amp;quot;5.432e-02&amp;quot;&amp;lt;br&amp;gt;&lt;br /&gt;
Format$(0.054321, &amp;quot;#.##%&amp;quot;) &#039; returns &amp;quot;5.43%&amp;quot;&amp;lt;br&amp;gt;&lt;br /&gt;
Format$(0.054321, &amp;quot;0.##\%&amp;quot;) &#039; returns &amp;quot;0.05%&amp;quot; &amp;lt;br&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2262</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2262"/>
		<updated>2011-09-05T03:30:03Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression… &lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:12.1.6.png|frame|none]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; The dialog below should now be displayed.  For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog).  The first argument is the attribute (Elevation in the example below), and the second is a format string.&lt;br /&gt;
&amp;lt;/li&amp;gt;  &lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
The attribute can be entered by using the Columns drop down list.  For the format string, use something like “0.00” making sure that you provide the quotes.  MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell.  Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place.  Examples from the MapInfo help are shown further below.  The line entered in the dialog below is:  Format$(Elevation,&amp;quot;0.00&amp;quot;)&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:12.1.6-2.png|frame|none]]&lt;br /&gt;
&lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2261</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2261"/>
		<updated>2011-09-05T03:29:28Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression… &lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:12.1.6.png|frame|none]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; The dialog below should now be displayed.  For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog).  The first argument is the attribute (Elevation in the example below), and the second is a format string.&lt;br /&gt;
&amp;lt;/li&amp;gt;  &lt;br /&gt;
The attribute can be entered by using the Columns drop down list.  For the format string, use something like “0.00” making sure that you provide the quotes.  MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell.  Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place.  Examples from the MapInfo help are shown further below.  The line entered in the dialog below is:  Format$(Elevation,&amp;quot;0.00&amp;quot;)&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:12.1.6-2.png|frame|none]]&lt;br /&gt;
&lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2260</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2260"/>
		<updated>2011-09-05T03:28:57Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression… &lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:12.1.6.png|frame|none]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; The dialog below should now be displayed.  For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog).  The first argument is the attribute (Elevation in the example below), and the second is a format string.&lt;br /&gt;
&amp;lt;/li&amp;gt;  &lt;br /&gt;
The attribute can be entered by using the Columns drop down list.  For the format string, use something like “0.00” making sure that you provide the quotes.  MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell.  Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place.  Examples from the MapInfo help are shown further below.  The line entered in the dialog below is:&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
Format$(Elevation,&amp;quot;0.00&amp;quot;)&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:12.1.6-2.png|frame|none]]&lt;br /&gt;
&lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2259</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2259"/>
		<updated>2011-09-05T03:25:53Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression… &lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:12.1.6.png|frame|none]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; The dialog below should now be displayed.  For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog).  The first argument is the attribute (Elevation in the example below), and the second is a format string.&lt;br /&gt;
&amp;lt;/li&amp;gt;  &lt;br /&gt;
The attribute can be entered by using the Columns drop down list.  For the format string, use something like “0.00” making sure that you provide the quotes.  MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell.  Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place.  Examples from the MapInfo help are shown further below.  The line entered in the dialog below is:&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
Format$(Elevation,&amp;quot;0.00&amp;quot;)&amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:12.1.6-2.png|frame|none]]&lt;br /&gt;
&lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2258</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2258"/>
		<updated>2011-09-05T03:23:40Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression… &lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:12.1.6.png|frame|none]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; The dialog below should now be displayed.  For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog).  The first argument is the attribute (Elevation in the example below), and the second is a format string.  The attribute can be entered by using the Columns drop down list.  For the format string, use something like “0.00” making sure that you provide the quotes.  MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell.  Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place.  Examples from the MapInfo help are shown further below.  The line entered in the dialog below is:&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
Format$(Elevation,&amp;quot;0.00&amp;quot;)&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:12.1.6-2.png|frame|none]]&lt;br /&gt;
&lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2257</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2257"/>
		<updated>2011-09-05T03:12:21Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression… &lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:12.1.6.png|frame|none]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; The dialog below should now be displayed.  For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog).  The first argument is the attribute (Elevation in the example below), and the second is a format string.  The attribute can be entered by using the Columns drop down list.  For the format string, use something like “0.00” making sure that you provide the quotes.  MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell.  Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place.  Examples from the MapInfo help are shown further below.  The line entered in the dialog below is:&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
Format$(Elevation,&amp;quot;0.00&amp;quot;)&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:12.1.6-2.png|frame|none]]&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2256</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2256"/>
		<updated>2011-09-05T03:12:03Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression… &lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:12.1.6.png|frame|none]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; The dialog below should now be displayed.  For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog).  The first argument is the attribute (Elevation in the example below), and the second is a format string.  The attribute can be entered by using the Columns drop down list.  For the format string, use something like “0.00” making sure that you provide the quotes.  MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell.  Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place.  Examples from the MapInfo help are shown further below.  The line entered in the dialog below is:&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
Format$(Elevation,&amp;quot;0.00&amp;quot;)&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:12.1.6-2,png|frame|none]]&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=File:12.1.6-2.png&amp;diff=2255</id>
		<title>File:12.1.6-2.png</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=File:12.1.6-2.png&amp;diff=2255"/>
		<updated>2011-09-05T03:11:16Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2254</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2254"/>
		<updated>2011-09-05T03:09:10Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression… &lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:12.1.6.png|frame|none]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; The dialog below should now be displayed.  For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog).  The first argument is the attribute (Elevation in the example below), and the second is a format string.  The attribute can be entered by using the Columns drop down list.  For the format string, use something like “0.00” making sure that you provide the quotes.  MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell.  Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place.  Examples from the MapInfo help are shown further below.  The line entered in the dialog below is:&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
Format$(Elevation,&amp;quot;0.00&amp;quot;)&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2253</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2253"/>
		<updated>2011-09-05T03:08:02Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression…&lt;br /&gt;
&lt;br /&gt;
[[File:12.1.6.png|frame|none]]&lt;br /&gt;
&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; The dialog below should now be displayed.  For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog).  The first argument is the attribute (Elevation in the example below), and the second is a format string.  The attribute can be entered by using the Columns drop down list.  For the format string, use something like “0.00” making sure that you provide the quotes.  MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell.  Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place.  Examples from the MapInfo help are shown further below.  The line entered in the dialog below is:&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
Format$(Elevation,&amp;quot;0.00&amp;quot;)&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2252</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2252"/>
		<updated>2011-09-05T03:05:58Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression…&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:12.1.6.png|frame|none]]&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; The dialog below should now be displayed.  For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog).  The first argument is the attribute (Elevation in the example below), and the second is a format string.  The attribute can be entered by using the Columns drop down list.  For the format string, use something like “0.00” making sure that you provide the quotes.  MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell.  Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place.  Examples from the MapInfo help are shown further below.  The line entered in the dialog below is:&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
Format$(Elevation,&amp;quot;0.00&amp;quot;)&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2251</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2251"/>
		<updated>2011-09-05T03:05:30Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression…&amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
[[File:12.1.6.png|frame|none]]&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; The dialog below should now be displayed.  For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog).  The first argument is the attribute (Elevation in the example below), and the second is a format string.  The attribute can be entered by using the Columns drop down list.  For the format string, use something like “0.00” making sure that you provide the quotes.  MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell.  Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place.  Examples from the MapInfo help are shown further below.  The line entered in the dialog below is:&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
Format$(Elevation,&amp;quot;0.00&amp;quot;)&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2250</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2250"/>
		<updated>2011-09-05T03:05:06Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression…&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:12.1.6.png|frame|none]]&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; The dialog below should now be displayed.  For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog).  The first argument is the attribute (Elevation in the example below), and the second is a format string.  The attribute can be entered by using the Columns drop down list.  For the format string, use something like “0.00” making sure that you provide the quotes.  MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell.  Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place.  Examples from the MapInfo help are shown further below.  The line entered in the dialog below is:&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
Format$(Elevation,&amp;quot;0.00&amp;quot;)&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2249</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2249"/>
		<updated>2011-09-05T03:04:36Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression…&lt;br /&gt;
[[File:12.1.6.png|frame|none]]&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;li&amp;gt; The dialog below should now be displayed.  For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog).  The first argument is the attribute (Elevation in the example below), and the second is a format string.  The attribute can be entered by using the Columns drop down list.  For the format string, use something like “0.00” making sure that you provide the quotes.  MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell.  Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place.  Examples from the MapInfo help are shown further below.  The line entered in the dialog below is:&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
Format$(Elevation,&amp;quot;0.00&amp;quot;)&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2248</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2248"/>
		<updated>2011-09-05T03:04:17Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression…&lt;br /&gt;
[[File:12.1.6.png|frame|none]]&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;li&amp;gt; The dialog below should now be displayed.  For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog).  The first argument is the attribute (Elevation in the example below), and the second is a format string.  The attribute can be entered by using the Columns drop down list.  For the format string, use something like “0.00” making sure that you provide the quotes.  MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell.  Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place.  Examples from the MapInfo help are shown further below.  The line entered in the dialog below is:&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
Format$(Elevation,&amp;quot;0.00&amp;quot;)&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2247</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2247"/>
		<updated>2011-09-05T03:00:44Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;ol&amp;gt;&lt;br /&gt;
&amp;lt;li&amp;gt; Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression…&lt;br /&gt;
[[File:12.1.6.png|frame|none]]&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;li&amp;gt; The dialog below should now be displayed.  For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog).  The first argument is the attribute (Elevation in the example below), and the second is a format string.  The attribute can be entered by using the Columns drop down list.  For the format string, use something like “0.00” making sure that you provide the quotes.  MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell.  Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place.  Examples from the MapInfo help are shown further below.  The line entered in the dialog below is:&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&amp;lt;/ol&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2246</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2246"/>
		<updated>2011-09-05T02:59:53Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;li&amp;gt; Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression…&lt;br /&gt;
[[File:12.1.6.png|frame|none]]&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;li&amp;gt; The dialog below should now be displayed.  For the expression, use the Format$() string function as shown below (this can be entered by using the Functions drop down list on the right of the dialog).  The first argument is the attribute (Elevation in the example below), and the second is a format string.  The attribute can be entered by using the Columns drop down list.  For the format string, use something like “0.00” making sure that you provide the quotes.  MapInfo uses the same (or very similar) formatting strings as Microsoft Excel does when formatting a Number cell.  Examples are “0.00” to display to two decimal places, “0.0” to display to one decimal place.  Examples from the MapInfo help are shown further below.  The line entered in the dialog below is:&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2245</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2245"/>
		<updated>2011-09-05T02:58:18Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;li&amp;gt;Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression…&lt;br /&gt;
[[File:12.1.6.png|frame|none]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2244</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2244"/>
		<updated>2011-09-05T02:57:58Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;li&amp;gt;Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression…&lt;br /&gt;
[[File:12.1.6.pngframe|none]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2243</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2243"/>
		<updated>2011-09-05T02:57:13Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;li&amp;gt;Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression…&lt;br /&gt;
[[File:12.1.6.png]frame|none]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;/li&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=File:12.1.6.png&amp;diff=2242</id>
		<title>File:12.1.6.png</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=File:12.1.6.png&amp;diff=2242"/>
		<updated>2011-09-05T02:56:23Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2241</id>
		<title>MI Label Format Number</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Label_Format_Number&amp;diff=2241"/>
		<updated>2011-09-05T02:54:46Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;To control the number of decimal places when creating labels for a number (float) field (eg. a Z or Elevation attribute), follow these steps.&lt;br /&gt;
&amp;lt;li&amp;gt;Go to Layer Control, tick the label box for the layer you wish to label and press Label…. to display the dialog below.  In the “Label with:” field, select Expression….&amp;lt;/li&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Hotlinking&amp;diff=2138</id>
		<title>MI Hotlinking</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Hotlinking&amp;diff=2138"/>
		<updated>2011-08-29T01:15:14Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Introduction ==&lt;br /&gt;
Blah blah blah&lt;br /&gt;
== Method ==&lt;br /&gt;
Highlight the desired table in the layer control window, then select the &#039;hotlinks options&#039; button at the top of the window as shown below.&lt;br /&gt;
[[File:hotlink_1.png|frame|none]]&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=File:Hotlink_1.png&amp;diff=2137</id>
		<title>File:Hotlink 1.png</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=File:Hotlink_1.png&amp;diff=2137"/>
		<updated>2011-08-29T01:14:10Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Hotlinking&amp;diff=2136</id>
		<title>MI Hotlinking</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Hotlinking&amp;diff=2136"/>
		<updated>2011-08-29T01:13:59Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: Created page with &amp;#039;== Introduction == Blah blah blah == Method == Highlight the desired table in the layer control window, then select the &amp;#039;hotlinks options&amp;#039; button at the top of the window as show...&amp;#039;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Introduction ==&lt;br /&gt;
Blah blah blah&lt;br /&gt;
== Method ==&lt;br /&gt;
Highlight the desired table in the layer control window, then select the &#039;hotlinks options&#039; button at the top of the window as shown below.&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
	<entry>
		<id>https://wiki.tuflow.com/w/index.php?title=MI_Setting_Number_of_Undo_Objects&amp;diff=2135</id>
		<title>MI Setting Number of Undo Objects</title>
		<link rel="alternate" type="text/html" href="https://wiki.tuflow.com/w/index.php?title=MI_Setting_Number_of_Undo_Objects&amp;diff=2135"/>
		<updated>2011-08-26T06:44:30Z</updated>

		<summary type="html">&lt;p&gt;Ari Craven: Created page with &amp;#039;The default setting for the number of Undo objects is relatively small in MapInfo.  To change this, go to Options, Preferences, System Settings… to bring up the dialog below.  ...&amp;#039;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;The default setting for the number of Undo objects is relatively small in MapInfo.  To change this, go to Options, Preferences, System Settings… to bring up the dialog below.  For modern day computers there should be no problems with setting the “Number of Undo Objects:” to the maximum of 800 and “Memory Size for Undo:” to a larger number such as 10,000,000 (10Mb).&lt;br /&gt;
[[File:12.1.4.png|frame|none]]&lt;/div&gt;</summary>
		<author><name>Ari Craven</name></author>
	</entry>
</feed>