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..
FMT function only for server jobs?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Mon Aug 02, 2010 2:38 pm
FMT function only for server jobs?
I am what I am, even when I am not myself.
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.
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)
You are the creator of your destiny - Swami Vivekananda