Originally posted by: SystemAdmin

The specs require to send me the first three characters of an element excluding any zeros...how do i get this?
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: john.gibby

TRIMLEFT(objectname,"0")
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: janhess

Is the element text or number? If text use left(element,3). Using TRIMLEFT(element,0) will remove the leading 0s.
If the 0s are missing you could use FILLLEFT ( element , '0' , 3).
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

My actual requirement goes as :

Send The First 3 Characters Of G3916 Excluding Any Zero. If The Value Is Blank Or All Zeros; Then Send 1

and the field is a number field
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: NancyR

=IF( ABSENT(value ) | value=0,
1,
TRIMLEFT( LEFT( TEXT( value ), 3 ), "0" ) )
If value is absent or 0,
map 1,
ELSE
convert the number to text, take the first three characters and remove any zeroes
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

WHATS WRONG IN THIS LOGIC ?

=IF(ABSENT(VALUE) |VALUE =0,1 ,
TEXTTONUMBER(
MID (
TRIMLEFT(
NUMBERTOTEXT(VALUE)
,"0")
,1,3)
))
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: NancyR

Why do you think it's wrong? Your MID function should give the same result as LEFT. Also, I did leave off the final TEXTTONUMBER.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender