Question

Problems opening course CSV

  • 24 April 2022
  • 1 reply
  • 10 views

 

I'm studying this class:

 

https://automationanywhere.litmos.com/course/3105953/module/6245282/Scorm?LPId=116800/p>

 

But when I use Excel's Open command to open the CSV it opens but doesn't separate the columns, has anyone had this problem?

 

An attached image follows.


1 reply

Userlevel 5
Badge +11

Hi @Achilles Luiz Guilardi Filho​ ,

 

When you're opening the. CSV using excel, you will see the results like the above attachment because the file is separated by the , or ;

 

Would you like to align the values, please follow the below link,

 

https://knowledgebase.constantcontact.com/tutorials/KnowledgeBase/6269-convert-a-text-file-to-an-excel-file?lang=en_US/p>

 

or you can use the TXT/CSV package read the data without opening the file

 

CSV/TXT package - Automation Anywhere Documentation

 

Thanks!

Reply