import csv

with open('Katalog Induk Hanya untuk di ambil sinopsis edited.txt') as f_read,\
open('katalog.csv', 'w', newline='') as f_write:
	wr = csv.writer(f_write, quoting=csv.QUOTE_ALL)
	lines = f_read.read().split('\n')
	i = 2
	while i < len(lines):
		judul = ''
		kategori = ''
		sinopsis = ''
		if '  : ' in lines[i]:
			judul = lines[i-2]
			try:
				while '  : ' in lines[i]:
					i += 1
					if 'Kategori    : ' in lines[i]:
						kategori = lines[i].split('Kategori    : ')[1].split('  ')[0]
			except Exception as e:
				raise e
			while not '  : ' in lines[i]:
				sinopsis = sinopsis + lines[i] + '\n'
				i += 1
		# data.append(judul, kategori, sinopsis)
		sinopsis = sinopsis[:-1].split('\n')
		sinopsis.pop()
		sinopsis.pop()
		sinopsis = ' '.join(sinopsis)
		wr.writerow([judul, kategori, sinopsis])