csv file manipulation via Pega RPA - OpenSpan
Objective:
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)
Checks:
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
Asif
***Edited by Moderator: Pallavi to update platform capability tags***
***Edited by Moderator Marissa to update SR Details***
Pegasystems Inc.
US
AsifSafi,
You will need to edit the csv file through a text editor and add “sep=;” (without the quotes) as the first line in the file. Once you open the file it should be formatted correctly.
You may also be able to get the text from the from the first column and do some string manipulation to get the values that you needed.