Removing unwanted comma's

[wayne durden]

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 <davidocoker at gmail.com> 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
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>