Forum Engagement Daily Reports

[system]

Daily Forum Report | 11 August 2021

Top 3 Topics with Most Views

New layout for the Uipath studio made by @SH_94 with 32 views.

How to filter the excel row with dynamic key words? made by @Dorothy_lee with 30 views.

Adding new row to excel from multiple xlsx/csv made by @Vi_ciel with 29 views.

Top 3 Topics with Most Replies

Getting certain part of a long strict from an Outlook Email made by @Saltukhan_Dura with 17 replies.

Extracted pdf invoice file need to move to other folder made by @chaitanyaKumar with 16 replies.

How to share a post in facebook groups? made by @lelouch with 15 replies.

Top 3 Users Who Posted The Most

@SHAF_MAIRAJ made 38 posts!

@Yoichi made 17 posts!

@ppr made 15 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Custom inputアクティビティのブラウザ変更

こんにちは このアクティビティはブラウザを開いているのではなく、IEコンポーネントを利用していると 思いますので、別ブラウザで開く等はできないと思います。 直近で類似のトピックが上がっていますので、以下も参照いただくと良いかもしれません。

This post made by @prasath17 received 2 likes!

How to filter the excel row with dynamic key words?

@Dorothy_lee - You can try like this… First Read the column where you have the keywords to an String Array using the below code… Dt2_HSBC_001.AsEnumerable().Select(Function (a) a.Field(of string)("Column Name").ToString).ToArray After that use the below code to check whether Name column contains any value in the array… (from x as DataRow in Dt2_HSBC_001 where Array.Contains(x("Name").ToString) select x ).CopyToDataTable Hope this helps.

This post made by @aito received 2 likes!

エクセルファイルのデータをウェブページの欄へコピペする方法

N2027さま ご教示くださり、ありがとうございます。私は、StudioX 2021.4.4 Community Licenceを使っています。アクティビティーに[クリップボードに設定]と[ホットキーを押下]が見当たらなかったため、代用できそうなもの、具体的には[セルの値を読み込み]と[キーボードショートカット]を使ってみました。その結果、自分の思うように出来上がりました。ありがとうございました。

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Custom inputアクティビティのブラウザ変更

こんにちは このアクティビティはブラウザを開いているのではなく、IEコンポーネントを利用していると 思いますので、別ブラウザで開く等はできないと思います。 直近で類似のトピックが上がっていますので、以下も参照いただくと良いかもしれません。

This solution provided by @poorna_nayak07 received 1 likes!

How to filter the excel row with dynamic key words?

