Page 2 of 2
Posted: Mon Sep 20, 2010 5:57 am
by PhilHibbs
priyadarshikunal wrote:... however the different rtypes are not really present there. The different options are documented in "Orchestrate Operator Reference" doc.
I don't think I have that, where would I find it? Does it come with a standard 7.5.1 client install?
Posted: Mon Sep 20, 2010 6:02 am
by chulett
No, you have to dig them up on the internet... I think Ray/Arnd may have posted a link to them but not sure it would still be valid.
Posted: Mon Sep 20, 2010 6:57 am
by priyadarshikunal
you may need to contact IBM to get that manual. It was available directly through Ascential's eservice network which doesn't work anymore.
Posted: Sat Nov 13, 2010 12:59 am
by akbar2002
SV1 : StringToDecimal(column_name) --> DataType = VarChar
SV2 : Field(SV1,'.',1) --> DataType = Integer
SV3 : Right(SV1,2) --> DataType = VarChar
Derivation : SV2:'.':SV3 --> DataType = VarChar
Posted: Sat Nov 13, 2010 6:21 pm
by ray.wurlod
Did you mean DecimalToString() ?
Posted: Sat Nov 20, 2010 6:35 am
by akbar2002
Yes, made a typo. Sorry about that
SV1 : DecimalToString(column_name) --> DataType = VarChar
SV2 : Field(SV1,'.',1) --> DataType = Integer
SV3 : Right(SV1,2) --> DataType = VarChar
Derivation : SV2:'.':SV3 --> DataType = VarChar
Posted: Sat Nov 20, 2010 2:53 pm
by raghu22
IF Index(DecimalToString(decimal_input,"fix_zero,suppress_zero"), '.',1)=0 THEN
DecimalToString(decimal_input,"fix_zero,suppress_zero") : '.00' ELSE DecimalToString(decimal_input,"fix_zero,suppress_zero")
Posted: Mon Nov 22, 2010 4:19 am
by naresh_kakarla
I think the Below logic is useful for you
convert(' ','0',(trim(convert('0',' ',Column_Name)))
Note: If u r using above logic then you have to change the column datatype like Char or Varchar
Posted: Sat Dec 11, 2010 9:13 am
by Ravi.K
The derivation surpress both Leading and Trailing zeros. So, Small change to remove leading zeros only as per the post.
convert(' ','0',(TrimF(convert('0',' ',Column_Name)))
Posted: Thu Dec 23, 2010 11:16 pm
by DS_TM
This won't work if we have value lilke -00000.00100.
akbar2002 wrote:Yes, made a typo. Sorry about that
SV1 : DecimalToString(column_name) --> DataType = VarChar
SV2 : Field(SV1,'.',1) --> DataType = Integer
SV3 : Right(SV1,2) --> DataType = VarChar
Derivation : SV2:'.':SV3 --> DataType = VarChar
Posted: Tue Feb 16, 2016 8:50 am
by battaliou
I know this is an old post, but our solution is to change the input datatype from a decimal to a varchar
Posted: Tue Feb 16, 2016 9:18 am
by chulett
True... and mentioned as the solution in the very first reply as well.