Xfm,0: Numeric string expected for returned value from funct

[Kshitij Rawat]

When I used TrimLeadingTrailing function for any any nullable column like TrimLeadingTrailing(toXfm.Employee_discripion) I got the below message.

"Xfm,0: Numeric string expected for returned value from function call 'substring_1'. Use default value."

This is not a warning message but why I am getting this?

Or please tell me where I should use TrimLeadingTrailing.TrimF,TrimB,Trim functions ?
Most of the time when column is nullable this is my approach in transformer

If TrimLeadingTrailing(toXfm.Employee_discripion)='' Then SetNull() Else TrimLeadingTrailing(toXfm.Employee_discripion).
This ok for you or should I need to change.

Thanks.
[/b]

[priyadarshikunal]

When I used TrimLeadingTrailing function for any any nullable column like TrimLeadingTrailing(toXfm.Employee_discripion) I got the below message.

"Xfm,0: Numeric string expected for returned value from function call 'substring_1'. Use default value."

This is not a warning message but why I am getting this?

Or please tell me where I should use TrimLeadingTrailing.TrimF,TrimB,Trim functions ?
Most of the time when column is nullable this is my approach in transformer

If TrimLeadingTrailing(toXfm.Employee_discripion)='' Then SetNull() Else TrimLeadingTrailing(toXfm.Employee_discripion).
This ok for you or should I need to change.

Thanks.
[/b]

this message comes when the value passed by you in transformer is not appropriate
e.g. in transformer if you try to pass empty character or space to a numeric field it will be replaced by 0 by default

this results in to the message you got

the best way is to perform a comparison between source and target
and analyze the values that are replaced by 0 for string its null.

i think this will resolve your problem

Regards,

[Kshitij Rawat]

But if i used Trim function definitely it will remove space or any unwanted value so why I am getting this message?

[ArndW]

Your problem is not in the trim() you posted. It is somewhere else where you are performing a numeric operation on a value that is not numeric.

[AmeyJoshi14]

You can use ISNotNull() function in transformer....
So your code will be like this...

Code: Select all

IF
IsNotNull(toXfm.Employee_discripion)
THEN
TrimLeadingTrailing(toXfm.Employee_discripion)
ELSE
SetNull()

This will remove the message...

[ray.wurlod]

Trim... functions can only be applied to string data types. They can not be applied to numeric data types.

[Kshitij Rawat]

Thanks all.

[rajkraj]

How,was this resolved.

Thanks