Text File via Putty into Access
Posted on 2014-01-13
The following is what I get from a text file from Putty. =~=~=~=~=~=~=~=~=~=~=~= PuTTY log 2014.01.09 16:14:44 =~=~=~=~=~=~=~=~=~=~=~=
DRDmodel/RTT-1133NO56899DAJAN/09/2014.16:54VD12.00WD35OL-01.00-01.75087DKM L07.5907.3803507.49 R07.9707.3014407.64DNT L01 20/2.7*2AV20.0/2.70 R02 20/2.7 23/3.1*2 AV21.5/2.9027ADDRDmodel/RTT-1133NO56900DAJAN/09/2014.17:17VD12.00WD35OL+00.75-00.25004OR+01.25-00.00000PD59??????DKM L07.5407.4700307.51 R07.5807.5517307.57DNT L02 15/2.0 18/2.4*2AV16.5/2.20 R01 15/2.0*3 AV15.0/2.002D8F
What I need to do is get this information into a table, query or on the "clipboard" with access to copy them to fields. For example the line "OL-01.00-01.75087DKM L07.5907.3803507.49 " needs to be separated into "L" for left, 01.00 one field, 01.75 into another field, 087 into another field, 07.59 into one field, 0738 into another field, etc.
The process which occurs is the I open putty (or another terminal program), the device print the results on screen and I have them logged into a file via putty. What I need to do is get them into access and copy them to specific fields of a form. I can do the pushing them to a form once they are in access. However, my issue is that I am not sure of how to get the text document sepated and into access.