trimming of decimals

[datastagedw]

hello everyone,

i have a decimal field and i need to make sure that it does not contain any spaces anywhere. i tried to directly use trim function on this field but as i know its giving compiling problems.so in the transformer i have taken a stage variable

sv=col1
and this sv is of course varchar and then i used the trim function
trim(sv," ","A"). this is working and removing the spaces anywhere they are but i have to check the nullability also. i mean i have to use if condition, something like this:

If IsNull(trim(sv," ","A")) then "null" else "abc".

when i try to compile this it throws errors. Does IsNull function not work on a trimmed field??

the output field would be varchar.

please someone help.

[ArndW]

What error does it "throw" at compile time?

Also, check for NULL before doing any computations on the field.

[jhmckeever]

Decimal fields can't contain spaces - so I'm assuming you're talking about a string field containing string representations of decimal values?

I think your logic would be better expressed as:

Code: Select all

if trim(sv," ","A") = "" then "null" else "abc"

... as trimming a nullable string to empty does not make it null.

J.

PS. I hope 'sv' isn't your REAL stage variable name!

[srimitta]

Trim function doesn't work in conjuction with IsNull.

Try StripWhiteSpace(%string%), if you want to just strip off spaces in the string.

[Nripendra Chand]

if input is of decimal type field then string functions can't be used.