You have used a comma as a delimiter.
Please try the below steps in excel,
- Select the cell or column that contains the text you want to split.
- Select Data > Text to Columns.
- In the Convert Text to Columns Wizard, select Delimited > Next.
- Select the Delimiters for your data. For example, Comma and Space. You can see a preview of your data in the Data preview window.
- Select Next.
- Select the Destination in your worksheet which is where you want the split data to appear.
- Select Finish
thank your brother, it worked.
Hi @Murad ALotaibi ,
Always happy to assist, also we would appreciate it if you marked @Tamil Arasu 's answer as 'Best' so that others facing similar issues may benefit from it as well and also to close this thread.
Kind Regards,
Ashwin A.K
Hi everyone!
I have the same problem. The first solution helps with Excel view, but the bot does not write the info like that even when I configure the activity correctly. I’m doing the Build your first bot course in AA university and there they show the CSV file like this
I followed all the steps but I cant make that my bot write the CSV file like this. What am I missing? the activity does not work fine?
Hi everyone!
I have the same problem. The first solution helps with Excel view, but the bot does not write the info like that even when I configure the activity correctly. I’m doing the Build your first bot course in AA university and there they show the CSV file like this
I followed all the steps but I cant make that my bot write the CSV file like this. What am I missing? the activity does not work fine?
Hi, i had the same issue, handle it by using an Excel advanced activity “Write from Data Table” instead “Write to file” Data Table activity
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.