Hi Ravita,
There is a tool that comes with MapInfo Pro, that does this. It's the
Search and Replace Tool.
Search for " Otista Raya " and Replace with "OtistaRaya"
If you are looking for a way to remove all spaces inseide you text string,
I guess you'll have to make your own function that does it.
Use InStr() to find the spaces and then use the Left$() and Right$ to cut
out the part of the word on the left and the right side of the space.
Afterwards you'll just put them together again within the space.
**************************
Function RemoveAllSpaces$(ByVal szText As String) As String
Dim i As Integer
szText = RTrim$(LTrim$(szText))
i = InStr(1, szText, " ")
Do While i > 0
If i = 1 Then
szText = Right$(szText, Len(szText) - i)
Else
szText = Left$(szText, i - 1) + Right$(szText, Len(szText) -
i)
End If
i = InStr(i + 1, szText, " ")
Loop
KommaToPoint = szText
*************************
Hope this helps,
Peter
------------------------------------------------------------------------------------------------
Peter Horsb�ll M�ller, GIS-Developer
Kampsax A/S, GIS Software & Solutions, Rugaardsvej 55, DK-5000 Odense, Denmark
tlf: + 45 63 13 50 13, dir: + 45 63 13 50 08, fax: + 45 63 13 50 90
mail: [EMAIL PROTECTED], http://www.mapinfo.dk, http://www.kampsax.dk
------------------------------------------------------------------------------------------------
----- Videresendt af Peter M�ller/Kampsax - 05-10-01 07:45 -----
Ravita
<[EMAIL PROTECTED]> Til:
"'[EMAIL PROTECTED]'"
Sendt af:
<[EMAIL PROTECTED]>
[EMAIL PROTECTED] cc:
onsmag.com Vedr.: MI-L Trim
05-10-01 06:32
Besvar venligst til Ravita
Dear All,
Does anyone know for trim function in map basic besides RTrim and LTrim.
Because I need to truncate these words " Otista Raya " ~~> "OtistaRaya"
Thank you
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
