mpearce
06-07-2010, 11:14 AM
I have a file that contains patient data and is in the form of:
____A______ _|_____B______|____I____|
1 | Name ..........|.................. |............. |
2 | Account# ...| admitDate ....|............. |
3 | MedRecord# |................... | Balance ..|
4 | Name2........ |................... |............. |
5 | Account#2 ..| admintDate2...|............. |
6 | MedRecord#2| ...................| Balance2 |
This goes on for 6936 rows. What i need is to covert this format into this
Patient Name_|AccountNumber|AdmissionDate|Balance
1| Name ...... | Account# ......| AdmitDate ...| Balance
2| Name2 .....| Account#2 .....| AdmitDate2 ..| Balance2
Can someone assist me in doing this?
Thanks
____A______ _|_____B______|____I____|
1 | Name ..........|.................. |............. |
2 | Account# ...| admitDate ....|............. |
3 | MedRecord# |................... | Balance ..|
4 | Name2........ |................... |............. |
5 | Account#2 ..| admintDate2...|............. |
6 | MedRecord#2| ...................| Balance2 |
This goes on for 6936 rows. What i need is to covert this format into this
Patient Name_|AccountNumber|AdmissionDate|Balance
1| Name ...... | Account# ......| AdmitDate ...| Balance
2| Name2 .....| Account#2 .....| AdmitDate2 ..| Balance2
Can someone assist me in doing this?
Thanks