Forum Stats

  • 3,769,308 Users
  • 2,252,946 Discussions
  • 7,874,982 Comments

Discussions

leading/trailing spaces

Vinn
Vinn Member Posts: 239 Blue Ribbon
edited Jul 28, 2020 10:34PM in EPM System Infrastructure

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'<br/>Qtr1 Quarter1<br/>Jan January<br/>Feb February<br/>Mar March<br/>$END

alter database load alias_table

Thanks in advance !!

Tagged:

Answers