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.... wayne On Sat, Apr 5, 2008 at 6:12 PM, David Coker <[EMAIL PROTECTED]> wrote: > Hello folks, > I ran into a problem that I just can't seem to figure out and hope > someone can offer a suggestion or solution. (More than likely simple > using Rev, but it surely escapes me.) Is there a way to remove > spurious comma's inside a text field that contains comma delimited > data, while maintaining the integrity of the individual data fields? > > Example: > fieldonedata,fieldtwodata,"fieldthree,data", fieldfourdata,etc. > > I need to remove the quotes the comma located within the quotes as > well as the quote characters, to end up with this: > > fieldonedata,fieldtwodata,fieldthreedata, fieldfourdata,etc. > > I've wasted a big portion of my day trying to figure this out and > would really appreciate any help I can get. > > David > _______________________________________________ > use-revolution mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
