cancel
Showing results for 
Search instead for 
Did you mean: 

Converting 12-digit PO NUMBER to 10digit PO-NUMBER

praveenreddy_bk
Participant
0 Kudos

HI,

I need a code in java for Mapping to Convert 12 Digit Purchase order number to 10 Digit Purchase order number

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

No need to write any java code for this. Just use the "Substring" function to achieve this goal like this.

Source -


> Substring (2 .. 😎 -


> Target

I guess you want to leave the first 2 leading zeros in the incoming PO.

Remember, you should always get the PO_NUMBER of length 12 otherwise you will get the error "string out of range"

Regards,

Sarvesh

Former Member
0 Kudos

Hi

u can use the standard substring function in the mapping.

u have to use the function in the following way.

source field>substring->target field

(0---10)

Thanks

Rinku

praveenreddy_bk
Participant
0 Kudos

for Example my Purchase order number is like this :

KL0000098654------ I need to Convert to 10 digit Purchase order

First two Alphabetical Must be there I need to remove two Zerosof left side ( After Alphabetical ) .

Is there any Java code for this.