5 Replies Latest reply on Feb 21, 2008 8:11 PM by cfwild

    Unique Replace Function

    cfwild Level 1

      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!