hi, I have a text file that has user submitted data in the following format:
basically all the lines have some data that are separated by semicolon so that I can import them into Excel. However, it turns out that some of the lines are of the following format:
i.e. there can be multiple blank lines in between the 'components' of line x.
I want a perl script that reads the file and combines the 'components' of lines that resemble line x to what lines 1, 2 and 3 look like. i.e.
so at the end, my file should look like following: