Writing to Fixed width file

parsi_cnu · Post by **parsi_cnu** » Mon Apr 28, 2008 6:32 pm

When i am writing a numeric field the data is preceded with blank and the actual value

eg:actual value1000.00 and data showing in the file as ' 1000.00'. there is a blank infront of 1 and im not able to trim this.

how to handle this?

Thanks
sri

just4u_sharath · Post by **just4u_sharath** » Mon Apr 28, 2008 6:42 pm

trim(col_name,' ','A')
try this

parsi_cnu · Post by **parsi_cnu** » Mon Apr 28, 2008 7:03 pm

actually i am dividing numeric column/10

source numeric column(length 7)/10 and target numeric column of length 6,2

just4u_sharath · Post by **just4u_sharath** » Mon Apr 28, 2008 7:05 pm

try this

TRIM(TRIM(COL_NAME,CHAR(10)),CHAR(13))

ray.wurlod · Post by **ray.wurlod** » Mon Apr 28, 2008 7:09 pm

The space is the sign character. You could specify the Numeric data type to be unsigned.

parsi_cnu · Post by **parsi_cnu** » Mon Apr 28, 2008 7:23 pm

How can we do?

thanks
sr

DSXchange

Writing to Fixed width file

Writing to Fixed width file

trim(col_name,' ','A')

Actually i am calculating field in the transformer

Len(Trim(numeric_col))