5 Replies Latest reply on Mar 4, 2011 3:43 PM by 791664

    Error in Replace() script

      Hi Guys,

      Please find below a script I want to use. I recently added a line to delete the diaeresis or " in one of the columns of my .csv import file:

      Function LAEP090_COMMA(strField, strRecord)
      'Oracle Hyperion FDM DataPump Import Script:
      'Created By:     ADMIN
      'Date Created:     3/3/2011 1:07:40 PM
      'delete diaeresis in exported .csv file before and after amount: "amount"
           strfield=Replace(strfield, """, "")

      'make values xK
      If IsNumeric(strfield) Then
      End If

      End Function

      Now I know """ seems to generate the problem. Because when I do "." for another script to delete a thousand separator, it works fine.

      How can I make sure the " is deleted before and after the amount?

      Thanks for your help!

      Kind regards,