Column Export Formatting

kld05 · Post by **kld05** » Thu Mar 27, 2008 4:53 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 27, 2008 6:01 pm

Code: Select all

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