拆分已过滤字符的数据框并创建多个新列

I have a a data preprocessing issue that is very common in my work. I usually have two files which I in the end want to do a large matching operation for. It´s usually a two step process where the first step involves making a "cleaned" dataframe of the first file and the second step is to make a match(vlookup) with the second file of a larger dataframe. I need help with the first step in this question. I have created a simple example below to work on. My simplified dataframe:I have a a data preprocessing issue that is ver