Question
Flextronics
Flextronics
IN
Flextronics
Posted: May 16, 2019
Last activity: May 17, 2019
Last activity: 17 May 2019 11:25 EDT
Closed
CSV file Find and Replace using Pega
Hello Folks,
I have an Requirement in which first i need to save a excel file to csv and then Open and Replace , with | how this can be achieved using pega robotics studio.
Posted: 5 years ago
Infosys
Infosys
IN
Use excel saveas method to save as .cvs file. Then use again excel connector to read .csv file values row by row and replace as per your requirement then save the file.
Posted: 5 years ago
MOD
Pegasystems Inc.
US
I am attaching a sample solution. Two points;
- The SaveAs requires a script as it requires some objects to be passed that you really need a script to generate.
- If you use the SaveAs method of the connector and change the extension, the file will still be in xlsx format and not converted to CSV.
- The replace can be done in an automation, however it is best to do in a script. Pega Robotics has a limitation in the length of strings to pass in an automation. While this length is really long, it is not hard to imagine a large spreadsheet overtaking this.
In the attached solution, select an Excel file and it will get saved as a CSV and then have the comma replaced with a pipe. It will delete the CSV if it exists already.