Question

2
Replies
384
Views
AsifSafi Member since 2018 12 posts
EY
Posted: 1 year ago
Last activity: 1 year 4 months ago
Closed

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

Robotic Process Automation SR Exists
Moderation Team has archived post
Share this page LinkedIn