Hi
@IlkkaKnuuttila,
You can make the below changes to the Excel VBO for importing a CSV file with a semicolon.
(If you do not want to make the changes to the VBO then you can try using the 'Read All Text from File' and 'Read Lines From File' actions of 'Utility - File Management' and see if you can split the text by semicolon. But that is going to be a tedious task.)
For the Excel VBO method please refer the attached files.
1. Process Diagram.JPG: Contains the process flow diagram.
2. Source CSV file.JPG: This is how the CSV looks. You can see that the data itself contains a comma "," but is separated by a semicolon ";".
3. Import CSV VBO changes.JPG: Take a backup of the 'MS Excel VBO' before making the below changes.
You will need to Open the MS Excel VBO, make a copy of the already existing 'Import CSV' page (yellow highlighted). Give a name to the new page and also to its Code stage (red marked).
4. Code Properties change.JPG: By default the comma parameter is True. You need to set it to False and make semicolon as True.
Save the new action page. Publish it so that it will be visible in the Process. You need to hit the Reset button of the process or sometimes have to close and reopen Blue Prism.
5. Action properties.JPG: Set the action properties for the new action that you just designed as shown.
6. Output after running the process.JPG: The output now shows the text in separate columns leaving behind the comma intact and correctly separated by the semicolon.
Hi
@PRJ,
You can too implement this solution and if your problem is different than this then you can open a new thread in the forum describing the complete details of your issue.