CASE statement available?

[landaghaar]

Is there any way to use in a Transformer Expression to handle multiple replace statements?

Just like CASE statement in programming or even in databases:

CASE param:
When 'A' Then 1
When 'Y' Then 2
When 'X' Then 3
When 'M' Then 4
....

[DSguru2B]

Not case, but you can have multiple if-then-else statements.

[landaghaar]

That sux.

[gateleys]

That sux.

The if-then-else might, but not if you used Ereplace function.

[landaghaar]

That sux.

The if-then-else might, but not if you used Ereplace function.

How would you use that? Ereplace can only replace one string, how can you make it work like DECODE function in oracle or CASE statement in programming?

[gateleys]

Is there any way to use in a Transformer Expression to handle multiple replace statements?

Just like CASE statement in programming or even in databases:

CASE param:
When 'A' Then 1
When 'Y' Then 2
When 'X' Then 3
When 'M' Then 4
....

For the exact problem, you could use -

Code: Select all

ereplace(ereplace(ereplace(ereplace(Arg1,'A',1),'Y',2),'X',3),'M',4)

Note that the function replaces every occurrence of the characters to their respective target values. So, if you have 'ABC', it will convert it to 1BC, and 'AYX' will convert to 123.

[ray.wurlod]

If it's character-by-character the most efficient function is Convert().

Convert("AYXM","1234",InLink.TheChar)

You might then need to convert to integer of some kind.