formatting a number

[Aggie99]

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

[chulett]

You'll need to define the output field as a string, then use something like FMT() to get what you want. There are other ways, I'm sure, but that's the first that comes to mind.

[Mike]

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

[chulett]

FMT() doesn't work in a parallel job? That's too darn bad.

[ray.wurlod]

But you CAN use Fmt() in a BASIC Transformer stage.