Removing unwanted comma's
Mark Smith
mark at maseurope.net
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
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
More information about the use-livecode
mailing list