Import csv with polluted data

[Anonymous]

Hi everyone,

I am trying to import some data with a CSV file (separator : comma). 

But the data is a real disaster.

Let's take the content of only 2 columns of this file and some examples->

column A : 

• 100R74X8,6MM
• SBH3.79011
• TVH/133
• 22-1041

column B :

• "NUT;MEF1"
• Fil 2,4mm
• CO 89D,-01

How can I import this type of file while my CSV is a comma separator and I want all the info in the good column? 

Can somebody help me? I'm stuck 😞

Have a nice day

[Anonymous · Accepted solution]

OK... finally found a solution 

by using a customized separator /;,;/