Unique Replace Function

[Guest]

Hi,

I'm working with a comma delimited file. In some fields, I run into a situation like this:

, "1,0000",

The first comma and the last comma are delimiters. The comma that is enclosed within the quotes is causing the problem. Is there a replace function that can find the " then kill the comma, but still leave all the delimiters alone?

Any thoughts would be appreciated!

cfwild

[Dan_Bracuk]

cfhttp may be helpful. After you upload the file you can use the name attribute to convert it to a query. There is something in there as well where you can specify quotes.

[emerys]

Yes, there is a replace function. It even has an example of eliminating all commas from a string.

[Guest]

Hi,

I'm attaching the code I wrote to go through all of these. It works fine, but I'm thinking there has to be an faster way to proceed. (Code A)

I also wrote a regular expression that gets me close, but no easy way to use a Replace or REPlace function.

Any thoughts on speeding this up would be appreciated!

cfwild

[Grizzly9279]

You might find this useful:
http://www.bennadel.com/index.cfm?dax=blog:498.view

[Guest]

Hi,

I've continued to modify the original code. I'm now using a Regular Expression to try and speed this up. I've also nested some of the code. If you can think of ways to speed this up, into more of a one line REReplace type function, I'd appreciate the input.

Thanks to all for their input.

Ciao,

cfwild