Hi,
I have a question about sorting out RS232 Data send from a device in Excel. The data is not live, but is given to me as a txt-file, normally over 20000 lines. At this moment I am using Power Query to import the file and remove the blanc lines. This is not ideal because the data is not always in the same format like shown in the txt-file attached to this question.
I want to split the data to different columns and as far as I can see now I am only intersted in the data belonging to #B, #M, #I and #s. At this moment I am using multiple if-statements to sort out the data to different columns and I am using Power Query again to remove the blancs. After that I am using different macro's to remove the # and the letter and adding a time interval so that I can create some figures.
In my opinion it is much quicker and easier when I can search the original data and pick the output. I can do it with VLOOKUP and LEFT, but is still has a lot of blanc spaces. What I tried but did not succeed so far is searching for one of the datasets of interest and add the output as a new cell to an existing column.
As an example: If I search for #s, the first value of it (#s2 = 2) is the first value of column #s. When I find another #s, that value will be the next value in the column #s.
I hope this question is clear enough to understand and to answer it and I am looking forward to the reactions.
Thanks in advance,
Chris
Bookmarks