Routine for spilt the char length

[Former Member]

Hi,

I want to write routine for spilt the char length. Example: i'm getting field (PRDHA, Length:18) from ECC to BI system, in BI system i have 3 infoobjects. my requirement is

1st object to get 1-5 length from PRDHA field

2nd object to get 6-10 length from PRDHA field

3rd object to get 11-18 length from PRDHA field

Please suggest routine with clear codding.

Thanks

G Bush

[former_member205352]

logic would be :

PRDHA+0(5)

PRDHA+6(5)

PRDHA+11(9)

Hope this helps.

[Former Member]

Thanks for yr reply, i know logic but still getting error in transformation routines, i want details coding in routine and suggest where exactly i have to write this coding .

Thanks.

[former_member205352]

Can you paste the code you have written so that we can see whats the issue.

[Former Member]

i know only logic PRDHA0(5), PRDHA6(5), PRDHA+11(9) but i want detail coding into routines. If u give details code i use into routine.

Thanks for your support.

[former_member205352]

Go to transformation.

While mapping your fields choose routine.

In BI 7 :

Result = Source_Fields-prdha+0(5)

In BI 3.X

Result = Comm-struc-prdha+0(5).

Similarly for other two.

Hope this helps.

[Former Member]

Thanks for your suggestion, i'll try let u know.