Parsing data from a multi-sections text file

[emmanuel_varesio]

Hi there,

I'm trying to parse a unique text file (INPUT) with different repetitive sections containing info/data that I would like to parse and re-arrange as explained below:

- pattern A is a regexp to parse a name from the line (orange)

- pattern B is to remove empty lines 

- pattern C is to extract the textual data and convert it to columns (tabs as delimiters) - green

- pattern D is to convert the first row of each pattern C output as unique column names in the output (blue)

The OUTPUT should contain the data as column with their field name + the first column from pattern A output

I've attached the input text file used as example.

Thanks in advance for your help.

Best regards,

Emmanuel

[binu_acs · Accepted solution]

@emmanuel_varesio One way of doing this

[emmanuel_varesio · Accepted solution]

@binu_acs  Thansk a lot. Seems so simple when you see the solution.