How to perform Excel formula RIGHT in BPC Transformtion

[Boyan_P]

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?

[former_member186338 · Accepted solution]

If the string length is fixed you can do something like ID(12:16)

But it's better to use conversion file with JavaScript

[former_member186338 · Accepted solution]

Something like (Conversion)

*      js:%external%.slice(-4)

P.S. Excel formulas have no relation to transformation or conversion files!