Number of lines is different from what the txt file actually contains

[mlauber71]

@Aldemir there seem to be several tables in the file. You might have to identify the blocks and then read them skipping lines you do not need.

Something like this:

Extrakt two variables from .txt files in a folder and combine with a third variable (time) given in the file name

It sounds like you have three elements to consider the file name (you can extract that by using a list file node (and manipulate it later) the ‘header’ if indeed you file contains the information you mentioned above. The question is: can you separate the header lines from the rest of the data by splitting the file in half. You would initially load the file with File Reader as one single line, drop the data and split the header lines by “:” to get the data into columns the data itself. You woul…

Extrakt two variables from .txt files in a folder and combine with a third variable (time) given in the file name

Here’s my approach:

Import of strange csv data

@carllum26 i don’t think you will be able to just import this data with a CSV reader. You very likely will have to import the data as a whole line and then do some splits and joins. The good news is that the data always seem to have the same structure so this should not be too complicated a task. I will see if I can come up with something. It might be something like this Or this

How to arrange this

I toyed around with the example a little bit and came up with the following solution. Which is: Import the Text file as one large column width: 500 convert the column into JSON manually define JSON paths for each column (or see if the default setting does the trick) remove the “column*” columns export the resulting data with headers I now have a few empty lines but maybe that was the case if not they could be removed. If data is missing it could be feasible to expand the width. Then if you …

A sample file and an example of an expected result might help.