Trim functionality failure
Posted: Fri Oct 26, 2007 4:21 am
Hi all,
I have the Decimal(38,10) data an i am loading it to the another DB table as a Vatchar2(25). when i run the job data gets loaded with the added leading zeros.
If data is '6.50',then......'000000000000000000000006'(23zeros)
For 57.98............'0000000000000000000000057'(22 zeros)
if data is a absolute value say '6'...then it will get loaded as '000000000000000000000000'(24 zeros) ..No data at all.
i tried with the trim function:
Trim(column_name,"0","L")....it doen't work.
Trim(column_name,"0","T")....it doen't work.
Trim(column_name,"0","B")....it doen't work
Trim(column_name,"0","A")....work well
Trim(column_name,"0","R")....work well
how could is this possible,some functions work well and some wont work at all.
I tried with funtions like:
Decimaltostring(Column_name,Fixzero)
Decimaltostring(Column_name,suppress_zero)
Decimaltostring(Column_name,Fixzero,suppress_zero)
i searched the forum about leading zeros but didn't find the suitable solution thats why opened a new thread.
I have the Decimal(38,10) data an i am loading it to the another DB table as a Vatchar2(25). when i run the job data gets loaded with the added leading zeros.
If data is '6.50',then......'000000000000000000000006'(23zeros)
For 57.98............'0000000000000000000000057'(22 zeros)
if data is a absolute value say '6'...then it will get loaded as '000000000000000000000000'(24 zeros) ..No data at all.
i tried with the trim function:
Trim(column_name,"0","L")....it doen't work.
Trim(column_name,"0","T")....it doen't work.
Trim(column_name,"0","B")....it doen't work
Trim(column_name,"0","A")....work well
Trim(column_name,"0","R")....work well
how could is this possible,some functions work well and some wont work at all.
I tried with funtions like:
Decimaltostring(Column_name,Fixzero)
Decimaltostring(Column_name,suppress_zero)
Decimaltostring(Column_name,Fixzero,suppress_zero)
i searched the forum about leading zeros but didn't find the suitable solution thats why opened a new thread.