Conversion File

[Former Member]

Friends,

I need to pass only last 4 digits of territory ID out of 25 digits in to BPC from BW Infoobject. i know we can achieve this with conversion file but no clue how should be the conversion file.

Ex. Territory ID = 12435689765443466778788 i need only 4 digits 8788.

Pls suggest me.

Thanks,

RRRR

[Former Member · Accepted solution]

Hi,

have you tried to archive it in the transformation file?

In the Mapping section you wuld need something like:

ID = ID(22:25)

This would make a selection of the last four positions (from 22 to 25) from you ID and write back only the for numbers ypu need.

Hope it helps.

Cheers,

Àlex

[former_member190501]

Hi,

Try as follows in conversion file:

External               Internal
*                           js: %external%.substring(22,4)

Hope it helps...

regards,

Raju