Recent content by rsingh40

Hi Waziaks, Please check below video, it might be of some use to you Thanks

Hi, Please try this Business Object:- Utility String Action:- Split Text Inputs Text to Split:- your Data item Split Char:- ":" Output Split Values as a collection ------------------------------- Business Object:- Utility Collection Manipulation Action:- Read collection fields Inputs Row...

You need to save without "" Correct :- Eg:- C:\BluePrism\Book1.xlsx Wrong: "C:\BluePrism\Book1.xlsx"

Hi Shweta Save data items values without ""

HI Guru using MS Excel VBO - Get Worksheet as Collection Offset. In startCell give value as "B1".This will not copy data from column 1.

Hi Jassi, Give a try like this. "[Collection Column Name] LIKE '%Display Name%'" [Collection Column Name] is the collection column name

Hi Adi, Can you please share Healthcare Related use cases to my emailID sranjit1981@gmail.com. Thanks In advance

Hi Hema, Try Removing " " from the collection and use only [Output] Thanks

Hi,

Step 1 Take Collection as input and loop the collection. Step 2 Utility - String Action:- Remove Non-Word Character Output:- Trimmed Text. Step 3 Use Calc stage Stored the trimmed text in the Original collection or can be new collection. Current Value of collection will display the desired output

Hi Jassi, Try to use region mode to spy and later use write stage to write data in the fields

Hi Shweta Can you post the screenshot of the Process?

Hi Blitzerox, Please give below solution a try:- Input Data:- "House, Building, Farm, Office" Step1:- Use Utility - String Action- Remove Non-Word Character Output will be House, Building, Farm, Office Step 2:- Use Utility - String Action:- Split Text The output will be in the collection...

HI, In addition to your previous steps. Step 3:- Use Loop through the Collection, Use your Output collection Step 4:- BO - Collection - Action:- Add Row To add empty row to final collection Step 5:- Use Calc Stage Replace([Output.Column1], ",", " ") Write to Final Collection

Hi Nav, We have a similar thread. Please take a look if it helps http://www.rpaforum.net/threads/how-to-paste-an-image-from-clipboard-to-excel-in-a-particular-cell.1810/#post-6011