DSXchange

You know which one I mean.

Why don't you give it a try by making your output as Varchar(6) ?

Then call it Varchar(6)

Is it fixed width or delimited output?

Then join with a row generator to get a cartesian product.

This can be used in substring later.

Search for decimalToString

Then surely it must have a max length.

Can do something like
endOfMonthDate = YYYY + INT(MM / 12) : MOD(MM, 12) + 1 : 01 - 1

Best write a unix script and stick it in the sequencer command stage.

Have you tried awk script?

Can you unregister and re-register the stage from manager?

What is the size of the input column? Or is it unbounded ? It it from seq file or some other source? Who provides it to you? If you know the max length, you can split the rows in a transformer and gather with a funnel. Seq file can be resolved using awk script in source. Others will need buildOp.

Maybe you can change the record delimiter to different value in the source.

Your questions appear unconnected.

Are they for any interview ?