Hi All,
I am reading from an IO.port and returning the data to a string. I need to parse this to data rows that each represent a data record which I will add to a datagridview.
The data basically looks like this. I have inserted <SOH>,<US>, etc. for readability.
The first line is the identification from the equipmentCode:<SOH>EM709<US>17946<US>1114<US>62<STX>T<US>12345<US>201106130335<US>01<US>C67FCBC67FBCB7BCCBC6CB7FD0CB7FBCBCBCC6CB<US>2D<RS>T<US>654321<US>201106130441<US>01<US>9E7F999E7F9EB2ADADB2947F94947F99ADA8A39E<US>07<RS>T<US>420689836<US>201106130508<US>01<US>947F99947F8F9EA8ADB2947F99947F94BCADB7C1<US>05<RS>T<US>123456<US>201106130522<US>01<US>9E7FA39E7F9E99ADBCB7947FA3947F9E94999E9E<US>B4<RS>T<US>765432<US>201106130539<US>01<US>947F99947F9EA3B7B2B78F7F998F7FA3BCB2BCAD<US>1B<RS>T<US>420863802<US>201106130550<US>01<US>9E7F999E7F9499B2ADA8997F99997F99B7B7A899<US>EF<RS>T<US>234567<US>201106130555<US>01<US>9E7F997F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F7F<US>5D<RS>T<US>876543<US>201106130607<US>01<US>947F99947F9EB7B7B7B7947F94947F9EC1C1BCC1<US>DC<EOT>
<SOH>EM709<US>17946<US>1114<US>62<STX>
Then each data row will be
<RS>T<US>12345<US>201106130335<US>01<US>C67FCBC67FBCB7BCCBC6CB7FD0CB7FBCBCBCC6CB<US>2D
T=Test
<US>12345<US> = Person ID
<US>201106130335<US> = Date and 24hour time
<US>01<US> = Technician ID
<US>C67FCBC67FBCB7BCCBC6CB7FD0CB7FBCBCBCC6CB<US> = Hearing Results
<US>2D<RS>=Impedance
<RS> is the Record Separator
End result is I want to have a row like T|12345|201106130335|01|C67FCBC67FBCB7BCCBC6CB7FD0CB7FBCBCBCC6CB|2D
I have searched on how to do this and apparently I am not putting in the correct keywords to show an example of what is needed. Help will be appreciated.




Reply With Quote