cancel
Showing results for 
Search instead for 
Did you mean: 

How to perform Excel formula RIGHT in BPC Transformtion

bpunchev
Participant
0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

Something like (Conversion)

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

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

Answers (0)