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