Hi, you can split that column using text to columns. In this case, we can use a macro to do that. You can use the invoke VBA to inject the code to your file.
Hi, I tried this but my file is csv. And invoke VBA can work on xlsx files.
I tried writting file in xlsx but again I am getting all data in first column, also not proper in new lines else i would have used this code on first column.
If you really need it in CSV you will have to use the data table method you are trying to accomplish. There must be something wrong which your workflow. You will need to find it. Invoke VBA will not work on CSV files, what you can do is make your stuff in a xlsx then copy the data table and paste it back but that’s not following the best practices. I think the issue that you’re having is that you’re trying to append. Try using for each row activity and inside of it use add row to make sure the info gets added to the build data table. If you didn’t use the build data table activity then that’s another something that you should include.
I find it strange that you use CSV (comma-separated values) with a tab delimiter. Actually, XLS is a tab-delimited file, while CSV is comma-delimited in most cases.
Anyway, I assume you use the Read CSV successfully.
Then, use 3 Add Data Column activities to the Data Table.
Finally, use a Write CSV and change the delimiter in the properties, if necessary.
The screenshots show you opening the final csv in excel. Can you open it in notepad or something similar instead and show us the screenshots? Excel will alter the formatting.
Also, I don’t understand why you want to use semi-colon instead of a comma? The name csv stands for Comma Separated Values, so generally you’d want to keep the comma as the delimiter