MI Using String Functions - Revision history

Chris Huxley at 23:52, 5 February 2015

2015-02-05T23:52:09Z

← Older revision		Revision as of 09:52, 6 February 2015
Line 44:		Line 44:

	{{Tips Navigation		{{Tips Navigation
	\|uplink=[[MapInfo_Tips \| Back to MapInfo]]}}		\|uplink=[[MapInfo_Tips \| Back to MapInfo Tips]]}}

Chris Huxley at 23:51, 5 February 2015

2015-02-05T23:51:46Z

← Older revision		Revision as of 09:51, 6 February 2015
Line 40:		Line 40:
	\|-		\|-
	\|}		\|}



			{{Tips Navigation
			\|uplink=[[MapInfo_Tips \| Back to MapInfo]]}}

Ari Craven at 11:06, 5 September 2011

2011-09-05T11:06:37Z

@@ Line 9: / Line 9: @@
 |'''Chr$'''( num ) || Returns a character that corresponds to a character code (e.g. Chr$(65) returns the string "A").
 |-
-|align="center"|'''DeformatNumber$'''( str ) || Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators.
+|'''DeformatNumber$'''( str ) || Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators.
 |-
-|align="center"|'''Format$'''( num , str ) || Returns a string representing a formatted number. Example: Format$( 12345.678, "$,#.##") returns "$12,345.68".
+|'''Format$'''( num , str ) || Returns a string representing a formatted number. Example: Format$( 12345.678, "$,#.##") returns "$12,345.68".
 |-
-|align="center"|'''FormatNumber$'''( 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).
+|'''FormatNumber$'''( 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).
 |-
 |}

Ari Craven at 10:58, 5 September 2011

2011-09-05T10:58:50Z

← Older revision		Revision as of 20:58, 5 September 2011
Line 7:		Line 7:
	! width=75% \| Description		! width=75% \| Description
	\|-		\|-
	~~\|align="center"~~\|'''Chr$'''( num ) \|\| Returns a character that corresponds to a character code (e.g. Chr$(65) returns the string "A").		\|'''Chr$'''( num ) \|\| Returns a character that corresponds to a character code (e.g. Chr$(65) returns the string "A").
	\|-		\|-
	\|align="center"\|'''DeformatNumber$'''( str ) \|\| Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators.		\|align="center"\|'''DeformatNumber$'''( str ) \|\| Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators.

Ari Craven at 10:58, 5 September 2011

2011-09-05T10:58:21Z

← Older revision		Revision as of 20:58, 5 September 2011
Line 5:		Line 5:

	! Function		! Function
	! width=50% \| Description		! width=75% \| Description
	\|-		\|-
	\|align="center"\|'''Chr$'''( num ) \|\| Returns a character that corresponds to a character code (e.g. Chr$(65) returns the string "A").		\|align="center"\|'''Chr$'''( num ) \|\| Returns a character that corresponds to a character code (e.g. Chr$(65) returns the string "A").

Ari Craven at 10:57, 5 September 2011

2011-09-05T10:57:33Z

← Older revision		Revision as of 20:57, 5 September 2011
Line 9:		Line 9:
	\|align="center"\|'''Chr$'''( num ) \|\| Returns a character that corresponds to a character code (e.g. Chr$(65) returns the string "A").		\|align="center"\|'''Chr$'''( num ) \|\| Returns a character that corresponds to a character code (e.g. Chr$(65) returns the string "A").
	\|-		\|-
	\|'''DeformatNumber$'''( str ) \|\| Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators.		\|align="center"\|'''DeformatNumber$'''( str ) \|\| Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators.
	\|-		\|-
	\|'''Format$'''( num , str ) \|\| Returns a string representing a formatted number. Example: Format$( 12345.678, "$,#.##") returns "$12,345.68".		\|align="center"\|'''Format$'''( num , str ) \|\| Returns a string representing a formatted number. Example: Format$( 12345.678, "$,#.##") returns "$12,345.68".
	\|-		\|-
	\|'''FormatNumber$'''( 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).		\|align="center"\|'''FormatNumber$'''( 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).
	\|-		\|-
	\|'''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).		\|align="center"\|'''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).
	\|}		\|}

Ari Craven at 10:56, 5 September 2011

2011-09-05T10:56:33Z

← Older revision		Revision as of 20:56, 5 September 2011
Line 7:		Line 7:
	! width=50% \| Description		! width=50% \| Description
	\|-		\|-
	\|'''Chr$'''( num ) \|\| Returns a character that corresponds to a character code (e.g. Chr$(65) returns the string "A").		\|align="center"\|'''Chr$'''( num ) \|\| Returns a character that corresponds to a character code (e.g. Chr$(65) returns the string "A").
	\|-		\|-
	\|'''DeformatNumber$'''( str ) \|\| Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators.		\|'''DeformatNumber$'''( str ) \|\| Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators.

Ari Craven at 10:51, 5 September 2011

2011-09-05T10:51:32Z

← Older revision		Revision as of 20:51, 5 September 2011
Line 7:		Line 7:
	! width=50% \| Description		! width=50% \| Description
	\|-		\|-
	\|'''Chr$'''( num ) \|\| Returns a character that corresponds to a character code ~~<br>~~ (e.g. Chr$(65) returns the string "A").		\|'''Chr$'''( num ) \|\| Returns a character that corresponds to a character code (e.g. Chr$(65) returns the string "A").
	\|-		\|-
	\|'''DeformatNumber$'''( str ) \|\| Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators.		\|'''DeformatNumber$'''( str ) \|\| Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators.

Ari Craven at 10:49, 5 September 2011

2011-09-05T10:49:54Z

← Older revision		Revision as of 20:49, 5 September 2011
Line 7:		Line 7:
	! width=50% \| Description		! width=50% \| Description
	\|-		\|-
	\|'''Chr$'''( num ) \|\| Returns a character that corresponds to a character code (e.g. Chr$(65) returns the string "A").		\|'''Chr$'''( num ) \|\| Returns a character that corresponds to a character code <br> (e.g. Chr$(65) returns the string "A").
	\|-		\|-
	\|'''DeformatNumber$'''( str ) \|\| Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators.		\|'''DeformatNumber$'''( str ) \|\| Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators.

Ari Craven: Created page with "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..."

2011-09-05T10:45:25Z

Created page with "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..."

New page

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.
<br>
<br>
{| align="center" class="wikitable"

! Function
! width=50% | Description
|-
|'''Chr$'''( num ) || Returns a character that corresponds to a character code (e.g. Chr$(65) returns the string "A").
|-
|'''DeformatNumber$'''( str ) || Reverses the effect of the FormatNumber$ function, returning a string that does not include thousands separators.
|-
|'''Format$'''( num , str ) || Returns a string representing a formatted number. Example: Format$( 12345.678, "$,#.##") returns "$12,345.68".
|-
|'''FormatNumber$'''( 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).
|-
|'''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).
|}