import csv
from itertools import zip_longest
def grouper(iterable, n, fillvalue=None):
    args = [iter(iterable)] * n
    return zip_longest(*args, fillvalue=fillvalue)

def remove_title(s, title):
    """if s starts with the title, erase it; otherwise, do nothing"""
    if s.startswith(title):
        s = s[len(title):]
    return s

def sanitize(s):
    """
    Remove newlines from the string and replace them with something else.
    Useful if you want each row in your csv file to take up exactly one line.
    If you don't care about that, then you don't need to call this later.
    """
    return s.replace("\n", "\\n")

with open("contentfile.txt", encoding="utf8") as file:
    paragraphs = file.read().split("\n\n")


with open("output.csv", "w", newline='') as csvfile:
    fieldnames = ["title", "desc", "shortdesc", "tech", "spec"]
    writer = csv.DictWriter(csvfile, fieldnames)
    writer.writeheader()

    for description_paragraph, tech_paragraph, spec_paragraph in grouper(paragraphs, 3):
        name, _, description_and_link = description_paragraph.partition("\n")
        short_description, _, link = description_and_link.rpartition("\n")

        tech = remove_title(tech_paragraph, "TECHNOLOGY\n")
        specs = remove_title(spec_paragraph, "SPECIFICATIONS\n")

        writer.writerow({
            "title": name,
            "desc": link,
            #these next three may contain newlines, so call `sanitize` on them if you don't wnat those newlines showing up in the csv.
            "shortdesc": sanitize(short_description),
            "tech": sanitize(tech),
            "spec": sanitize(specs)
        })


"""
Result:

title,desc,shortdesc,tech,spec
Intimus pacmaster s,https://nonagon-paddlefish-5ywp.squarespace.com/s/IS_PacMasterS_VS_01-18_en.pdf,The PacMaster S packaging material shredders allow businesses to recycle their cardboard packaging in a unique way.,Shreds old and obsolete cardboard to robust packaging material\nWell designed controls: lockable power switch is also an emergency stop switch\nSingle pass operation\nLockable master switch\nSize guide on the work surface to ensure accurate cutting of the cardboard to customise the stuffing mats to required format\nExtremely robust steel plate housing for heavy duty use at the packing station,"Dimensions (H x W x D): 37.4"" x 27.1"" x 18.5"" \nCutting Speed: 7.1 in/sec\nSupply Voltage: 400 V\nNoise level (dB(A)): 62-68.5\nWeight: 308.6 lbs"
HSM SHREDSTAR S10 ,https://nonagon-paddlefish-5ywp.squarespace.com/s/HSM-shredstar-S10-1_4__1042123-1.pdf,"DOCUMENT SHREDDER\nData protection for everyone. \nThis modern and compact strip cut document shredder with a separate CD cutting unit destroys your data reliably and quietly, both at home or in a small office. ","TECHNOLOGy\nAutomatic reverse eliminates paper jams. \nSeparate CD cutting unit with own waste container for sorted disposal.\nQuiet operation minimizes noise development in the workplace.\nLED indicator shows the device’s operating status: Power, Overload, Overheat.\nLight barrier for automatic start/stop.\nLevel indicator through inspection window in the waste container. \nEffortless emptying of the waste container via the removable housing top.","Dimensions (H x W x D): 17.5” x 13.6” x 9.6”\nColour: White \nMotor: 125W\nContainer/Collection Volume: 4.8 gal\nIntake width/ working width: 8.7 in\nVoltage/frequency: 115 V / 60 Hz \nCutting size: 1/4""\nCutting type: strip\nCutting capacity (in sheets): 10\nSecurity level: P-2/O-1/T-1/E-2\nCutting Capabilities: Paper, Staples & paperclips, Credit & customer cards, CDs & DVDs\nWeight (lbs): 8.6"
HSM SHREDSTAR X5 ,https://nonagon-paddlefish-5ywp.squarespace.com/s/HSM-shredstar-X5-3_16_-x-1-1_8__1043123.pdf,DOCUMENT SHREDDER\nData protection for the home or the small office. This modern and compact cross cut document shredder with a separate CD cutting unit shreds data in the workplace.,"TECHNOLOGy\nAutomatic reverse eliminates paper jams. \nSeparate CD cutting unit with own waste container for sorted disposal.\nQuiet operation minimizes noise development in the workplace.\nLED indicator shows the device’s operating status: Power, Overload, Overheat.\nLight barrier for automatic start/stop.\nLevel indicator through inspection window in the waste container. \nEffortless emptying of the waste container via the removable housing top.","Dimensions (H x W x D): 17.5” x 13.6” x 9.6”\nColour: White \nMotor: 125W\nContainer/Collection Volume: 4.8 gal\nIntake width/ working width: 8.7 in\nVoltage/frequency: 115 V / 60 Hz \nCutting size: 3/16” x 1 1/8”\nCutting type: cross\nCutting capacity (in sheets): 5\nSecurity level: P-4/O-1/T-1/E-2\nCutting Capabilities: Paper, Staples & paperclips, Credit & customer cards, CDs & DVDs\nWeight (lbs): 9.3"
HSM SHREDSTAR X6pro ,https://nonagon-paddlefish-5ywp.squarespace.com/s/HSM-shredstar-X6pro-1_16_-x-5_8__1046113.pdf,DOCUMENT SHREDDER\nReliable and user-friendly micro cross cut document shredder with the highest security level in the shred star series. With a separate CD cutting unit for use in the workplace.,TECHNOLOGy\nAutomatic return eliminates paper jams. \nSeparate CD cutting unit with own waste container for sorted disposal.\nQuiet operation minimizes noise development in the workplace.\nLED indicator shows the operating state of the device\nLight barrier for automatic start/stop.\nLevel indicator through inspection window in the waste container. \nEffortless emptying of the waste container via the removable housing top.,"Dimensions (H x W x D): 18.3” x 13.6” x 9.6”\nColour: White \nMotor: 160W\nContainer/Collection Volume: 5.3 gal\nIntake width/ working width: 8.7 in\nVoltage/frequency: 115 V / 60 Hz \nCutting size: 1/16” x 5/8”\nCutting type: micro\nCutting capacity (in sheets): 6\nSecurity level: P-5/O-1/T-1/E-2\nCutting Capabilities: Paper, Staples & paperclips, Credit & customer cards, CDs & DVDs\nWeight (lbs): 13.9"
"""