Eliminating Leading zero's while master data load

[former_member211812]

Dear Floks,

After long time i am performing master data load activity.

i want to eliminate leading zeros from the ID. But the leading zeros are not constant.

Below is the transformation.

ID=*IF(ID=*STR() THEN *STR(BLANK);ID)

Conversion

External Internal

*????? ?????

Ex:- I have a ID

00000001

00000011

00000111

00001111

00011111

Like this i want to eliminate leading zeros

INFO-OBJECT

info2.jpg

TRANFORMATION

trans2.jpg

CONVERSION

conver2.jpg

[former_member186338]

DM prompt will ask you to load using internal or external format. Try with external.

Also you can always use in-line Javascript in conversion to perform any string manipulations.

[bhavinvyas]

Please check if ALPHA conversation at infoobject level works here.

Thanks,

Bhavin