Removing unwanted comma's

[Joe Lewis Wilkins]

Hi David,

This is how I would approach your problem:

put the field in question into a VAR
reconstruct the field by reading the items of the VAR into another VAR  
one by one
When you get a VAR that starts and ends with a quote break it down  
into VARs as well, deleting the first char of one and the last char of  
the other
This will automatically remove the comma in the middle
As you do this accumulate the "fixed" items as items in a new VAR
Put that VAR into the msg box to check the finished product
When you have what you need put that into the field in question

I can't be more definite because I don't know what your "etceteras"  
really indicate.

HTH

Joe Wilkins

On Apr 5, 2008, at 3:12 PM, 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