SS&C Blue Prism Community

NickLeGuerrier · 27-01-20

Hello, I have encountered some interesting behavior in Blue Prism today. We have a reconciliation process that connects to a spreadsheet using the OLEDB Blue Prism object and up until now the process of querying data has proven to be successful. Howe...

NickLeGuerrier · 09-04-21

Hi Hemalatha,You can create a copy of the existing Get Files action in the Utility - File Management Object and modify it to only return the count of the files in a given folder. If you are dealing with a very large number of files (10,000+ files), t...

NickLeGuerrier · 01-03-21

Hi Victor,My VB is a little rusty, but I think this should do it:for each r as DataRow in dtIn.Rows r(columnName) = r(columnName).ToString().Replace("-","")nextdtOut = dtIn------------------------------Nick LeGuerrierSenior RPA DeveloperMD Financi...

NickLeGuerrier · 09-02-21

Yes, definitely! Here you are:In this case columnName is an input which you can provide to the method to find the column name you are looking for.foreach (DataRow r in dtIn.Rows){ r[columnName] = r[columnName].ToString().Replace("-","");}dtOut...

NickLeGuerrier · 09-02-21

Hi Karina,Since you mentioned you want to be able to modify all rows for one specific column, this code should work. foreach(DataRow row in inputCollection.Rows){ row[columnName] = row[columnName].ToString().Replace(".",",");}outputCollection = in...

NickLeGuerrier · 08-02-21

Hi Tinna,Here is a quick code stage that removes "-" from columns and rows. Keep in mind this can be done using loops in Blue Prism as well, but I find it faster to write it this way. foreach (DataColumn c in dtIn.Columns){ c.ColumnName = c.Column...

SS&C Blue Prism Community

User Statistics

User Activity

OLEDB Crashed Blue Prism

RE: Get Count of Files from a folder

RE: Removing/Replacing text from a whole collection

RE: Removing/Replacing text from a whole collection

Re: Code for replacing character in column values in a collection

RE: Removing/Replacing text from a whole collection