Separate information of files by columns

[Mocte117]

Hello everyone,

I have a slightly peculiar question, I need to have in a listbox the information of two different files separated by month, that is, if today we are in the month of June, the list must show the information of the files that correspond to June. So there are two types, the first is the material list, and the second is the Batch list. In addition, a combobox or ring where you can select a month, and based on that, display the information corresponding to that month.

The material list looks like this: 

And the batch list looks like this:

Assuming that we are in February, it should be like this:

So my question is, how to separate the information by month, I adapt it to each column and select the month to see this information?

[raphschru · Accepted solution]

Hi,

Here are some hints to get you started:

1. This loads string values from a tab-separated text file:

2. This gets the month index from a date formatted as a string:

3. This writes the elements displayed in the Multicolumn Listbox:

In between, you will have to use basic functions such as Index Array, Format Into String, Build Path, Delete From Array, and maybe a For Loop…

Regards,

Raphaël.