Compiling error on Transform stage using TRIM with L option

Salegueule · Post by **Salegueule** » Mon Oct 23, 2006 4:08 pm

Hi,

Having an error compiling a transform stage susing the following:

CompactWhiteSpace(Trim(TPRTNLOC_01.STREET_NUMBER,"0","L"):" ": TPRTNLOC_01.STREET_NUMBER_SUFF:" ": TPRTNLOC_01.SUITE_NUMBER:" ": TPRTNLOC_01.STREET_NAME:" ": TPRTNLOC_01.STREET_DIRECTION:" ": TPRTNLOC_01.RURAL_ROUTE_NUMBER)

Problem is caused by the TRIM function. Without it it, the job compiles and run fine. Am I using the right format for the TRIM character and option? I have try a couple of combination and the one above seems the only one accepted by DS.

Thanks.

ray.wurlod · Post by **ray.wurlod** » Mon Oct 23, 2006 4:16 pm

Try putting the Trim(TPRTNLOC_01.STREET_NUMBER,"0","L") into a stage variable, and replacing that part of the expression with a reference to the stage variable.

kumar_s · Post by **kumar_s** » Mon Oct 23, 2006 7:13 pm

That is ok to remove all the leading 0's from STREET_NUMBER. If have any warning, post it.