<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><DIV>I am not really a CS person, but I have a task to import a non-delimited text to an access database. After some research, I *think* the best way to do this is by first converting the non-delimited text to delimited text, and then import it to the database. Is this the best way to approach this? Or is there easier way?</DIV>
<DIV> </DIV>
<DIV>Example:</DIV>
<DIV>---------------------------------------------------------------------------</DIV>
<DIV><SPAN lang=EN>
<P>Test , BTS</P>
<P>0800000532</P>
<P>05/MAY/1945 00:00</P>
<P>Female</P>
<P>858327</P>
<P>AB Pos</P>
<P>�</P>
<P><START_TR></P>
<P>CMV Neg Req'd</P>
<P>IgA Deficient</P>
<P><STOP_TR></P>
<P><START_AB></P>
<P><STOP_AB></P>
<P><START_AG></P>
<P>Wr(a+)</P>
<P>S-</P>
<P><STOP_AG></P>
<P><START_COM></P>
<P>>> OCT/23/07 08:18:00 TRETHEWEYD >>>>>>>>>>>>>>>>> Please fax to:</P>
<P>>> OCT/22/07 09:37:00 [COMBINE] [Combine from person_id 924598 to person_id 858327]</P>
<P>[Following comments for to person_id 924598]</P>
<P>>> OCT/18/07 15:53:00 TRETHEWEYD 2007/10/18 15:52</P>
<P><STOP_COM></P>
<P>-----------------------------------------------------------------------------------</P>
<P>Basically there are 2 portions to this. The first portion consist of 7 lines (Full Name, Medical record number, birth date, gender, internal ID, blood group, phenotype). The second portion list the different list of requirements, denote by <start> and <stop>. In the sample shown above, the patient do not have information on phenotype, thus there is the <SPAN lang=EN>� symbol. </SPAN></P>
<P><SPAN lang=EN></SPAN> </P>
<P><SPAN lang=EN>I am really stump on where to go from here. Any help would be appreciated it. I have also include a text file which gives several more examples.</SPAN></P>
<P><SPAN lang=EN></SPAN> </P>
<P><SPAN lang=EN>Thanks so much!</SPAN></P>
<P><SPAN lang=EN></SPAN> </P>
<P><SPAN lang=EN> </P></SPAN></SPAN></DIV></div><br>
<hr size=1>
Looking for the perfect gift?<a href="http://www.flickr.com/gift/"><b> Give the gift of Flickr!</b></a></body></html>