Conversion File Error

[Former Member]

Hi,

We are using BPC10.1(SP08), BW7.4(SP13) & EPM addin(SP25)

I am facing an issue while loading Master Data for Project Dimension, We need to achieve two conditions:

1) If the BW has .(Period), it should be skip

2) If BW has "/"(Forward Slash),   replace Forward Slash with .(Period)

My Conversion File below isnt working:

EXTERNAL	INTERNAL	FORMULA
*	js: %external%.replace("/", ".")
*.*	*SKIP

My conversion file below works with one record

EXTERNAL	INTERNAL	FORMULA
ABC/789	js: %external%.replace("/", ".")
*	*SKIP

The formula which is working for just one member doesn't work for *

And I have one More Condition, where I need to Pull if the number contains "Period" as well as "Forward Slash"

Please advice,

Thanks,

Hari

[Former Member · Accepted solution]

Hi Vadim,

Many Thanks for your reply, It helped me in Solving two conditions while loading Master data, and I have one more condition where I need to bring the data which contains both "." (Period) and "/" (Forward Slash) like

     1.  A.B   -> *SKIP ( Working)

     2. A/B   ->  A.B    (Working)

     3.  A.B/C -> A.B.C (Not able to achieve condition)

Please advice..

Thanks,

Hari

[former_member186338 · Accepted solution]

May be:

*.*/*    js: %external%.replace("/", ".")

*.*

*SKIP

*          js: %external%.replace("/", ".")

not sure...

Vadim

[Former Member · Accepted solution]

Hi Vadim,

May thanks, there were only few records with Period  and Slash, so I maintained them Manually in the Conversion File...

Thanks,

Hari

[former_member186338]

Hi Hari,

Nothing will be executed after line:

* JS:...

But I do not understand the logic: What do you want to replace and what do you want to skip.

Please show data examples!

Vadim

[former_member186338]

P.S.:

Looks like I understood...

Then first skip, then replace:

*.*       *SKIP

*          js: %external%.replace("/", ".")

P.S. Please sample for: "I need to Pull if the number contains "Period""