Hi @Dorothy_lee , Follow below steps. [image] Read KeyWord Excel into one datatable(KeyWordDT) and convert it to Array of Keywords as below KeyWordArr=KeyWordDT.AsEnumerable().Select(Function (a) a.Field(of string)("Column Name").ToString).ToArray Read target excel into Datatable (InputDT). Assign ResDT=InputDT.Clone Use below expression in assign activity. ResDt=(From row in InputDT.Asenumerable Where KeyWordArr.AsEnumerable.Where(Function(x) row("ColName").ToString.Trim.Conta…

This solution provided by @Yoichi received 1 likes!

What is the difference of Host based licensing vs. Tenant based licensing?

Hi, Do you use on-premise OC? Which is better to use, host-based licensing or tenant-based licensing? It depends on your requirement. If you need to move license from a tenant to other, host-base license (One License per Multiple Tenants) is better. In the license tab in tenant host under Unattended it is displaying “12 runtimes of 12”. Does this mean we have 12 unattended licenses available which are already allocated and are not expired? This is just for confirming, as I am having a dou…

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 12 August 2021

Top 3 Topics with Most Views

How can i match with 2 values in pdf using uipath made by @anonymous3 with 53 views.

No selector. How to click? made by @jeyekij306 with 52 views.

Extract data from Yahoo Finance made by @kkarbassian with 50 views.

Top 3 Topics with Most Replies

Couldn't extract the correct text from browser made by @JacelynLok08 with 22 replies.

In AI center, ML skilled deployed but giving error made by @Monika_Neeboriya with 19 replies.

How can i match with 2 values in pdf using uipath made by @anonymous3 with 18 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 22 posts!

@Yoichi made 21 posts!

@ppr made 14 posts!

Top 3 Most Liked Posts

This post made by @sunny_singh received 2 likes!

UiPath Cloud Masters

thank you @Vibhor.Shrivastava @Ishmeet_Bindra @loginerror @Syed_Pasha and entire community thank you heaps guys

This post made by @Ishmeet_Bindra received 2 likes!

UiPath Cloud Masters

Hi All, We have our Week 3 (AWS Cloud Edition) winner. Congratulations @sunny_singh for winning last week’s challenge. Details about his submission - Idea - 𝐌𝐞𝐝𝐢𝐜𝐚𝐥 𝐈𝐃 𝐆𝐞𝐧𝐞𝐫𝐚𝐭𝐨𝐫: This project will help in the generation of ICD-1-CM codes and entities and Traits for Clinical studies. Generally, this takes a lot of time as generating such codes is a tedious task. We implemented a solution that uses AWS Comprehend to generate codes quickly and can be a lifesaver in some cases. …

This post made by @Tatsuya899 received 2 likes!

Edgeでwebから名前を付けて保存

Chromeブラウザかと思っていました。 セレクターを変更して、クリックをシュミレート解除したら上手くいきました。 ありがとうございます。

Top 3 Most Liked Solutions

This solution provided by @MMoura received 1 likes!

"Indicate Element" doesn't work with Default UiEngine for Desktop Applications

Thanks for the reply @ClaytonM I managed to solve it in a different way. There was no need to update the .net framework, but I had to modify all registry values mentioned here (Identifying UI Elements After Windows Updates) to {03022430-ABC4-11D0-BDE2-00AA001A1953} in the ProxyStubClsid32 sub-key. I also had to delete all “TypeLib” subkeys in the mentioned registry keys. My main concern is that the solution mentioned by UiPath haven’t worked, so I had to improvise a bit, other than that, it’…

This solution provided by @RPAForEveryone received 1 likes!

Read and download 1 email at the time

Hi @Andre_Vieira It’s hard to assess from your workflow which mail activity you’re using to retrieve email. But all ‘Get Mail’ activities have some way of limiting the number of emails retrieved at one time. Checkout the Top option under the Options section here: Get Outlook Mail Messages Get Exchange Mail Messages Top -The number of messages to be retrieved, starting from either the newest or the oldest, depending on the OrderByDate parameter.

This solution provided by @Yoichi received 1 likes!

Need Help for Sum of the first "n" odd-valued elements

Hi, Can you try to add index variable in index property of ForEach and modify condition as the following? [img20210812-8] Note: index of ForEach is 0-based. So even number of the index is odd number as we count it 1 based. Sequence3.xaml (8.1 KB) Regards,

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 13 August 2021

Top 3 Topics with Most Views

Excel tables made by @pari_patel with 33 views.

Difficult situation in uipath in real time? made by @Pavani_Vankayala with 32 views.

Detect download button in the browser made by @SH_94 with 31 views.

Top 3 Topics with Most Replies

My uipath studio not working? made by @Deepak_Gautam with 10 replies.

Group Excel Cells made by @luan.quirino1 with 9 replies.

Get Text not working in Anchor Base made by @tilarapiyush with 9 replies.

Top 3 Users Who Posted The Most

@ppr made 17 posts!

@Deepak_Gautam made 13 posts!

@Monika_Neeboriya made 10 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 2 likes!

Where can we learn Orchestrator's database Data Model?

@CosminV Hello George, I know this is an old post, but here a business use case where it is necessary to know the Orchestrator’s data model: Let’s say in a company all audit data of all applications, which are in use, are collected centrally. The collection of this type of data is not uncommon for large companies, as it is required for revision purposes, e.g. in insurance and banking. As @loginerror wrote here, UiPath Orchestrator doesn’t offer the possibility to redirect this kind of data. H…

This post made by @cheez_RPA received 2 likes!

GMAILで送ろうとするとエラーが発生

@N2027 さんが書かれているように、送信先として指定しているメールアドレスに、メールアドレスとして使用できない文字（空白）が含まれていることが原因でGmailからエラーが返されています（このことはメッセージに含まれる英文からわかります）。 従ってアプリパスワードやアクティビティパッケージのバージョンは関係ありません。 実行する環境によってエラーになる、とのことですが、送信先のメールアドレスをファイルなどで指定できるようにしていませんか？いちど、メールアドレスの入力を確認していただくようにお伝え下さい。

This post made by @postwick received 2 likes!

Detect download button in the browser

Use Find Children

Top 3 Most Liked Solutions

This solution provided by @postwick received 2 likes!

Detect download button in the browser

Use Find Children

This solution provided by @T0Bi received 1 likes!

Different outputs and results between the Studio and the robot

But you’re always creating a new Random object which resets the seed. Try creating the Random object outside of your loop rand = new Random() and then use .Next() in your loop randomInt = rand.Next(89)

This solution provided by @ppr received 1 likes!

I am getting eror into syudio?

ensure that feeds are enabled by following: [grafik] Also check if machine is ready to fetch packages from internet (maybe blocked by firewall rules)

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 14 August 2021

Top 3 Topics with Most Views

Uploading a file with a FORM made by @Andre_Vieira with 30 views.

UIPath Click Toolbar - Indicate on screen doesn't recognize made by @Tiago_Dias with 24 views.

How to iterate over all the values of a table to check a condition made by @Josep with 23 views.

Top 3 Topics with Most Replies

Transactions keep repeating after finishing once made by @clumsily with 11 replies.

Remove email attachment of excel from outlook email and add new excel attachment made by @Suresh_reddy2 with 9 replies.

Uploading a file with a FORM made by @Andre_Vieira with 8 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 14 posts!

@Dawodm made 10 posts!

@clumsily made 7 posts!

Top 3 Most Liked Posts

This post made by @Andre_Vieira received 2 likes!

Uploading a file with a FORM

Hi again @NIVED_NAMBIAR job done. [image] [image] Thank you

This post made by @NIVED_NAMBIAR received 2 likes!

Uploading a file with a FORM

Can u try to deserialize the json and then extract the file path and see if it is working for your case

This post made by @StefanSchnell received 1 likes!

Interacting with Multiple SAP Windows

@Karoweiss Hello Karoweiss, please look at this interesting SAP presentation about SAP GUI Scripting API at slide 20 et seq. about the object model. To differentiate between two equal SAP sessions via the session number you can use the attribute sapSession. [image] Add it to your selector and it should work. Best regards Stefan

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 2 likes!

Uploading a file with a FORM

Can u try to deserialize the json and then extract the file path and see if it is working for your case

This solution provided by @tilarapiyush received 1 likes!

Get Text not working in Anchor Base

Hi, I got the solution doing below steps. Used ‘Indicate anchor’ function in UiExplorer (as suggested by @Ryba ) and then selected the CSS Selector attribute. Also I unchecked few attributes and used wild characters to make my selector more dynamic. Thanx everyone for help.

This solution provided by @NIVED_NAMBIAR received 1 likes!

How to Replace Words In a Text File

Hi @Ajit_Chowdary Answer for your solution is here Main.xaml (9.8 KB) Mark it as solution if it helps you Regards, Nived N

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 15 August 2021

Top 3 Topics with Most Views

I need to read multiple file paths from an excel and delete files which are more than 30 days made by @kushal.vetsa with 25 views.

How can we convert pdf document into word document made by @Durvesh_Bendale with 25 views.

How to write log in excel? made by @Maria99 with 25 views.

Top 3 Topics with Most Replies

I need to read multiple file paths from an excel and delete files which are more than 30 days made by @kushal.vetsa with 11 replies.

Problem On Excel made by @nirmalya.sarkar with 9 replies.

Loop through Columns and pasting the data into a web page made by @Bhanu_Rathore with 5 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 14 posts!

@NIVED_NAMBIAR made 10 posts!

@kumar.varun2 made 8 posts!

Top 3 Most Liked Posts

This post made by @whelandexter received 2 likes!

This question seems incorrect, can someone confirm?

Feedback about the Data Manipulation Academy course. Please type your feedback below. [image] this question seems to indicate that ‘generate data table’ is the answer but ‘output data table’ is the action you would use to put data from a datatable into a string. Can someone confirm?

This post made by @kumar.varun2 received 2 likes!

Sort datatable data based on one column

Hi @clumsily Another way to achieve the same. [image] dt.AsEnumerable.OrderBy(Function (r) r("Brand").ToString).CopyToDataTable.DefaultView.ToTable(False, {"Brand", "Name", "Price"}) Finally you can write dt in excel file using Write Range

This post made by @Bachali received 1 likes!

Component for Data Table activities

Hi Lahiru, Could you please let me know the exact package name where we can calculating SUM, AVG, MIN, MAX, COUNT, STANDARD DEVIATION AND VARIANCE Thanks in advance . Regards, Akhil B

Top 3 Most Liked Solutions

This solution provided by @Durvesh_Bendale received 1 likes!

Invoke Workflow

Hi @Amani_Boukadidaaa I guess you wanted to show email subject in message box. for this you need to change out_email argument direction to ‘in’ because you are passing email value to subject workflow.

This solution provided by @kumar.varun2 received 1 likes!

How to use the last element of a list of integers in uipath?

@gh_lzm Try This CutPage.AsEnumerable.Reverse.Take(2).Last.ToString

This solution provided by @kumar.varun2 received 1 likes!

I need to read multiple file paths from an excel and delete files which are more than 30 days

@kushal.vetsa For the input excel file like below [image] Check the updated xaml file read multiple file paths from an excel and delete files which are more than 30 days.xaml (8.7 KB) This can further be optimized by using the root directory path which contains all the folders. For that I would suggest to explore the Directory.GetFiles() method.

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 16 August 2021

Top 3 Topics with Most Views

Object reference not set to an instance of an object eror made by @Duygu_Ozdemir with 44 views.

Excel activity in UiPath made by @Sojol_Hamid with 28 views.

Multiple Assign activity error made by @venkateshcheeni09 with 28 views.

Top 3 Topics with Most Replies

Multiple Assign activity error made by @venkateshcheeni09 with 31 replies.

Object reference not set to an instance of an object eror made by @Duygu_Ozdemir with 18 replies.

Please Help. Could not find of part the path, Unattended made by @Hurmet_Noka with 17 replies.

Top 3 Users Who Posted The Most

@ppr made 23 posts!

@pravin_calvin made 23 posts!

@Yoichi made 19 posts!

Top 3 Most Liked Posts

This post made by @kumar.varun2 received 2 likes!

This question seems incorrect, can someone confirm?

@whelandexter Yes, you are correct. The answer to the question is wrong. It should be Output Data Table.

This post made by @Yoichi received 2 likes!

データテーブル内のレコードを自然順に並べ替えたい

こんにちは エクスプローラーと全く同じ挙動を実現するにはそれなりに実装や他のライブラリが必要になると思います。 もし特定の条件下での並べ替えだけでよければ、その仕様を共有いただけると、それ用の式は書けるかもしれません。

This post made by @StefanSchnell received 2 likes!

How to Realize a Local Web Environment

If you develop automation workflows in restricted environments, e.g. which have no access to the internet, so it is necessary to provide a web server with the all needed content locally. In this guide I will describe how to realize a local web environment easily. First step is to download all necessary programs and data, which are then transferred to the restricted environment. These programs are needed: UiPath Studio Google Chrome Offline Installer for Windows x64 Baby Web Server a simple …

Top 3 Most Liked Solutions

This solution provided by @kumar.varun2 received 2 likes!

This question seems incorrect, can someone confirm?

@whelandexter Yes, you are correct. The answer to the question is wrong. It should be Output Data Table.

This solution provided by @ppr received 2 likes!

Regex "after and before word"

[grafik] and group: [grafik]

This solution provided by @ppr received 2 likes!

Split String with a maximum of 40 characters and end with full words/characters

@thorem99 [grafik] [grafik] Find starter help here: Regex_SplitParts_MaxCharLength_NoWordBreak.xaml (9.5 KB)

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 17 August 2021

Top 3 Topics with Most Views

How to use Linq? made by @Maria99 with 41 views.

(Modern) Combining all the recorders into one was a mistake made by @postwick with 39 views.

Regex to check if subject format was followed made by @mnlatam with 36 views.

Top 3 Topics with Most Replies

Group matching rows together made by @RPA-botDev with 15 replies.

Click Link in WebPage Based on Keyword made by @hsendel with 11 replies.

Studio Extension not appearing in Edge store made by @fflattery with 11 replies.

Top 3 Users Who Posted The Most

@ppr made 21 posts!

@pravin_calvin made 16 posts!

@RPA-botDev made 10 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

動作の際、よく起こるエラーの改善案があればアドバイスください。

こんにちは 取り急ぎ下記確認させてください。 １．テキストエディタを立ち上げてそこに貼り付け、とのことですが この方法で行っている理由があるのでしょうか？ なおUiPathではクリップボードの内容を読み込んで、そのまま テキストファイルに出力することができます。 ２．Win+Rで何かを打ち込んで起動していますが、Use Applciation やOpen Applciation、Start Process等を使わない理由は何かあるのでしょうか？

This post made by @DaliyaK received 2 likes!

CoE Summit | September 7-16 - Everything you want to know about an RPA center of excellence!

Hi everyone! There’s been a lot of questions around the automation center of excellence and we decided to address them at the upcoming CoE Summit From September 7 to 16 we’ll host four webinars where automation leaders of AGL Energy (Australia), NOS (Portugal), Ingram Micro (USA), and our own RPA CoE will discuss the importance of a dedicated automation team at your company, and answers some questions like: How to prioritize automation ideas? Which automations are built by the…

This post made by @shunsuke.ogata received 2 likes!

データテーブル内のレコードを自然順に並べ替えたい

皆様 お世話になっております。 大変恐縮なのですが、 以下の内容を参考に実装を行ったところ、無事に解決いたしました。 解決に尽力いただきましてありがとうございました。 またわからないことが出た際にはご質問させてください。

Top 3 Most Liked Solutions

This solution provided by @shunsuke.ogata received 2 likes!

データテーブル内のレコードを自然順に並べ替えたい

皆様 お世話になっております。 大変恐縮なのですが、 以下の内容を参考に実装を行ったところ、無事に解決いたしました。 解決に尽力いただきましてありがとうございました。 またわからないことが出た際にはご質問させてください。

This solution provided by @ppr received 2 likes!

Compare two columns from different datatable

Lets assume that dt1, dt2 have the same row count Create a report DataTable with build datatable activity Cols: C1, C2, Result - dtReport Assign activty: Left Side: dtResult Right side: (From i in Enumerable.Range(0, dt1.Rows.Count) Let chk = dt1.Rows(i)(0).toString.Trim.Equals(dt2.Rows(i)(0).toString.Trim) Let rs = IF(chk,"Correct","InCorrect") Let ra = new Object(){dt1.Rows(i)(0),dt2.Rows(i)(0),chk} Select r=dtReport.Rows.Add(ra)).CopyToDataTable i case of you need a different output / …

This solution provided by @Steven_McKeering received 1 likes!

Remove text before a word

Hey You can use Regex to achieve this! Try using this link to preview/play with the result. In UiPath Studio - use an Assign activity like this. Str_Variable = System.Text.RegularExpressions.Regex.Replace(YOURINPUTSTRING, “[\s\S]*(?=IMPORTANT)”, “”) GIve it a go

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 18 August 2021

Top 3 Topics with Most Views

Remove digits from string made by @jntrk with 33 views.

データテーブルを保存できませんでした。列型を確認してください。 made by @shunsuke.ogata with 29 views.

Continue after throw made by @CasseyEllsworth with 28 views.

Top 3 Topics with Most Replies

Please help for state machine made by @taruna.mehra with 18 replies.

Remove digits from string made by @jntrk with 17 replies.

Continue after throw made by @CasseyEllsworth with 11 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 26 posts!

@ppr made 18 posts!

@postwick made 18 posts!

Top 3 Most Liked Posts

This post made by @cheez_RPA received 4 likes!

UiPathPlatformInstaller.exeでのインストール時間

スペック以外にも、対象端末にインストールされている他のソフトウェアとの相性によることがあります。 例えばいわゆるアンチウィルスソフトなどのアプリケーションが、インストール時に追加されるファイルを走査するために高負荷になる、なども（1つの可能性として）存在します。 またインストーラーについてですが、Platform Installer はインストーラー自体のファイルサイズも大きくそれが影響している可能性もあります。MSIインストーラーでもStudioのインストールは可能ですので、いちどお試しになってはいかがでしょうか。

This post made by @eeskildsen received 2 likes!

Queue schema jsons

@Jon_Smith, that worked…Thanks for the info. I didn’t really connect the dots until your answer that this is the JSON Schema defined here: https://json-schema.org/. This is my first real encounter with it beyond as a consumer. Adding a $schema property to my JSON gave me autocomplete in VS Code. Adding required as you suggested made Add Queue Item throw an error in Studio for the ItemInformation screenshotted in my previous post. { "$schema": "http://json-schema.org/draft/2020-12/schema",…

This post made by @Yui1 received 2 likes!

UiPathPlatformInstaller.exeでのインストール時間

新しいPC（Windows10Enteprise、メモリ8GB）にStudioをインストールする際に、10人中9人が下記の現象になっているのですが、同じ現象の方がもしいらっしゃれば、ぜひ、事象を教えて頂ければと思います。（社内環境による影響かどうか微妙なところ・・・） フォーラムなので、気軽にご意見頂けたらと投稿させて頂きました。 解決策を求める目的ではありません。 ※アップデートでも新規インストールでも同じ インストーラー起動し、オプション選択後、インストールボタン押下 進捗75％で止まる 強制終了 再度、インストーラー起動し、インストールボタン押下 また進捗75％で止まる 強制終了 再度、インストーラー起動し、インストールボタン押下 また進捗75％で止まる そのまま2時間待つ インストール完了する おおよそ、強制終了を2～3回やると数時間後にはインストール完了するという都市伝説のようなやり方をマニュアル化せざるを得ないかと検討中です。

Top 3 Most Liked Solutions

This solution provided by @Steven_McKeering received 1 likes!

Regex to check if subject format was followed

Hey @mnlatam I got your back (why I already added the “-”). Names are tricky. Try this updated pattern: (?<=client:)\s*([\w\s\.\-]+),\s*([\w\s\.\-]+)\s*_doc I have a second option but I am not sure if this suits your needs but this is a simplified version where First and Last name are not captured separately. (?<=client:)\s*[(,\w\s\.\-]+\s*_doc Extra unknown characters can be inserted into the square brackets “[ ]”. I would use a “\” to escape them just incase.

This solution provided by @Yoichi received 1 likes!

Split value 100 in different values so that sum should be equal to 100

Hi, How about the following? I think maximum number of rows is 13, right? [img20210818-3] Sequence1.xaml (6.9 KB) Regards,

This solution provided by @ermanoj3101 received 1 likes!

Date matching issue

Hi @Clintonnn , You can also use it as [image]

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 19 August 2021

Top 3 Topics with Most Views

Orchestrator reporting made by @Petar_Soce with 49 views.

How to convert a string variable to a dateformat (yyyy_mm_dd) made by @Saranyajk with 46 views.

Substring middle values made by @Balan with 39 views.

Top 3 Topics with Most Replies

Substring middle values made by @Balan with 16 replies.

Excel column with currency value to convert into 2 decimal made by @pari_patel with 16 replies.

Copy queue name from one data table to another data table without using loops made by @Surya_Narayana_Korivipadu with 15 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 30 posts!

@NIVED_NAMBIAR made 26 posts!

@AndyMenon made 22 posts!

Top 3 Most Liked Posts

This post made by @ermanoj3101 received 2 likes!

Substring or Split of a data that contains slash (/)

Hi @Tanzill_Ahsan , You can also use substring for this case. [image] Test.xaml (4.9 KB)

This post made by @Yoichi received 2 likes!

Read active sheet in excel

Hi, There are some ways to achieve it. The following is one of them using ClosedXML. Hope this helps you. [img20210820-1] Sample20210820-1.zip (16.9 KB) Regards,

This post made by @Hiba_B received 2 likes!

Substring middle values

And to complete the answer of @prasath17 and @NIVED_NAMBIAR in another way an artisanal option would be split: value_of_12345 = value_of_row.toString.Split(Cchar(" “))(2) value_of_123.0 = value_of_row.toString.Split(Cchar(” "))(6) Happy automation

Top 3 Most Liked Solutions

This solution provided by @cheez_RPA received 2 likes!

近似文字列の分岐方法

正直なところ建物名については、ある程度のイレギュラーを認める代わりに、出来る限りイレギュラーを減らすような考え方で取り組むのが良いと思います。 過去に、住所や建物名を大量に処理する業務のRPA化に携わったことがありますが、そのときも最終的には手作業にしています。先方と調整のうえ「すべてのパターンを網羅して100%にすること」は目指さずに、「手作業のボリュームを極力減らすこと」として9割を目標に対応することとした、という話です。 割合をどの程度に設定されるか、は先方の状況次第になるかと思います（私のときは1割なら手で対応できるだろう、という想定でした）。 @shinji さんのいうように有料のAPIなどもありますが、これはだいたい「建物名」には対応していないです（住所はある程度対応してくれますが）。

This solution provided by @Sam_Abraham received 1 likes!

Substring or Split of a data that contains slash (/)

Hi , You can use split in the way shown below Split(input_string,"/")(0)

This solution provided by @prasath17 received 1 likes!

Substring middle values

Please check this… [image] System.Text.RegularExpressions.Regex.Match(“s CES STD 12345678 RPA DENTAL EQUI 03APR 430.00- 40 P”,"[\d.]+-").Value.ToString

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 20 August 2021

Top 3 Topics with Most Views

I want to click on purple place made by @S_Sim with 41 views.

Cav to excel made by @pari_patel with 39 views.

For each file in each subfolder made by @AdamKA with 34 views.

Top 3 Topics with Most Replies

I want to click on purple place made by @S_Sim with 12 replies.

How to move pdf files from multiple folders having DDMMYYYY format and copy to new location made by @enthusiastic with 11 replies.

Hi, I had got this error while adding queue item made by @bala371 with 11 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 22 posts!

@ppr made 18 posts!

@prasath17 made 16 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

Delete duplicate row if one column contain certain special string

Hi, Hope the following helps you. [img20210820-2] dt = dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("Name").ToString,r("Position").ToString)).SelectMany(Function(g) if(g.Key.Item2="Staff",{g.First()},g.Select(Function(r) r))).CopyToDataTable Sample20210820-2.zip (9.5 KB) Regards,

This post made by @jeevith received 3 likes!

Debugging with the orchestrator is frustrating

Hi @kbak, I second that and I feel your pain. After some very frustrating days we decided it was enough. Orchestrator does not help us when we need a hotfix and are stuck with parsing logs to find the needle in the haystack. The search function is great but when we are a small team we need results quick. We use a custom dashboard on Splunk and get all the diagnostic metrics of robot executions, failures and time usage for every process and can slice and dice the data to our liking. I did pen…

This post made by @Tory received 2 likes!

UiPathPlatformInstaller.exeでのインストール時間

Studio.2021.4.3から正式に UiPathStudio.msi が 64 ビット インストーラーになり UiPathPlatformInstaller.exe を廃止するそうです。 参考までに 2021.4.3 (uipath.com)

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

Delete duplicate row if one column contain certain special string

Hi, Hope the following helps you. [img20210820-2] dt = dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("Name").ToString,r("Position").ToString)).SelectMany(Function(g) if(g.Key.Item2="Staff",{g.First()},g.Select(Function(r) r))).CopyToDataTable Sample20210820-2.zip (9.5 KB) Regards,

