leading/trailing spaces

Vinn

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 !!

Sh!va

Don't know how this file is generated. But SQL can trim those spaces or of any other souce then any scripting language can trim spaces for you before you load to essbase.

Vinn

yes in SQL we can trim but would like to know is there any option for alias load in essbase as we have for dimension/data load which can  be applied in rule file.