Removing unwanted comma's

[David Coker]

Sorry for the delay in replying folks... been mostly away from the
keyboard since the original post.

Wow! There are some really cool ideas to try out here... thanks so
much to everyone who has offered suggestions! Now the fun begins in
trying things out to see what works best for the application. :)

David


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