MI-L unformatting field value

Hi Folks, I'd like to update a field to be 'unformatted'. Currently it has a comma every 3 characters (a character field with numeric data) but I'd like to remove those commas. I haven't found a direct reference to it in the user guide or in the mapinfo-l archives. Can anyone help?

SUM: MI-L unformatting field value

Hello again, Jacques Paris helpfully informed me that the regional and language options available via Control Panel enable me to specify digit grouping preferences - and it worked! Thanks Jacques, Alistair. *** Alistair Hart GIS Project

MI-L MapInfo StreetPro Table Format Question

Hi All, I have noticed that MI's StreetPro product has formatting (line thickness and color) within thre street data table that is associated with the different road classes. The formatting is part of the table structure and does not require one to create a workspace to preserve the Style

RE: MI-L Right$ argument 1 has invalid type

Hi Alistair, That's because you can't trim a NUMBER field, you can only run mathematical operations on it. But what you can do is cast the number as a string (STR$), then truncate it (RIGHT$), then cast it back to a number (VAL). Update MYTABLE set MYCOLUMN = val(right$(str$(MYCOLUMN), 4))

SUM: MI-L Right$ argument 1 has invalid type

Thankyou to the following people who all had (thankfully) the same answer: Andrew Williams, Robert Crossley, Michael Taylor, Ian Tidy, Julian Parker, Stephen Chan, Steve Smith and Peter Zyczynski. The solution is: You are trying to trim an integer, but trim only works on a string Try