topic Read csv file in Product Forum

Read csv file

satishkumarkuru — Wed, 01 Apr 2020 15:18:00 GMT

How to read CSV files into BluePrism collection?

------------------------------
satish
------------------------------

RE: Read csv file

Anonymous — Thu, 02 Apr 2020 07:03:00 GMT

Hi,

You can use standard functionality of Blue Prism. There is Utility - File management object which has the actions Read All Text from File and Read Lines from File. However, please consider memory issues as CSV files can be large and it's better to process them by portions (Read Lines from File).

The second way is to write a custom actions using .NET StreamReader.

------------------------------
Anton Sauchyk
Senior RPA Analyst
EY
Europe/Minsk
------------------------------

RE: Read csv file

satishkumarkuru — Thu, 02 Apr 2020 09:06:00 GMT

Hi Anton,
I have tried, its working.
Thanks for the response.

Satishkumar.

------------------------------
satishkumar kuruba
------------------------------

RE: Read csv file

EdGarabedian1 — Thu, 02 Apr 2020 14:00:00 GMT

Anton beat me 😉 thanks for contributing to the community Anton. For future readers...

------------------------------
Ed Garabedian
Curriculum Developer
Blue Prism
------------------------------