cancel
Showing results for 
Search instead for 
Did you mean: 

Read csv file

satishkumarkuru
Level 2
How to read CSV files into BluePrism collection?

------------------------------
satish
------------------------------
1 BEST ANSWER

Best Answers

Anonymous
Not applicable
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
------------------------------

View answer in original post

3 REPLIES 3

Anonymous
Not applicable
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
------------------------------

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

Satishkumar.

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

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

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