Dia duit gach duine!
For a research project I need to combine continuous data measured at the OR with own data. The electronic patient system can give me an exportfile as added to this post. The extraction from relevant data is not handy at all. I tried several things to make the data a bit more structured but I didn't succed. I installed Kutools to delete al the non-printing characters and completed the 'Text to columns' wizard, yet the problem is that the content of each cell is different. e.g. one cell has temperature as last variable, and the following cell has heartrate as last variable.
Ceist: Is there a way to split the data in the cell to various columns to the right, in such a way that values are sorted? First after " is the variable name, followed by the value.
Go raibh míle maith agat as do chuid ama.
For a research project I need to combine continuous data measured at the OR with own data. The electronic patient system can give me an exportfile as added to this post. The extraction from relevant data is not handy at all. I tried several things to make the data a bit more structured but I didn't succed. I installed Kutools to delete al the non-printing characters and completed the 'Text to columns' wizard, yet the problem is that the content of each cell is different. e.g. one cell has temperature as last variable, and the following cell has heartrate as last variable.
Ceist: Is there a way to split the data in the cell to various columns to the right, in such a way that values are sorted? First after " is the variable name, followed by the value.
Go raibh míle maith agat as do chuid ama.