How to remove a paragraph character?

Question

Python

There is an excel file, there are keys in one column, and there can be several keys in one line (see screenshot 1). Excel is converted to csv and such values ​​are inserted into the database (see screenshot 2). How to replace ¶ with ";" For example?

Answer 1

str = '1.2.2¶1.2.3'
sanitized = str.replace('¶', ';')