Is there an equivalent to python .replace in mapbasic? Something like
search = search.replace(',', ' ')
I have found the search and replace tool for mapinfo and it works well but I need something simple to just replace all the ',' in a table with a space.
There are questions from 2007 saying this is not possible but has this changed? http://git.net/ml/mapinfo-l/2009-09/msg00107.html and https://groups.google.com/forum/#!topic/mapinfo-l/9QLqjsBTO_0
From one of my past questions I see we can find the ',' using
(InStr(1, SearchColumn, ",")
but how do I replace this character when found?
A line would be like "123, Main Street, GIS Town" and should become "123 Main Street GIS Town"
and it needs to be run in a table update command.
Update DCDB_Address Set Search = Search+" [Address]"