What is the equivalent function in parallel for 'Fmt'

vcsasikala · Post by **vcsasikala** » Wed Oct 17, 2007 5:16 am

I'm converting a server job to Parellel job.
I don't know how to replace a function Fmt(Column,"11RZ").
How to Suppress leading zeros in parallel job?

ArndW · Post by **ArndW** » Wed Oct 17, 2007 5:27 am

Although there is no equivalent PX/EE function for the BASIC "FMT" there is usually no need to use one. PX will perform automated input conversions. Do you need to perform a specific output conversion?

Maveric · Post by **Maveric** » Wed Oct 17, 2007 5:27 am

"How to Suppress leading zeros in parallel job?". What is the data type of your source? If it is varchar then use Trim (Input.col,"0","L"). This would trim the leading zeros only.