Recent content by tiger19

Not sure if Im doing it right.

Hello.. i have created a Loop where it will read today's queue item which has completed. I would like to collect all the result into a collection, and send out via email. This is my process. 1) Loop : Collection 2) Get item from work queue --> output for status into Data collection 3) Add row...

thanks is working. it helps me to understand using InStr too. always having difficulty with substring and charindex in blueprism calculation.

I tried as suggested, I'm hitting error "Can't subtract from Text". I apply my data type as Text.

Hi How can I replace the month behind to number in calculation? Example below Jan will be replace with "1" follow by -[number]. 26243-Jan 1-26243 99-Feb 2-99 7328-Mar 3-7328 In my decision for checking, I apply like this InStr(Trim([intRepOrder]), "Jan")<>0

Hi, I am extracting excel file from web report. After extract, require to exclude one of the columns with criteria. Example ColumnA <> 'sample' I manage to use Utility Collection --> Filter Collection. Then I use MS Excel VBO to write the collection and save it after filtered. Is working...

thanks @sahil_raina_91 , I actually have tried. Issue solve now. Have to apply lower case. Upper case won't work.

the shortcut key will be ALT key follow by D then L

Is still not working. Bot will ALT then input text DL.

Hello I would like to run a shortcutkey from a java base application. I came across this post : https://www.rpaforum.net/attachments/1573628429007-png.4845/ I try to apply but is not working. When I try the shortcut key manually is working fine. Is my expression below correct? I try both...

any one able to give idea bout my issue here?

I have java base application. I would like to read the last row. I try to apply DOWN, then focus and click center but it keep going back to first row. Arrow Down is working fine. How can I fix this? Numbers of row are dynamic, sometimes can be 2 sometimes can be 3, etc.. Would like to read the...

Hi, any sample or advice how to spy the java mode drop down? I manage to spy the View but I am not sure what to select in the navigate. I would like to select View --> click Report Below are my elements. How do I add to select Report in the drop down?

Thanks. Is working fine.

Hi, I download few files save into a folder. How can I rename all this dynamic file name to specific name? Rename file1 to report_sample01.xlsx, file2 to report_sample02.xlsx, and so on.