I write with python automated names to a CSV file. However, I have the problem that I include names that are separated with a semicolon. Therefore, names that are separated with a semicolon are written in two columns although I want to have them only in one.
product_data= product_data + ";" + re.search(r">(.*?)</", i).group(1)
Within the the re.search() function I filter names which are between "> <". The code works but as described above, I want names to be written in one column and not in two.
>Solution :
I’m not entirely sure if I fully understand the question, but let me attempt to answer it. CSV files just require some time of character to serve as the delimiter that divides each column in a row. What if instead of using a semi-colon as a delimiter you used a comma or, if that appears somewhere in names or product_data perhaps you could use "|"? Additionally, if you wanted to remove the semicolon from the names, you could turn re.search(r">(.*?)</", i).group(1) into "".join(re.search(r">(.*?)</", i).group(1).split(";")). Hope this helps!