Skip to Content
0
Oct 06, 2016 at 01:47 PM

How to perform Excel formula RIGHT in BPC Transformtion

33 Views

Is there a way to use in BPC Transformation file formula like:

*MAPPING ID=ID DESC=*RIGHT(4;ID)

A sample ID records are looking like these:

IN0002000002_FMAX

IN0002000002_FMIN

IN0002000002_HMAX

IN0002000002_HMIN

IN0002000002_HOME

IN0002000002_PROF

IN0002000002_QUOT

I want get the last 4 chars from the ID string and to use them as values for the DESC property.

How can I do that?