Page 1 of 1

Column Export Formatting

Posted: Thu Mar 27, 2008 4:53 pm
by kld05
I'm dealing with a fixed width file that is passing decimals as 000100.100. I'm using an upstream trim to remove the leading and tailing zero's to output 100.1. When I pass this column as an exported column the format is going back to 000100.100. How can I preserve the 100.1 value in the column export stage? I'm using Varchar export type for this.

Posted: Thu Mar 27, 2008 6:01 pm
by ray.wurlod

Code: Select all

Trim(TheString, "0", "R")