Removing unwanted comma's

Mark Smith mark at
Sat Apr 5 23:25:48 EDT 2008

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



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
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:

More information about the Use-livecode mailing list