Page 1 of 1
Posted: Wed Jul 09, 2003 3:58 am
by raviyn
Hi,
You can check the field function to do the functinality , to get the different values for the Column.
Posted: Wed Jul 09, 2003 6:26 am
by ray.wurlod
If that's all the data in your text file, you could define the Format in the Sequential File stage to be delimited by ";". Now you will be seeing two columns. Import the "table definition" from the Sequential File and specify that it is delimited by ";".
If, on the other hand, vikas;735 is just one column among others in the text file, then you use a Transformer stage to generate two output columns. Assume that the input column is called Field005. Then the derivations for the two output columns could be:
Field(InputLink.Field005,";",1,1)
Field(InputLink.Field005,";",2,1)
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518