FMT function only for server jobs?

[poornimasai]

We were trying to get some variable length values prefixed with zeros to get a fixed length. Came across this function FMT , is it only for a server job? Doesn't show as an available function in a parallel job.

Appreciate any help..

[anbu]

FMT function is not available in parallel transformer. You can use it in BASIC transformer.

You can use Right function.

For example if you want to format input to 3 char, you can try this.

Code: Select all

x="8"
y=Right("000":x,3)