Close popover
Muhammad Asif (AsifSafi)
Senior Consultant
AsifSafi Member since 2018 12 posts
Posted: April 30, 2019
Last activity: May 30, 2019

csv file manipulation via Pega RPA - OpenSpan


input file: csv file (semi column separated)

​output file: csv file (semi column separated)

Pega has to open and get some columns values from input file. after some process via Pega RPA, write some values in the output file and save it as csv (semi column separated)


when we open the same input csv file manually, excel opens it with tab delimited and each field can be found in each column (attachemnt: ManualCsv)
BUT if same input csv file opens by Pega RPA, we see all the text in one column A with semi Column as separated plus the file seems to be in readonly mode (attachement: PegaCsv)

​we also tried to getCellValue of a column E but pega is not able to get it . could you please suggest us how to manipulate such csv input file to get columns value? Also how to write value in output file with semi column separator and save as csv via pega rpa.

Many thanks in advance

***Edited by Moderator: Pallavi to update platform capability tags***

***Edited by Moderator Marissa to update SR Details***

Robotic Process Automation Support Case Exists
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.