> Is there a Map Basic function that replicates the functionality of the
Xbase
> AT() function? An example of proposed usage would be creating a road name
> field from a database that contain addresses. The AT() function would be
used
> to determine where the space is between the "house number" and "road name"
so
> it would be possible to separate the address from the road name.
>
> In Xbase the code would look like:
>
> Start_No = AT(Space(1),NewRoad)+1
> Replace NewRoad with SUBSTR(NEWROAD,Start_No,30)
>
> If there isn't an "AT()" type function, how would one create a variable
> indicating the position of a space in a character string?
>
As I understend you need function InStr( ):
Purpose
Returns a character position, indicating where a substring first appears
within another string.
Syntax
InStr ( position, string, substring )
position is a positive integer, indicating the start position of the search
string is a string expression
substring is a string expression which we will try to locate in string
Return Value Integer
Am I right?
Dima Omely
http://members.xoom.com/geosoft99/
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
