Masterdata Loading from Flatfile

[Former Member]

Hi People,

I am trying to load Master data from flat file for POSITION Dimension and I have one Property called PositionCC.

I have values for PositionCC like 0525.1105250222 and I want to convert them as highlighted with conversion.

0525.11052 = 11052

So used Conversion like below and worked as expected.

But PositionCC value length is not fixed before dot and after dot.

Example I will have PositionCC like below in flat file

0525.11052 = 11052

054.345689 = 345689

04567.234 = 234

So i wanted to derive value for PositionCC which i have after dot(.), I am wondering is there any way to do please?

Thanks,

Vishu

[former_member186338 · Accepted solution]

Simply use simple JavaScript in Internal for conversion

Vadim

[former_member186338 · Accepted solution]

Like:

js: %external%.toString().substr(%external%.toString().indexOf(".")+1)

[Former Member · Accepted solution]

Thanks Vadim. It worked .