Skip to Content
0

Leading zero, But 'n' Number of times (No Lpad)

Jan 27, 2017 at 03:19 AM

40

avatar image
Mohan M S

Hi,

Lpad( 'ABC',6,'0') will give me the output

'000ABC'

What if '6' is dynamic (n number of times)? How to do it? Lpad can take only constant value.

Please help!!

SAP Data Services
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
avatar image
Ravi kiran Pagidi Answered Jan 27, 2017 at 08:10 AM
0

Hi Mohan,

in what cases that 6 will be changed..? so that we can try this using a variable in the place of 6 i guess.

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users