Removing unwanted comma's
davidocoker at gmail.com
Sat Apr 5 17:42:47 CDT 2008
Yup, I've gone through pretty much the same routine using Excel or
OpenOffice Calc for years now... which is the reason I'm looking for a
Rev based solution. I hope to add the functionality to my application,
giving the end user a way off that treadmill. :)
Thanks for your reply just the same!
On Sat, Apr 5, 2008 at 5:33 PM, wayne durden <wdurden at gmail.com> wrote:
> Hi David:
> I have to do this all the time for datasets I process. If you need to do it
> quick and dirty one off, rather than code up a routine in rev, you can open
> the dataset in excel. If the field three data is numerical you can get rid
> of the comma by selecting the column then using format cells and choose the
> numeric type without the comma. If it is text stuff then you select the
> column and use replace to replace the commas with some other item or nothing
> at all.
> Once I have done this and saved out the file, I would still open in in a
> text editor and zap any quotes with a replace there....
> I know this isn't the rev function answer, but it is quick and easy if the
> problem isn't recurring....
More information about the use-livecode