I´d like to convert a text file to csv, but I need some help please.
Source is a text file with software license codes (whicht I bought over several years),
target should be a CSV file.
each record is divided by an empty line,
first line contains name of the software,
followed by (1…x) lines with license information.
License name: John Doe
Licensed to John Doe
1st column: name of the software (as in source 1st line)
2nd column: concat of all following lines of the record, with CR or any other divider
Adobe Photoshop;License name: John Doe // s/n: 92409349u23r9jweifjse
ACDsee Ultimate;Licensed to John Doe // serial: 3ur9üusijfisdjgghisrdö // serial2: fjiöj49tutse9tu
I have no idea how to get a new record after each empty line.
Maybe someone could give a hint …?