replace . with -

srinath51 · Post by **srinath51** » Thu Mar 01, 2012 1:04 pm

Hi All,

i am having one of the column named in a Sql table named - 'ITEM_R(Numeric (5,0)).there are 2 values for this column i.e; 3,131 & 5,243

Now when i pull this column in the Data-stage Extract and see the data then i see the following values i.e; 03131. & 05243.

so my req was to replace the . at the end with -i.e; 03131- & 05243-

srinath51 · Post by **srinath51** » Thu Mar 01, 2012 2:02 pm

i got it fixed...

used the convert Function...
Here is the syntax :

Convert(".","-",READ_Data.ITEM_R):

ray.wurlod · Post by **ray.wurlod** » Thu Mar 01, 2012 2:53 pm

You've changed the meaning of your data.

A "." at the end means a decimal data type with 0 decimal places.
A "-" at the end means an integer with a value less than zero.

qt_ky · Post by **qt_ky** » Thu Mar 01, 2012 7:22 pm

At least the column is not named "DATA"...

prakashdasika · Post by **prakashdasika** » Mon Mar 05, 2012 9:30 pm

Since the actual column in the sql table does not have a decimal, import the field as integer instead of decimal (which is the default for all numeric datatypes). No need to use covert function.