Complex text file into ms access

[adamdaban]

I just Want to say Thanks so much for your effort and helping me as much...........

[ADezii]

I just Want to say Thanks so much for your effort and helping me as much...........

That's why we are all here.

[ADezii]

@NeoPa:
Thanks for having a look at this. Here is the Upgraded Version.

[adamdaban]

Dear One last question hope you don't mind, is that posible we can get result like this for example:
SNO RBC ID
---- --- ---
27987 3.4 398774

not like this
test
----
ID
SNO
Test

[ADezii]

1. Are you filtering for the SNO and RBC Tests only?
2. If this is the case, according to the *.txt File SNO has a static Value of 26052 whereas RBC has multiple Values as the Data indicates below.
   

   Test	Results
   RBC	250, 80, 2, 9
   RBC	4.34, 3.50, 5.50
   RBC	250, 80, 2, 10
   RBC	5.80, 3.50, 5.50
   RBC	250, 80, 2, 10
   RBC	5.33, 3.50, 5.50
   RBC	250, 80, 2, 10
   RBC	4.35, 3.50, 5.50
   RBC	250, 80, 2, 10
   RBC	4.58, 3.50, 5.50
   RBC	250, 80, 2, 9
   RBC	5.38, 3.50, 5.50
   RBC	250, 80, 2, 6
   RBC	3.59, 3.50, 5.50
   RBC	250, 80, 2, 7
   RBC	4.40, 3.50, 5.50
   RBC	250, 80, 2, 10
   RBC	4.61, 3.50, 5.50
   RBC	250, 80, 2, 10
   RBC	0.00, 3.50, 5.50
   RBC	250, 80, 2, 9
   RBC	4.23, 3.50, 5.50
   RBC	250, 80, 2, 10
   RBC	4.85, 3.50, 5.50
   RBC	250, 80, 2, 10

3. Need further clarification.

[adamdaban]

dear I want result like this
ID SNO RBC
---- ---- -----
value value value


not like
Test Result
---- -------
ID value
SNO value
RBC value

--------
if you can do it these 3 I will check your code and I will complete rest of them

[ADezii]

Kindly do not refer to me as dear, it is not appreciated, and besides I am a male. That being said, it appears as though you want the Data Transposed from its current format. Will you always be filtering for SNO and RBC?

[adamdaban]

Sorry for I using this word! Actually, I need to get some of them but I don't want to make you tired when I get Idea from you I will do it another part
ID Date WBC LYM MID GRAN LYM MID GRA RBC HGB
--- --- --- --- --- ---- --- --- -- -- ---

[ADezii]

Finally, I think I have a clearer understanding of what you are looking for. Unfortunately, this makes a solution more complicated since the Date component now needs to be extracted and the Unique Test Names now have to be Columns (Fields) in a Table. I need to regroup and figure out how to deal with this, may be a little while.

[ADezii]

1. Sorry, but I cannot proceed any further unless I know the exact meaning/significance of the following Tag Pairs:
   

   <sample></sample>
   <instrinfo></instrinfo>
   <smpinfo></smpinfo>
   <smpresults></smpresults>
   <tparams></tparams>
   <hgrams></hgrams>
   <hgram></hgram>
   <hgdata></hgdata>

2. I also need to know how the Date/Time Stamps factors into the Data. It appears that all Tests within the <sample></sample> Tags apply to the Date within these Tags also, but I am not sure.
   

   <n>DATE</n><v>2017-08-08T08:32:43</v></p>

3. Without this specific information, I'm afraid that I am dead in the water!

P.S. - You need to speak to the individual(s) who are responsible for generating the Text File.

[adamdaban]

yes ADezii I want to like this if you check my picture
about Date is not important because I use the default date=date()
[IMGNOTHUMB]https://bytes.com/attachments/attachment/9251d1504975047/1.jpg[/IMGNOTHUMB]
yes that's I want it's true it's complicated but I believe you can figure out. Thanks, I really make you so tired .

[NeoPa]

Hi ADezii.

Please check your PMs for the solution to your problem. Actually, I only identify the problem but it's well within your capabilities to find a solution. I wouldn't insult you by trying to offer one.

All the best -Ade.

[ADezii]

Thanks NeoPa, still learning from you.

[ADezii]

For the life of me I cannot see how the Data depicted in the Graphic is derived from the Text File. The Graphic is very hazy but the Column Headers appear to be Chemical Symbols supposedly representing the presence of these Elements in the Blood Sample. I see no listing of these Elements within the Text File and, to be perfectly honest, I am lost at this point.

[adamdaban]

always this blood test machine give us this result, this machine name is Medonic