cancel
Showing results for 
Search instead for 
Did you mean: 

Eliminating Leading zero's while master data load

former_member211812
Participant
0 Kudos

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

View Entire Topic
former_member186338
Active Contributor
0 Kudos

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.