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

    Error in Replace() script

    798182
      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
      '
      'Purpose:
      '
      '------------------------------------------------------------------
      'delete diaeresis in exported .csv file before and after amount: "amount"
           strfield=Replace(strfield, """, "")
           
           LAEP090_COMMA=strfield

      'make values xK
      If IsNumeric(strfield) Then
           LAEP090_COMMA=(strfield/1000)
      Else
           LAEP090_COMMA=strfield
      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,
      JDeM