Hi,
You can check the field function to do the functinality , to get the different values for the Column.
Reading text files
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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