remove leading zeros in decimal field in sequential file

PhilHibbs · Post by **PhilHibbs** » Mon Sep 20, 2010 5:57 am

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?

chulett · Post by **chulett** » Mon Sep 20, 2010 6:02 am

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.

priyadarshikunal · Post by **priyadarshikunal** » Mon Sep 20, 2010 6:57 am

you may need to contact IBM to get that manual. It was available directly through Ascential's eservice network which doesn't work anymore.

akbar2002 · Post by **akbar2002** » Sat Nov 13, 2010 12:59 am

SV1 : StringToDecimal(column_name) --> DataType = VarChar
SV2 : Field(SV1,'.',1) --> DataType = Integer
SV3 : Right(SV1,2) --> DataType = VarChar

Derivation : SV2:'.':SV3 --> DataType = VarChar

ray.wurlod · Post by **ray.wurlod** » Sat Nov 13, 2010 6:21 pm

Did you mean DecimalToString() ?

akbar2002 · Post by **akbar2002** » Sat Nov 20, 2010 6:35 am

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

raghu22 · Post by **raghu22** » Sat Nov 20, 2010 2:53 pm

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")

naresh_kakarla · Post by **naresh_kakarla** » Mon Nov 22, 2010 4:19 am

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

Ravi.K · Post by **Ravi.K** » Sat Dec 11, 2010 9:13 am

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)))

DS_TM · Post by **DS_TM** » Thu Dec 23, 2010 11:16 pm

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

battaliou · Post by **battaliou** » Tue Feb 16, 2016 8:50 am

I know this is an old post, but our solution is to change the input datatype from a decimal to a varchar

chulett · Post by **chulett** » Tue Feb 16, 2016 9:18 am

True... and mentioned as the solution in the very first reply as well.