Hi All,

Am new to XSLT and trying to write some xslt which is having 1st record as the header,2nd record as the status and 3rd records as the trainings and all these 3 records can be occured n numbers of time, we want that fixed length file need to be converted into xml file, below is the simple input and out file should look like.


Sample Input is :

H123
S111SE
Tjavaasp
H231
S112SA
Tjavaaix

Output should be like below with above Input :

-<Information>
- <organization>
<id>123</id>
- <employee-status>
<employee-id>111</employee-id>
<employee-designation>SE</employee-designation>
</employee-status>
- <employee-trainings>
<employee-training1>java</employee-training1>
<employee-training2>asp</employee-training2>
</employee-trainings>
</organization>
- <organization>
<id>231</id>
- <employee-status>
<employee-id>112</employee-id>
<employee-designation>SA</employee-designation>
</employee-status>
- <employee-trainings>
<employee-training1>java</employee-training1>
<employee-training2>aix</employee-training2>
</employee-trainings>
</organization>
</Information>


In the above example we can distungish between record with first character of each record. I have tried but not able to getting the perfect logic.

Can any one plese help on getting this done. as this is urgent requirement for me.