Removing unwanted comma's

[Mark Smith]

Here's another one:

function removeCommas tData
    set the itemdelimiter to quote
    repeat for each item i in tData
       add 1 to iCount
       put i into tItem
       if iCount mod 2 = 0 then replace comma with empty in tItem
       put tItem after nData
    end repeat
    return nData
end removeCommas

Best,

Mark

On 5 Apr 2008, at 23:12, David Coker 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