Import CSV to excel

Hi everyone! Hope that you guys can help me. I have a file (with file type: ‘file’) that can be opened manually to Notepad. I want to extract that file information to a collection and text mining it. I tried to import it with CSV with MS VBO Excel and it split the data at ’ , ’ and I want it to split at ’ ; ’
Does anyone know how can I solve this problem?

PS: it’s possible to open the file through excel and force the opening to a read-only file

Thanks a lot,
Rita Cabrita

Welcome to the community, Rita!

You could use the Read CSV activity setting the Delimiter property to semicolomn, as shown above: