Can we do this transformation in datastage

[sigma]

The attached data file contains 3 columns in comma delimited format.

ENTITY
ACCOUNT number
AMOUNT

Take this file as input prepare the following output
ENTITY column value to be replaced by constant PC_SL_US.
ACCOUNT number column data within itself is delimited by a period and can have a maximum structure of X.Y.Z
This need to be parsed and put into more than one column (upto 3 different columns) . If only one value is present the next two columns should be blank and so on.
AMOUNT column take the input amount and output with only 2 decimal places . input can have more decimals .

The final output would be

ENTITY ( fill with constant PC_SL_US)
ACCOUNT NUMBER
BUSINESS UNIT
FUNCTIONAL AREA
AMOUNT
PERIOD (fill with constant 001/2009.

Column 2,3,4 is a split of input column 2 based on the period within the column. If input contains only account number 3 and 4 are blank or if input contains account number , business unit then 4 is blank or if input contains account number.business unit.functional area then all 2,3,4 are filled with values

Is transformer my best solution for doing this

[girija]

Yes you can.

[ray.wurlod]

Field() functions for the parsing and If..Then..Else to test for "blank".