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***