This solution provided by @kumar.varun2 received 2 likes!

Cav to excel

@pari_patel Give it a try [image]

This solution provided by @prasath17 received 2 likes!

I am not able to filter on date in a data table

@manjesh_kumar - Please look closely… CDate(row(“Grn Date”)).Date. Equals (now.Date)) In the above code, you are checking the Grn Date is equals to Now.date…i believe none of the values in the sheet has the 08/20 date so it is returning the count to 0. CDate(row(“Grn Date”)).Date > now.Date) Note: CDate and Datetime.parse will work based on the local system settings, i.e. my local settings MM/dd/yyyy so if use cdate with dd/MM/yyyy format it will thrown an error. You get it?? Suggestion: B…

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 21 August 2021

Top 3 Topics with Most Views

Writing .tsv excel file? made by @Bhanu_Rathore with 33 views.

Add dynamic rows to excel made by @li.yu with 23 views.

Not able to scrape Image URLS made by @surya_teja.k with 22 views.

Top 3 Topics with Most Replies

Writing .tsv excel file? made by @Bhanu_Rathore with 13 replies.

Google classroom creating class with bot made by @Hubert_Caguiat with 9 replies.

Not able to scrape Image URLS made by @surya_teja.k with 7 replies.

Top 3 Users Who Posted The Most

