Filtering Data from Text files into a table.

[hraym2004]

Hi, I am trying to filter 'string in' so the information will be separated into a table (1D array). So in this string MESSAGE will be in its own column, time will be in its own, date as well and then the rest of the information in the final column. 

Does anyone know how to do this ?

Kind regards 

Hraym

[GerdW · Accepted solution]

Hi hraym,

---

@hraym2004 wrote:

Hi, I am trying to filter 'string in' so the information will be separated into a table (1D array). So in this string MESSAGE will be in its own column, time will be in its own, date as well and then the rest of the information in the final column. 

---

You can use SpreadsheetStringToArray to separate the substrings by the Tab delimiter.

When time and date should be located in their own columns then you need to split them at the SPACE delimiter…

You can also hard-code your requirement:

[hraym2004]

Thank you for the response,

Would you be able to make the code yourself and show me. I am still new to Labview so still trying to wrap my head round certain stuff.

Kind regards,

Hraym

[altenbach]

Let's assume that your string display is set to \-codes. Is it?

What are the fields you want? Are the delimiters all tabs or is there a mix of tabs and spaces?

Typically :"spreadsheet string to array" might do what you want. <tab> is the default delimiter.

[hraym2004]

Morning,

I have tried to do this myself now but keep getting stuck.

I need to filter all the text files from the folder into a table where the data is split up. So Status/Message in first column, date and time in second, then any further information in the third column.

I need a row in the table for each line in the text file.

The end goal is to use the time and dates to work out the elapsed time that this machine was running for each day so I will have to change the date and time into Labview times as well and do the calculation.  

Does anyone know how to code a program to achieve this ?

Kind regards,

Hraym

[hraym2004]

Sorry I did not realise the text files were not attached. 

Please find attached 2 text files. There is more than these 2, but these will be enough to give you an idea of how they are formatted

Kind regards,

Hraym

[Andrey_Dmitriev · Accepted solution]

In general something like this should work for your particular data, because they already tab-delimited: