I have some data in multiple text files where fields are separated by blank lines. There are only 4 fields but in the second field there are more subfields, could be three or more. The first field is always a number, 0 or 1.
0
name_surname
1 yellow 1 brown 2 green
short description
every file is made in the same way. The problem is I could have more or less colours in the third field.
Every txt should become a row in a csv file
0 [tab] name_surname [tab] 1 yellow ; 1 brown; 2 green [tab] "description"
1 [tab] name2_surname [tab] 1 brown; 1 blue [tab] "description"
After some reading I've found I should use awk in some way, but this is beyond what I can do.