@kumar.varun2 made 9 posts!

@Riya_Sharma made 8 posts!

@Yoichi made 7 posts!

Top 3 Most Liked Posts

This post made by @kumar.varun2 received 2 likes!

Read Range convert excel date format automatically

Hi @JuneQuan Use this code in invoke Code and it will work for both the scenarios inputDT.AsEnumerable.Where(Function (x) Not String.IsNullOrEmpty(x(0).ToString)).ToList().ForEach( Sub (row) row(1) = If(row(1).GetType.ToString.Equals("System.DateTime"), CDate(row(1).ToString).ToString("dd/MM/yyyy"), row(1).ToString) End Sub) Instead of row(1) you can provide the column name also like row(“columnName_1”). This is only for the first date column only. For your reference Date Issue.xaml (5.3 K…

This post made by @ranaprathap928 received 1 likes!

Need regex code for PDF Table data extraction

Hi @Steven_McKeering Thanks for the solution. This code is Working. Thank you so much.

This post made by @kumar.varun2 received 1 likes!

Read Range convert excel date format automatically

If the date is in text format it will read it in text format only (i.e., String) but if the date is in date time format it will be read in DateTime Format. Look closely at your input excel file. The date formats are different in input excel. UiPath is reading them correctly.

Top 3 Most Liked Solutions

This solution provided by @kumar.varun2 received 2 likes!

Read Range convert excel date format automatically

Hi @JuneQuan Use this code in invoke Code and it will work for both the scenarios inputDT.AsEnumerable.Where(Function (x) Not String.IsNullOrEmpty(x(0).ToString)).ToList().ForEach( Sub (row) row(1) = If(row(1).GetType.ToString.Equals("System.DateTime"), CDate(row(1).ToString).ToString("dd/MM/yyyy"), row(1).ToString) End Sub) Instead of row(1) you can provide the column name also like row(“columnName_1”). This is only for the first date column only. For your reference Date Issue.xaml (5.3 K…

This solution provided by @prasath17 received 1 likes!

Update column "Comments" based on the search condition from column "Reason Code" using LINQ

@manjesh_kumar - Here you go… Build Datatable - this is just to show you here. You have to use Read Range and save it to Datatable… [image] Invole Code… [image] [image] dtInput.AsEnumerable().Where(Function(row) row(0).ToString.Equals("T9")).ToList.ForEach(Sub(row) row(1) = “I love UIPATH”) My Output - Again, you can replace it with Write Range… [image] Hope this helps…

This solution provided by @ppr received 1 likes!

How can I delete rows of negative and positive cells that cancel each other out?

@nibir08 thanks for detailed case description. Assumptions: Group Values are the same Value and only different on positive or negative Variables: [grafik] Flow: Preperation result DataTable and grouping the data by firtst Column values [grafik] Processing the groups and adding remaining rows to Result Datatable [grafik] e.g. getting the posivite values: (From g In grp Let x = CInt(g(1).toString.Trim) Where x > 0 Select r=g).toList getting the common count: {PosRows.Count, NegRo…

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 22 August 2021

Top 3 Topics with Most Views

'CultureInfo' is not declared. it may be inaccessible due to its protection level error made by @muthinavenu with 28 views.

Delete Row in imported CSV file made by @michael.murphy with 28 views.

Remove Dublicate Rows based on a column made by @Karam_Abulawii with 24 views.

Top 3 Topics with Most Replies

Remove Dublicate Rows based on a column made by @Karam_Abulawii with 11 replies.

Selector's issue made by @yasser_el_shrief with 8 replies.

How to follow a sequence while uploading files from file directory? made by @Deepak_Gautam with 6 replies.

Top 3 Users Who Posted The Most

@ppr made 7 posts!

@AshwinS2 made 7 posts!

@prasath17 made 6 posts!

Top 3 Most Liked Posts

This post made by @LaraSandford received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, I am Lara, I actually have joined UiPath in Strategy and Operations and am learning to use the robot so that I can automate tasks as part of my job! I find that it is an amazing tool and we could benefit greatly from it.

This post made by @Ashwin_Swain received 1 likes!

Help in automating report extraction using putty dbeaver n excel

@Nithinkrishna well the first error of fetching password from windows credential manager n typing into cmd using secure credential doesn’t work…had to use get password n store passdword on uipath bot…hope its not a security threat

This post made by @Ashwin_Swain received 1 likes!

Help in automating report extraction using putty dbeaver n excel

Hi @Nithinkrishna can you please help me?

Top 3 Most Liked Solutions

No solutions received a like yesterday
Please like some solutions to fill this space .

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 23 August 2021

Top 3 Topics with Most Views

Checking Existence of signature in pdf file made by @SH_94 with 36 views.

Data_Extraction made by @Amani_Boukadidaaa with 32 views.

AddDays(-1) adds on months instead of days made by @LDPens with 31 views.

Top 3 Topics with Most Replies

Checking Existence of signature in pdf file made by @SH_94 with 16 replies.

PleUiPath unable to detect this application selectors, means it cant be automated? made by @Hurmet_Noka with 15 replies.

Get outlook mail messages - the specified folder does not exist made by @rebekah.batley with 10 replies.

Top 3 Users Who Posted The Most

@sonaliaggarwal47 made 18 posts!

@ppr made 12 posts!

@ermanoj3101 made 11 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 5 likes!

How to Check Upload and Download Packages to Orchestrator with Postman

Within the scope of my tests I checked the possibilities to upload and download packages to the cloud Orchestrator, to see how to transfer NuGet packages. I used Postman as the platform for this. First, I defined a collection in Postman. In this collection I have created three requests. [image] In the collection I have created a collection variable where the access token is stored. [image] Get Token First step is to get a token with a post request. In the body I choose x-www-form-urlenco…

This post made by @Sero2077 received 2 likes!

Sort DataTable with Multiple Columns(in a For Each)

working beautifully! thanks

This post made by @Neha_Singh05 received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello!! I am Neha, I have been working on UiPath Tool since 2018 and have learnt a lot from this forum since then and today I finally signed up to explore and express my learnings with others. I believe this is a great platform to learn and grow as this is one stop for all our UiPath Queries. Excited to learn and explore!!

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 2 likes!

Filter data and write data to another excel (By use Linq)?

Hi @Maria99 try this linq query dt2=dt1.AsEnumerable().Where(Function(row) row(“Recheck”).ToString.Trim.Equals("")).CopyToDataTable.DefaultView.ToTable(False,“mobile”) this dt2 should be written to another excel using write range Regards, Nived N

This solution provided by @shinji received 1 likes!

Configファイルの格納場所と扱いについて

ReFrameWorkを使っているとのことですが、もしOrchestratorを使用しているならアセットにConfigのパスを記載する方法も考えられます。 もしOrchestratorを使用していないのなら、設定ファイルを「デスクトップ」に配置して 「特殊フォルダーのパスを取得」アクティビティでパスを自動解決する方法もあります。 こちら、参考になるかわからないですが、どうぞ。

This solution provided by @Gokul001 received 1 likes!

AddDays(-1) adds on months instead of days

Hi @LDPens You can try with this expression Use Assign Activity (Subtract Days) DateTime.ParseExact(“01/07/2021”(“dd/MM/yyyy”),Globalization.CultureInfo.InvariantCulture).AddDays(-1).ToString(“dd/MM/yyyy”) Use Assign Activity (Subtract Month) DateTime.ParseExact(“01/07/2021”(“dd/MM/yyyy”),Globalization.CultureInfo.InvariantCulture).AddDays(-1).ToString(“dd/MM/yyyy”) Regards Gokul

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 24 August 2021

Top 3 Topics with Most Views

Trouble writing to excel for date format made by @Ryan_Nguyen with 40 views.

How to Convert string to IEnumerable<> made by @Tharatharan with 29 views.

HCL - Uipath Developer - Noida/Chennai/Pune/Bangalore - India - Full Time made by @Manikandan_Ckj with 28 views.

Top 3 Topics with Most Replies

Trouble writing to excel for date format made by @Ryan_Nguyen with 24 replies.

Use Try/Catch for popup window from system internal? made by @Maria99 with 20 replies.

Read Excel Row en Columns, no value = write into next available row made by @sirwa with 12 replies.

Top 3 Users Who Posted The Most

@kumar.varun2 made 22 posts!

@NIVED_NAMBIAR made 22 posts!

@ermanoj3101 made 15 posts!

Top 3 Most Liked Posts

This post made by @Eduardo_Morles received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hola! Me llamo Eduardo, soy venezolano viviendo en Chile. Estoy preparandome para mi certificacion, a traves del curso RPA Developer Foundation. Gracias por permitirme formar parte de esta comunidad…

This post made by @thijs.ledeboer received 2 likes!

Process Mining AppOne Error

Hi Michael, I think I helped you already in a call but for visibility, I’ll give the most likely causes for this here as well. The error which is thrown is a generic error that doesn’t give much information. But based on what you describe I think the error is in Event End. If you can see information in the basic connector but not in AppOne there is something wrong with these 3. In AppOne we expect input data to have a certain format (Case ID → Text, Activity → Text, Event End → Date + Time). I…

This post made by @Maria99 received 2 likes!

Use Try/Catch for popup window from system internal?

@Nithinkrishna popup from My app.

Top 3 Most Liked Solutions

This solution provided by @thijs.ledeboer received 2 likes!

Process Mining AppOne Error

Hi Michael, I think I helped you already in a call but for visibility, I’ll give the most likely causes for this here as well. The error which is thrown is a generic error that doesn’t give much information. But based on what you describe I think the error is in Event End. If you can see information in the basic connector but not in AppOne there is something wrong with these 3. In AppOne we expect input data to have a certain format (Case ID → Text, Activity → Text, Event End → Date + Time). I…

This solution provided by @melanie received 2 likes!

Get URL inside Attach Browser

Hi, Yes you can obviously use Get Attribute and the name of the attribute to use is simply url Good luck

This solution provided by @kumar.varun2 received 2 likes!

How to Convert Time In a Specific Format

@AKM_Robinuzzaman You can proceed like this [image] TimeSpan.FromSeconds( (CInt("0"+System.Text.RegularExpressions.Regex.Match(inputTime, "\d{1,2}(?=h)").ToString)*60*60)+ (CInt("0"+System.Text.RegularExpressions.Regex.Match(inputTime, "\d{1,2}(?=m)").ToString)*60)+ CInt(System.Text.RegularExpressions.Regex.Match(inputTime, "\d{1,2}(?=s)").ToString) ) Output [image] [image] [image]

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 25 August 2021

Top 3 Topics with Most Views

キーで一致する値を取得したい made by @HANAKO with 28 views.

Bring next row to current row made by @aqiff with 28 views.

Best Practices for Web browser based automation made by @Debartha_Mitra_DE with 26 views.

Top 3 Topics with Most Replies

How can we get multiple matches value from string and store in a variable from regex made by @naim1000 with 17 replies.

Extract Link from Email body, Please help made by @Hurmet_Noka with 15 replies.

Merging two column made by @HeartCatcher with 13 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 30 posts!

@lakshman made 21 posts!

@Yoichi made 16 posts!

Top 3 Most Liked Posts

This post made by @sonaliaggarwal47 received 2 likes!

OneDrive QUESTION AUTOMATION - STUDIO

Hi @Atejera, Refer below links on how to setup office 365: [How to Setup and use Microsoft Office 365 with UiPath - Full Tutorial] And below link talks about all the operations you can perform for onedrive. Regards Sonali

This post made by @sonaliaggarwal47 received 2 likes!

Reading a particular worksheet and invoke a certain workflow?

Hi @Kakooza-Allan-Klaus, I see you want to use 1 workflow only for Shell and Total however want to run part of logic conditionally. So when you are calling that workflow, how about passing sheet name as argument in that workflow and within that workflow, use a if-else block to drive changes to the sale logic based on sheet name this workflow was called. And when you are calling that workflow its inside a loop for reading worksheets one by one. Regards Sonali

This post made by @Gresilda_Balla received 2 likes!

Excel automation problem

Hi @Rakesh_Tiwari, I am sending you a short code that I think may help you. BlankProcess9.zip (37.3 KB)

Top 3 Most Liked Solutions

This solution provided by @sonaliaggarwal47 received 2 likes!

Reading a particular worksheet and invoke a certain workflow?

Hi @Kakooza-Allan-Klaus, I see you want to use 1 workflow only for Shell and Total however want to run part of logic conditionally. So when you are calling that workflow, how about passing sheet name as argument in that workflow and within that workflow, use a if-else block to drive changes to the sale logic based on sheet name this workflow was called. And when you are calling that workflow its inside a loop for reading worksheets one by one. Regards Sonali

This solution provided by @Yoichi received 1 likes!

キーで一致する値を取得したい

こんにちは エラー対応を除けば条件分岐は不要と思います。 イメージとしては以下の様になると思います。 [img20210825-3] データ１のRobotIDの中に、データ２のRobotIDが無いものがあれば、それの対応が必要になるかと思います。

This solution provided by @prasath17 received 1 likes!

Extract Link from Email body, Please help

Please show us what you tried and what did not work?? Please see below… [image]

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 26 August 2021

Top 3 Topics with Most Views

Write Excel formula into cell uipath made by @korhansuren with 52 views.

How To Rename An Existing Folder using text file in uipath made by @Ajit_Chowdary with 51 views.

How to use switch made by @Matthew2 with 42 views.

Top 3 Topics with Most Replies

How To Rename An Existing Folder using text file in uipath made by @Ajit_Chowdary with 21 replies.

Write Excel formula into cell uipath made by @korhansuren with 15 replies.

Removing Trailing Spaces in a variable made by @ieptus with 15 replies.

Top 3 Users Who Posted The Most

@Dawodm made 31 posts!

@prasath17 made 20 posts!

@HeartCatcher made 18 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 2 likes!

#FeatureBlog - 19.10 - Using regular expression (Regex) in the selector attributes

Hi @loginerror, Quite late to the party, but this is extactly what I was looking for. RegexSearch within selectors. BluePrism had this feature long ago so its nice to see UiPath support it too. The windows popup in different languages is different. By using the following alteration to the selector we avoided drastic changes to the code! If anyone else is facing the same issue, only a | is required to support multiple languages. <wnd app='chrome.exe' cls='#32770' title='Open|Åpne' matching:…

This post made by @Dhanushka_Karagaswewa received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, I’m DK and I’m new to UI path and I joined this forum to improve my knowledge in terms of the platform and to stay updated on new trends/updates

This post made by @Sonalk received 2 likes!

Check Email Address in Active Directory

Thanks @Jeroen @lukas.macas : I’ve got expected email id by using below activities. [image]

Top 3 Most Liked Solutions

This solution provided by @lukasziebold received 2 likes!

Read Part of Excel Based on Certain Column Value. Split One major Excel to Two parts

Hi Hurmet, I would probably: Iterate through the full DataTable with For Each Row and declare a variable for the RowIndex Get Cell Color with a range based on the RowIndex (careful, RowIndex 0 is usually row 2 in Excel) If the color is yellow, use that RowIndex to copy your rows to a new DataTable like this: NewDataTable = FullDataTable.AsEnumerable.Skip(PreviousIndex).Take(CurrentIndex - PreviousIndex + 1).CopyToDataTable Put the CurrentIndex as the PreviousIndex (+1) after and you can skip…

This solution provided by @Yoichi received 2 likes!

特定の日付が休日、祝日なら平日に移動する処理をしたいです。

こんにちは 基本的に曜日は日付で一意に決定されるので、日付だけのハンドリングにして、 必要時に曜日を算定する方がシンプルかと思います。 そのためデータ２に関してはDictionaryにするのではなく、対象日付を リストあるいは配列すれば十分かと思います。 データ１の各行の日付を評価して、「土曜日」または「日曜日」または「上記リスト中に日付がある」の いずれかに該当すれば、１日加算して、再度評価します。 上記に該当しない日が平日ですので、それを書き戻します。 これらをまとめると、例えば以下の様に実装できると思います。 [img20210826-1]

This solution provided by @Yoichi received 2 likes!

How to use switch

Hi, We can achieve it using dictionary and regex as the following, for example. [img20210826-3] Sample20210826-3.zip (3.1 KB) Hope this helps you. Regards,

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 27 August 2021

Top 3 Topics with Most Views

Regex with multiple values text made by @Fernando_Ferrari_Longato with 34 views.

Subtraction of the two columns made by @HeartCatcher with 34 views.

Remove duplicates in DT for specific columns and keep all column and values made by @prabhu_ponnusamy with 26 views.

Top 3 Topics with Most Replies

Subtraction of the two columns made by @HeartCatcher with 20 replies.

Copy Images From Image Path And replace It Into Another Folder made by @Ajit_Chowdary with 14 replies.

ReFramework - Can't get the next transaction item even though it hits a business exception made by @Jayavignesh_G with 13 replies.

Top 3 Users Who Posted The Most

@ppr made 27 posts!

@ermanoj3101 made 22 posts!

@NIVED_NAMBIAR made 16 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 3 likes!

How to Wait for an SAP Background Operation

Sometimes it is necessary to wait for an SAP background operation. This post briefly explains how this can be realized. This is very easy to implement with the sapReadyState attribute in a loop. [image] [image] As we can see here we have a simple do-while loop that is executed as long as the sapReadyState is false. Additionally a delay activity is included to save resources. That’s all. If a timeout is still needed, this can also be inserted quite simply by an if-condition with a break. [i…

This post made by @Anna_Thomas received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, Myself Anna Thomas. I am a student learning BTech CS and am an entrepreneur. I was really fascinated by what UiPath had always offered us and wanted to be a part of it. Really looking forward to learn new things and gain amazing experiences.

This post made by @AIROBOHUB received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi Every One, I Ch Srinivasa Rao having 19+ Years of Exp. in IT Industry and last 5+ Years I have been into RPA, and my last designation as employee was “Tech Arch Delivery Manger” in my last company Basically I’m from Hyderabad, Telangana, India

Top 3 Most Liked Solutions

This solution provided by @lakshman received 2 likes!

How to exclude "Null" and "0" and store to Array variable?

@Dorothy_lee Try below expression before converting it to array. Dt_keyword = Dt_keyword.Select("Name <> 'Null' or Name <> '0'").CopyToDataTable

This solution provided by @GreenTea received 2 likes!

How to store data if column name is null?

Hi @Dorothy_lee Please check this thread to add column header. Replace the square brackets to round brackets Or otherwise provide the column index, which starts at 0 instead of column name - Convert.ToString(row.Item(0))

This solution provided by @ppr received 2 likes!

Problems extracting the minimum date from a datatable

@JavXult RegisDT.AsEnumerable().OrderBy(Function (x) Convert.ToDateTime(x(“Date”).toString.Trim)).First() Or RegisDT.AsEnumerable.Min(Function (x) CDate(x(“Date”).toString.Trim)) [grafik] If it is failing, then in often cases the format is not valid / different set breakpoint debug and get paused open immediate panel run analyzer statement: dtData.AsEnumerable.Where(Function (x) Not DateTime.TryParse(x(“Date”).toString.Trim,nothing)).ToList

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 28 August 2021

Top 3 Topics with Most Views

How to extract string after specific string made by @Kavya_Mamidishetti2 with 35 views.

How to add data in an excel sheet into existing excel sheet? made by @miriam_ong with 29 views.

System.Data.SyntaxErrorException: Syntax error: Missing operand before 'In' operator made by @Dorothy_lee with 28 views.

Top 3 Topics with Most Replies

System.Data.SyntaxErrorException: Syntax error: Missing operand before 'In' operator made by @Dorothy_lee with 17 replies.

How to extract string after specific string made by @Kavya_Mamidishetti2 with 17 replies.

How to extract specific Text from notepad made by @adarsh_kotagiri with 11 replies.

Top 3 Users Who Posted The Most

@sonaliaggarwal47 made 18 posts!

@ppr made 13 posts!

@Dorothy_lee made 13 posts!

Top 3 Most Liked Posts

This post made by @kumar.varun2 received 2 likes!

Remove duplicate rows based on specific columns?

@Jon_G This can be done as follows [image] Instead of Build Data Table activity use the Read Range Activity to read the input excel file into the data table variable (inputDT) The LINQ used is given below ( From row In inputDT Group row By k1 = row("FIRST NAME").ToString.Trim, k2 = row("SURNAME").ToString.Trim, k3 = row("POLICY NO").ToString.Trim, k4 = row("START DATE").ToString.Trim Into grp = Group Select grp(0) ).CopyToDataTable Finally you can write the output in an excel file…

This post made by @kumar.varun2 received 2 likes!

System.Data.SyntaxErrorException: Syntax error: Missing operand before 'In' operator

Hi @Dorothy_lee Try This [image] Dt_keyword3. AsEnumerable. Where( Function (r) r.ItemArray.All(Function(item) Not (item.ToString.Equals(String.Empty) Or item.ToString.Equals("0"))) ).CopyToDataTable This will remove all the rows from the Data Table which contains one or more empty columns

This post made by @Karam_Abulawii received 1 likes!

Merging excel files based on File Name

Hello I’m Facing a problem when i merge excel files based on there names I Want the output 1 Excel Sheet For Each Company but i’m Getting a Merged Excel File For Each Of my Files i want the process to as dynamic as Possible But i Can’t Do it Please Find the Attached Zipped File For the Process To help Xocialive Task.zip (411.3 KB) the Data Folder Contains The Files After Running the Process Thanks in advance

Top 3 Most Liked Solutions

This solution provided by @kumar.varun2 received 2 likes!

Remove duplicate rows based on specific columns?

@Jon_G This can be done as follows [image] Instead of Build Data Table activity use the Read Range Activity to read the input excel file into the data table variable (inputDT) The LINQ used is given below ( From row In inputDT Group row By k1 = row("FIRST NAME").ToString.Trim, k2 = row("SURNAME").ToString.Trim, k3 = row("POLICY NO").ToString.Trim, k4 = row("START DATE").ToString.Trim Into grp = Group Select grp(0) ).CopyToDataTable Finally you can write the output in an excel file…

This solution provided by @kumar.varun2 received 1 likes!

System.Data.SyntaxErrorException: Syntax error: Missing operand before 'In' operator

@Dorothy_lee Try this Dt_keyword3. AsEnumerable. Where(Function (r) Not CDbl("0"+r("In").ToString).Equals(0)). Select(Function (fr) fr("In").ToString). ToArray This will give an array of the “In” Column with all the zeros and the null values removed If you do not want to remove the null and zero values, then use this Dt_keyword3. AsEnumerable. Select(Function (r) r("In").ToString). ToArray

This solution provided by @Manuel_Dominguez received 1 likes!

Unable to cast object of type ‘System.Double’ to type ‘System.String’ Error

Yeah it works you only need to change the type in the Query, you are using “OF String” and you need “Of Double” [image] Try it and let me know what happen

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 29 August 2021

Top 3 Topics with Most Views

Convert datatable into json format in object? made by @rpa13 with 29 views.

How to separate 1 sheet to several columns based on condition made by @Dorothy_lee with 28 views.

Excel 'No Response' error while Write Range made by @Dorothy_lee with 25 views.

Top 3 Topics with Most Replies

Error with GetAppCredential made by @adamikh96 with 13 replies.

Excel 'No Response' error while Write Range made by @Dorothy_lee with 12 replies.

How to separate 1 sheet to several columns based on condition made by @Dorothy_lee with 9 replies.

Top 3 Users Who Posted The Most

@Dorothy_lee made 13 posts!

@Hiba_B made 12 posts!

@ppr made 10 posts!

Top 3 Most Liked Posts

This post made by @lakshman received 2 likes!

How to separate 1 sheet to several columns based on condition

@Dorothy_lee First use Read Range activity to read the data from excel and it will give output as DataTable. Let’s say ‘dtAccountsData’. And then find unique account by using below expression. dtUniqueAccounts is of type DataTable. dtUniqueAccounts = dtAccountsData.DefaultView.ToTable(true,"Account") And then use ForEach Row activity to iterate one by one account as below. ForEach Row in dtUniqueAccounts dtAccount = dtAccountsData.Select("[Account] = '"+row("Accou…

This post made by @ppr received 2 likes!

Increase same valued data consecutively if occurs more than once

(From d In dtInputData Group d By k=d("Col1").toString.Trim Into grp=Group Let dpr = (grp.Count = 1) Let mba = grp.Select(Function (x,i) k & (i+1).toString).Cast(Of Object).toArray Let nraa = If(dpr, New Object(){k},mba) From ra In nraa Select r=dtOutputData.Rows.Add(ra)).CopyToDataTable

This post made by @Bachali received 1 likes!

Tutorial - Communicate with Jira through UiPath

Hi @PrankurJoshi i have sent you xaml file. Thanks for your support. Regards, Akhil B

Top 3 Most Liked Solutions

This solution provided by @Hiba_B received 1 likes!

Excel 'No Response' error while Write Range

You’re right: I did not notice that she was working with xlsm ! Thank you Then @Dorothy_lee you can only try with write range of excel application scope, and only these 2 options should be tried: before the write range, put a read range empty juste before your write range as explained here first be sure to remove your write range from any excel application scope. Then put your write range in its own excel application scope, and put a kill process and fill it this way (by opening your …

This solution provided by @ieptus received 1 likes!

Issue with Column in Excel Write Cell

Sorry Hiba, thats what your code does

This solution provided by @Hiba_B received 1 likes!

Create column as per Column's value and add data for same Employee in single row

Hi @RohitK ! Sure, here is a suggestion: Paid_or_not_paid.xaml (7.0 KB) Let us know if it does not work as expected or if the code needs more explanation

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 30 August 2021

Top 3 Topics with Most Views

一括入力したいです！ made by @HANAKO with 39 views.

Convert month to quarter made by @jarous with 37 views.

Is Match Activity made by @vaish.ayodhya with 36 views.

Top 3 Topics with Most Replies

Round Numbers. Make the Time numbers nice made by @Hurmet_Noka with 19 replies.

If "data scraping" data is specified as "dt_rr", is this data available in "excute query"? made by @S_Sim with 19 replies.

Two DataTable Query Issue made by @Abang_Jamuri_Abang_Shoker with 12 replies.

Top 3 Users Who Posted The Most

@ppr made 16 posts!

@Yoichi made 16 posts!

@Hurmet_Noka made 11 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

Convert month to quarter

Hi, How about the following steps? First, define the following dictionary in advance. dict = New Dictionary(Of String,String)From{{"Jan","Q1"},{"Feb","Q1"},{"Mar","Q1"},{"Apr","Q2"},{"May","Q2"},{"Jun","Q2"},{"Jul","Q3"},{"Aug","Q3"},{"Sep","Q3"},{"Oct","Q4"},{"Nov","Q4"},{"Dec","Q4"}} Then dict(MonthName(today.month-1,true)) returns quarter. Regards,

This post made by @ppr received 3 likes!

Convert month to quarter

[grafik]

This post made by @mitul_choudhary received 2 likes!

Fetching info from pdf format

Hi, as highlighted i want the to fetch few information from the bill and print it on excel let say Port Code :INNSA1 [image] @Nithinkrishna please help on this case…!!

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

Convert month to quarter

Hi, How about the following steps? First, define the following dictionary in advance. dict = New Dictionary(Of String,String)From{{"Jan","Q1"},{"Feb","Q1"},{"Mar","Q1"},{"Apr","Q2"},{"May","Q2"},{"Jun","Q2"},{"Jul","Q3"},{"Aug","Q3"},{"Sep","Q3"},{"Oct","Q4"},{"Nov","Q4"},{"Dec","Q4"}} Then dict(MonthName(today.month-1,true)) returns quarter. Regards,

This solution provided by @Yoichi received 2 likes!

Uipath changes the comma to a dot, when reading excel

Hi, Can you try to use the following expression in Assign activity before ExcelApplicationScope? System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("es-ES") [img20210831-1] Note: This will affect not only number format but also datetime format etc. Regards,

This solution provided by @ppr received 2 likes!

Round Numbers. Make the Time numbers nice

so you are looking for a round to the closest 5 segement and not 15? tsInit.AddMinutes(- tsInit.Minute).AddMinutes(Math.Round(tsInit.Minute / 5) * 5).toString(“HH:mm”)

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.