Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

removing last 3 characters from a string

tyson33Jan 28 2010 — edited Jan 29 2010

Hi,

I am trying to make a script that removes the last 3 characters from all members in the entity dimension. The strings are variable in lenght, so the only way to do it is to remove the characters from the end.

I tried this, but it doesnt do the job:

NewEnt = Left(strField, Len(strField -3))

any help would be appreciated,

thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 25 2010

Added on Jan 28 2010

#business-intelligence-applications, #fdm, #financial-data-management, #performance-management-applications, #script

6 comments

8,959 views