hi guys,
I need to write out numbers to a sequential file with commas.
eg:
input -> 1000000
output -> 1,000,000
Is there any function in transformer that I can use?
thank you,
aggie
formatting a number
Moderators: chulett, rschirm, roy
You'll definitely need to define the output as string. The "something like FMT()" part is not quite so easy since "they" decided not to create a parallel function equivalent to the BASIC function.
If you have a small number of these to do, you could brute force it with DecimalToString, substring, and concatenation.
If you have a large number of these, you may want to consider creating a custom parallel routine.
Mike
If you have a small number of these to do, you could brute force it with DecimalToString, substring, and concatenation.
If you have a large number of these, you may want to consider creating a custom parallel routine.
Mike
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: