2 Replies Latest reply on Jul 29, 2020 2:34 AM by 1060285

    leading/trailing spaces

    1060285

      HI All,

       

      Is there any option to drop leading/trailing space for the alias load.

      For eg:

      My source file is as below. if there is extra space on 2 column members for Quarter1 . I want it to get dropped.  Any suggestions please.

       

      $ALT_NAME 'Quarters'
      Qtr1 Quarter1
      Jan January
      Feb February
      Mar March
      $END

      alter database load alias_table

       

      Thanks in advance !!