I am facing some problems with the clean data task.
The data is in string format and need to be converted into CSV file.
Problem and solutions tried so far
I have been using the excel text-to-column function, but it isn't able to provide the correct data as the columns are sometimes separated "/" or " " or "-".
I even tried the split function in the excel VBA, but it isn't practical. So I switched to python and tried the Pandas library; it still has the same result.
Raw Data
abx/frt-90kg 2box sut/del 10 may R200 CONF
xyz/frt-90kg 2box sut/del-mb 10-12may R200 CONF tks'
Intended Result
"abx","frt","90kg","2box" ,"sut/del", "10 may", "R200", "CONF"
"abx","frt","90kg", "2box", "sut/del-mb", "10 may", "R200", "CONF tks"
Request If I can get some help in ways that this problem can be resolved. I am new in this business, so any help will be appreciated.