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
[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
