Forum Engagement Daily Reports

[system]

Daily Forum Report | 09 October 2022

Top 3 Topics with Most Views

How to Split a String, check in below screenshot made by @Manju_Reddy_Kanughula with 42 views.

Downloading google sheet and saving as excel in a particular folder anywhere in the system made by @Swati4 with 36 views.

I get an error when I try to read the files I downloaded via http request made by @Mert_Samet_Sonmez with 33 views.

Top 3 Topics with Most Replies

I get an error when I try to read the files I downloaded via http request made by @Mert_Samet_Sonmez with 15 replies.

Downloading google sheet and saving as excel in a particular folder anywhere in the system made by @Swati4 with 10 replies.

Split text seperately made by @Learner007 with 9 replies.

Top 3 Users Who Posted The Most

@sreejith.ss made 16 posts!

@Mert_Samet_Sonmez made 9 posts!

@Emira made 7 posts!

Top 3 Most Liked Posts

This post made by @Marius_Puscasu received 2 likes!

Is there have a roadmap about RPA journey? include Step, Roles, Responsibilities?

Hello @donghai , I tend to believe that “A Day in the Life of an RPA Developer” course is what you are looking for. [image] This is the link: https://academy.uipath.com/courses/a-day-in-the-life-of-an-rpa-developer- Hope it helps! Best regards, Marius

This post made by @Itsuki_Noro received 1 likes!

プロジェクトを開けない、作れない

度々のご返信ありがとうございます。 ＞nugetの参照先の設定を変更するか、 おそらく、これで解決になりました！ 一応インストール設定を記載すると、カスタム→全てのユーザー→ユーザーモード→Orchestrator指定→既定のダウンロード先を全てのユーザーがアクセス出来るファイルサーバーに指定→オンラインフィードを無効化にチェック で新規の作成は行えるようになりました。 ただ、相変わらず既存プロジェクトは止まってしまって開けないので、オンライン下でプロジェクトを開けたユーザーのpackageフォルダから、共有のnugetの参照先にコピペすると、オフラインでもちゃんと開きました。 この操作はローカルのユーザーフォルダに対しては効果がなかったのですが…。 以下、情報として一応記します。 ＞まずStudioのバージョンはいくつをお使いでしょうか？ 2022.4.5です。 ＞インストールモードは何を選択されていますか？ 上記の設定のうち、ユーザーとサービス、オンラインフィードの無効化のオンオフ、は試しましたが、変わりませんでした。 ＞またインターネット接続環境では正しく…

This post made by @marian.platonov received 1 likes!

Studio v2022 and MV2 Extension?

In UiPath Studio 2022.4.4, the new UiPath Extension for Edge, based on Chrome’s Manifest V3 (MV3) standard, has been released. This patch also brings a few improvements for the Chrome MV3 extension that was initially released with the first 2022.4 LTS version. According to the deprecation timelines published by Chrome and Edge, all existing MV2 extensions will stop working in January 2023. The new UiPath MV3 extensions are fully backward compatible, and we highly recommend that you upgrade and …

Top 3 Most Liked Solutions

This solution provided by @Marius_Puscasu received 2 likes!

Is there have a roadmap about RPA journey? include Step, Roles, Responsibilities?

Hello @donghai , I tend to believe that “A Day in the Life of an RPA Developer” course is what you are looking for. [image] This is the link: https://academy.uipath.com/courses/a-day-in-the-life-of-an-rpa-developer- Hope it helps! Best regards, Marius

---

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 | 10 October 2022

Top 3 Topics with Most Views

Use V8 JavaScript Engine via ClearScript Library with UiPath made by @StefanSchnell with 54 views.

How can i read data from the particular cells made by @Chippy_Kolot with 48 views.

Important Announcement: Deprecation of Test Manager API Version 1 made by @Gernot_Brandl with 40 views.

Top 3 Topics with Most Replies

How can i read data from the particular cells made by @Chippy_Kolot with 25 replies.

Write dataTable to excel with condition made by @fk48 with 13 replies.

Business Rule Exception : How to Skip typing values in web page field if data not found and continue with further execution? made by @Vaishnav_Tej with 11 replies.

Top 3 Users Who Posted The Most

@Sudharsan_Ka made 33 posts!

@Gokul001 made 31 posts!

@Emira made 20 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 3 likes!

Use V8 JavaScript Engine via ClearScript Library with UiPath

[Bridge] V8 is a JavaScript engine from Google which is used in the Chrome Browser, Node.js and other applications. It implements ECMAScript (the JavaScript standard) and WebAssembly. ClearScript from Microsoft is a dotNET assembly that makes it easy to add this kind of scripting to your UiPath workflow, because it contains the V8 engine in its native assembly packages. Compared to the approach of using Node.js, described in my tutorial, here the V8 engine is used via ClearScript and the integ…

This post made by @Gernot_Brandl received 3 likes!

Important Announcement: Deprecation of Test Manager API Version 1

Good morning everybody! As part of our continuous effort to improve Test Manager, we recently released version 2 of the Test Manager API. Version 2 comes with a lot of improvements (i.e. Test Manager authorization) and a more consistent URL scheme. This also means that version 1 will be discontinued as follows: Cloud: End of January 2023 MSI and Automation Suite: April 2023 Please make sure, you only use version 2 in future and migrate you V1 implementation to V2. In case you have any ques…

This post made by @abhishek.S received 2 likes!

How to print out nice JSON format in 'Message Box' in Activities

Hi, You can convert the data table to Jarray and pass the same Jarray to Message Box. Converting to Jarray JArrayVariable = Newtonsoft.Json.JsonConvert.DeserializeObject(Of Newtonsoft.Json.Linq.Jarray)(Newtonsoft.Json.JsonConvert.SerializeObject(DT)) Pass the JArrayVariable to Message box. JArrayVariable dataType : Newtonsoft.Json.Linq.Jarray Regards Abhishek

Top 3 Most Liked Solutions

This solution provided by @abhishek.S received 2 likes!

How to print out nice JSON format in 'Message Box' in Activities

Hi, You can convert the data table to Jarray and pass the same Jarray to Message Box. Converting to Jarray JArrayVariable = Newtonsoft.Json.JsonConvert.DeserializeObject(Of Newtonsoft.Json.Linq.Jarray)(Newtonsoft.Json.JsonConvert.SerializeObject(DT)) Pass the JArrayVariable to Message box. JArrayVariable dataType : Newtonsoft.Json.Linq.Jarray Regards Abhishek

This solution provided by @Yoichi received 1 likes!

Select内でContainsかLikeを利用する方法

こんにちは 以下試してみてください Aデータテーブル.Select("[Column1] Like '*"& str変数 &"*'").CopyToDataTable 今から習得するならLINQの方が良いように思えますが Aデータテーブル.AsEnumerable.Where(Function(r) r("Column1").ToString.Contains(str変数)).CopyToDataTable

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

Split text seperately

Hi @Learner007 Try this [image] strOutput = Regex.Replace(InputText," {2,}" ,Environment.NewLine)

---

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 | 11 October 2022

Top 3 Topics with Most Views

ステートマシンの利用タイミングについて made by @shunsuke.ogata with 39 views.

Get text and judge issue made by @Allen_Huang with 36 views.

Hello everyone, I have a large csv file more than 10 lakhs above rows is there when i read it i am not able to read it properly i got the error which is "Job stopped with an unexpected exit code: 0xE0434352" please help me guys made by @zaid.ahmad with 36 views.

Top 3 Topics with Most Replies

Hello everyone, I have a large csv file more than 10 lakhs above rows is there when i read it i am not able to read it properly i got the error which is "Job stopped with an unexpected exit code: 0xE0434352" please help me guys made by @zaid.ahmad with 19 replies.

Send mail using reframework dispatcher made by @Sandhya_Gajare with 18 replies.

Get Text : How to indicate particular element from pdf file? made by @Vaishnav_Tej with 17 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 52 posts!

@muhamed_fasil made 43 posts!

@Sudharsan_Ka made 29 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 4 likes!

How to Get File & Folder - Name | Path | Size | Creation time

Hello Everyone, I would like to present this post who are looking for the File and Folder Let Jump into the Tutorial We are look into some Modern activities Get Files in Folder Get the specific folder Get all the files in the subfolder Get Directories Get File and Folder Creation and Size Get Files in Folder Step 1 : Use Assign activity. LHS : Create an variable | ProjectPath | Variable Type -> String RHS : Environment.CurrentDirectory+"\" Step 2 : Use Assign activity. …

This post made by @Gokul001 received 3 likes!

[Part 1] Modern Activities - Find/Replace Value | Format Cells

Hello Everyone, Hope your are doing good I would like to present this post who are looking for the Modern Activities Very first thing is to Enable the Modern experience (from Classic) Go to → Activities Panel → Click on Filter → Select Show Modern. [image] Let Jump into the Tutorial we are look into some Modern activities Find/Replace Value Format Cells Note : We need to use Excel Process Scope and Use Excel File for all the above activities Excel Process scope Use Excel File …

This post made by @omer.ozturk received 2 likes!

Microsoft GraphAPI Entegration with UiPath - Send Mail

Hi Everyone, I prepared a document about the integration of GraphAPI with UiPath and how this connection can be established. This document is to understand the general concept and to show how the import to UiPath can be done. My main goal is to tell you about the project I created. In the project I have done, firstly, the authorization token is obtained by contacting Microsoft GraphAPI. Sending e-mails with the body in JSON format, which is also arranged with the received token, is carried out.…

Top 3 Most Liked Solutions

This solution provided by @muhamed_fasil received 2 likes!

Send mail using reframework dispatcher

@Sandhya_Gajare , Open System exception transition state [image] Then use send mail activity inside condition as below [image]

This solution provided by @pavithra_pavi received 2 likes!

Convert column datatype to String

@divya_Bhat , Have you tried using “Balareva actives” Here is the link : UiPath datatable aggregation| change data type of data table| group by - YouTube import BalaReva.EasyDataTable.Activities [image] use activity called change column type [image]

This solution provided by @Emira received 2 likes!

How to select the correct cell for typing into

Hi @Anived_Mishra Did you try using send Hotkey (tab) to jump to the next field? Click on the journal number use send hotkey (tab) to move to the next field (which is the appropriate description) Let me know if that works

---

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 October 2022

Top 3 Topics with Most Views

UiPath Community 2022.10 Stable Release - various Activities made by @andreea.oprita with 72 views.

UiPath Community 2022.10 Stable Release - Document Understanding made by @Monica_Secelean with 50 views.

How to count number of dates between two dates made by @sruthesanju with 47 views.

Top 3 Topics with Most Replies

Find 10th Character for each row of specific column made by @Kunal_Jain with 26 replies.

Convert xlsx file to csv made by @n.krishna.moorthy with 21 replies.

Find all fields having empty values made by @Shilpa_Mohanty with 18 replies.

Top 3 Users Who Posted The Most

@Sudharsan_Ka made 32 posts!

@Gokul_Jayakumar made 16 posts!

@Yoichi made 15 posts!

Top 3 Most Liked Posts

This post made by @Sudharsan_Ka received 3 likes!

Know about G Drive steps 1

Hello Everyone Let’s Learn and Let Learn. Checkout this for knowing about working with G Drive Activities First we will do the required set up okay…,

Now checkout the steps and do the required setup also leaving a video so that you can check that too

<a href="https://forum.uipath.com/t/g-suite-guidelines/474146" class="inline-onebox">G-Suite Guidelines</a> <a href="https://www.youtube.com/watch?v=okrKQemOKN0" class="inline-onebox">How …

This post made by @Yoichi received 3 likes!

If sunday, +1day is Monday

Hi, Can you try the following step? varDateTime = Datetime.ParseExact(in_DataTableDLV030.Rows(0)(3).ToString.SubString(0,10).Trim, “dd/MM/yyyy”, System.Globalization.CultureInfo.InvariantCulture) Then check if it’s Sunday. Condition is varDateTime.DayOfWeek=DayOfWeek.Sunday If Sunday, use AddDays method varDateTime = varDateTime.AddDays(1) Finally convert it to dd/MM/yyyy style string. varDateTime.ToString("dd/MM/yyyy") Regards,

This post made by @Monica_Secelean received 2 likes!

UiPath Community 2022.10 Stable Release - Document Understanding

UiPath Community 2022.10 Stable Release - Document Understanding This topic goes in-depth about the improvements in Document Understanding. To read about other products, please navigate to the main topic here. We’re happy to share with you our latest work - all the bits & pieces coming together in our 22.10 release Migration to .net5 cross-platform With this release, we’ve finished our efforts of migrating the packages contributing to the Document Understanding functionality to .n…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

If sunday, +1day is Monday

Hi, Can you try the following step? varDateTime = Datetime.ParseExact(in_DataTableDLV030.Rows(0)(3).ToString.SubString(0,10).Trim, “dd/MM/yyyy”, System.Globalization.CultureInfo.InvariantCulture) Then check if it’s Sunday. Condition is varDateTime.DayOfWeek=DayOfWeek.Sunday If Sunday, use AddDays method varDateTime = varDateTime.AddDays(1) Finally convert it to dd/MM/yyyy style string. varDateTime.ToString("dd/MM/yyyy") Regards,

This solution provided by @StefanSchnell received 2 likes!

Standalone UiExplorer client download?

Hello @Mr.Daniel, welcome in the UiPath Community. Yes, a standalone version is available. On the one hand via the UiPath Cloud Platform, choose on the right side the Resource Center and now you can download UIExplorer, but in your case is it not possible, so here the link: https://download.uipath.com/UiExplorer/UiExplorer.22.4.5.zip Best regards Stefan

This solution provided by @Yoichi received 2 likes!

How to find the number of dates in a month with month number

Hi, We need to input not only month but also year because of leap year. Can you try DateTime.DaysInMonth method as the following? [img20221012-4] 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 October 2022

Top 3 Topics with Most Views

Uiparhの更新について made by @r.nakanishi with 85 views.

Uipath更新後のバッチファイルが動かない made by @k1120 with 52 views.

Selectors with dynamic content made by @mti with 47 views.

Top 3 Topics with Most Replies

Remove new lines in a csv - Help made by @hurmet.noka with 22 replies.

Regarding the variable assigning in selector made by @Ram_Shiva_Reddy with 17 replies.

Send outlook mail msg activity run proper without error. but not sending any mail made by @Rahul_Thombare with 14 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 38 posts!

@Gokul001 made 35 posts!

@Sudharsan_Ka made 32 posts!

Top 3 Most Liked Posts

This post made by @pavithra_pavi received 4 likes!

Modern Experience Vs Classic Experience

Hey Everyone!!, Im back with another tutorial on Modern Experience Vs Classic Experience. Do you know that #uipath provides feature called “Modern Experience”, Now what is this Modern Experience, how we can enable this in our #uipathstudio To learn about this, Here is my YouTube video. go check it out!!! [Modern Experience Vs Classic Experience | UiPath | UiPath Studio]

This post made by @omer.ozturk received 3 likes!

Adding HTML interactable button to mail - Sending automatic reply mail

Hi Forum Community, In this topic, I will show you how to add interactive HTML buttons to the mail and modify it as desired. In addition, after the person clicks the button, it will automatically create a draft reply mail and we just have to press the send button. It may seem like it doesn’t have much use, but in processes that require approval from business units (especially in invoice processes), it will reduce the error rate to zero thanks to the ready-made mail content. After receiving the …

This post made by @Rahul_Unnikrishnan received 3 likes!

Last update Uipath 2022.10.1

@Marisa_Ontiveros1 Please check the below doc. Thanks

Top 3 Most Liked Solutions

This solution provided by @Rahul_Unnikrishnan received 3 likes!

Last update Uipath 2022.10.1

@Marisa_Ontiveros1 Please check the below doc. Thanks

This solution provided by @Yoichi received 1 likes!

Uipath更新後のバッチファイルが動かない

度々すみません –file オプションで直接.nupkgファイルを指定する場合は、動作するみたいですので、 こちらも選択肢の一つとして検討いただければと思います。

This solution provided by @nikhil.girish received 1 likes!

How to know in which unaatebded machine the process ran

Hi @Jayanth_Ts Just have it in your success/failure mail Something like this Robot name= Environment.getmachineName

---

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 October 2022

Top 3 Topics with Most Views

Visionary Educator 2022 Winners made by @martin.jvr with 313 views.

Get text "Save To" shows No Options Found for Excel source made by @adam.m2 with 50 views.

Mutilple tabs made by @venkateshcheeni09 with 44 views.

Top 3 Topics with Most Replies

I Could not able extract a table, out of 15 rows I am getting only 7. whats the alternative solution. I have used Data Scrapping & Table Extraction made by @Manju_Reddy_Kanughula with 18 replies.

Dictionary in Selectors made by @Harbansh_Singh with 14 replies.

Mutilple tabs made by @venkateshcheeni09 with 13 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 41 posts!

@muhamed_fasil made 36 posts!

@Sudharsan_Ka made 20 posts!

Top 3 Most Liked Posts

This post made by @martin.jvr received 15 likes!

Visionary Educator 2022 Winners

Dear UiPath Community & Academic Alliances, Since the launch of the UiPath Academic Alliance program back in 2019, more than 2,500 educators from around the world are offering UiPath Automation knowledge, skills, and employment opportunities to their students. My personal thanks go out to all the visionary educators around the globe for their continued commitment to building talent and developing students for their careers in Automation. This year, we take pride in recognizing the top 17 UiPa…

This post made by @loredana_ifrim received 2 likes!

Visionary Educator 2022 Winners

Congratulations everyone for all the fantastic work you’re doing!

This post made by @Gokul001 received 2 likes!

Read excel file and paste it to a different template of excel file

Hi @ldiaz You can also try with filter data table activity to get specific column You can pass the Input and Output DataTable [image] Check out this for your reference Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to replace white spaces with hyphen in data table?

Hi, FYI, another approach: If number of rows of your datatable is not very large, the following will work. [image] Regards,

This solution provided by @Gokul001 received 1 likes!

How to show Annotations in default sequence in UiPath Community version 2022.10.1

Hi @handyy You can disable this Hide sequence option and check it Go to => Setting → Design → disable Hide [image]

This solution provided by @Yoichi received 1 likes!

UiPath更新後にDictionaryがつかえなくなりました。

こんにちは ダブルクォーテーションの文字の問題の可能性があります。 当該式でダブルクォーテーションを使っている場合、その文字列が " であることを確認してください。もしそれ以外の “ 等を使っている場合は、 " に置き換えてみてください。

---

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 October 2022

Top 3 Topics with Most Views

Robot process execution not starting made by @WitzgaWJ with 41 views.

Assign rank to each student based on its Total Marks. (Ex..For highest marks rank should be 1 and so on.) made by @Monali_Vekariya with 31 views.

How to Uninstall update made by @vsivaraman81 with 29 views.

Top 3 Topics with Most Replies

Robot process execution not starting made by @WitzgaWJ with 13 replies.

How to concatenate two row data in particular column made by @Raja.G with 10 replies.

Assign rank to each student based on its Total Marks. (Ex..For highest marks rank should be 1 and so on.) made by @Monali_Vekariya with 7 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 21 posts!

@Sudharsan_Ka made 15 posts!

@sreejith.ss made 12 posts!

Top 3 Most Liked Posts

This post made by @Sudharsan_Ka received 1 likes!

How to calculate Rank according to student percentage

Okay so nothing complicated here @sagar.raval [image] In this assign i’m sorting the Obtained Marks in descending order with this expression dataoutput.AsEnumerable.OrderByDescending(Function(x)CDbl(x("Obtained marks").ToString)).CopyToDatatable Looping through each and every row of the datatable dataOutput Used look up datatable to get the rank count(With row index) and the FailedSubjectCount(With column value of AtKt column) If condition to check if FailedsubjectCout>0 True-> CurrentRow…

This post made by @sagar.raval received 1 likes!

How to calculate Rank according to student percentage

tysm for that detailed answer

This post made by @Yoichi received 1 likes!

Compiler error(s) encountered processing expression "pathFile".(2) : error BC30512: Option Strict On disallows implicit conversions from 'String' to 'ILocalResource'

Hi, If you use UiPath.System.Activites 22.4.4 or lower, can you try to upgrade it to 22.4.5 or 22.10.1? Regards,

Top 3 Most Liked Solutions

This solution provided by @Sudharsan_Ka received 1 likes!

How to calculate Rank according to student percentage

Okay so nothing complicated here @sagar.raval [image] In this assign i’m sorting the Obtained Marks in descending order with this expression dataoutput.AsEnumerable.OrderByDescending(Function(x)CDbl(x("Obtained marks").ToString)).CopyToDatatable Looping through each and every row of the datatable dataOutput Used look up datatable to get the rank count(With row index) and the FailedSubjectCount(With column value of AtKt column) If condition to check if FailedsubjectCout>0 True-> CurrentRow…

This solution provided by @Yoichi received 1 likes!

Compiler error(s) encountered processing expression "pathFile".(2) : error BC30512: Option Strict On disallows implicit conversions from 'String' to 'ILocalResource'

Hi, If you use UiPath.System.Activites 22.4.4 or lower, can you try to upgrade it to 22.4.5 or 22.10.1? Regards,

This solution provided by @supermanPunch received 1 likes!

Concatenation and Lookup in Linq

Hi @shivarajvp555 , Since it is a Simple update we usually go for For Each Row in Datatable method. But we could also check with a Shorter approach by using DataColumn Expression method. Try using an Assign Activity like below : DT.Columns("fullname").Expression = "ISNULL([firstname], '')+ISNULL([lastname], '')" Here, DT is your Input datatable, fullname is the column name to be updated, firstname and lastname are the columns whose values should be concatenated. Let us know if you are able…

---

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 October 2022

Top 3 Topics with Most Views

Save attachment activity - attachment type made by @esraa_elzoghby with 44 views.

Random Quests made by @lucasferreira.lf00 with 41 views.

構造化データを抽出の抽出件数がおかしい made by @web1 with 38 views.

Top 3 Topics with Most Replies

how to move to next element in dropdown made by @apoorva_mehta with 15 replies.

構造化データを抽出の抽出件数がおかしい made by @web1 with 13 replies.

How to extract matched data from any text? made by @Suggala_Tejaswi with 12 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 25 posts!

@supermanPunch made 15 posts!

@Sami_Rajput made 14 posts!

Top 3 Most Liked Posts

This post made by @brunabruno received 2 likes!

Item "In Progress" stuck in queue

Hello guys! When a Queue Item gets stuck in the UiPath Orchestrator queue with the status “In Progress”, by default within 24h it expires and its status is automatically updated to “Abandoned”. But, we don’t have to wait 24 hours to retrieve the item. With only 3 activities we solved this problem. First, use Get Queue Items to capture the items that are “In Progress” in the queue, filtering them through the QueueItemStates property. [Step 1] Then, loop through the it…

This post made by @Raja.G received 2 likes!

How to concatenate two row data in particular column

@supermanPunch @Tapan_Behera1 Thanks guys i got a solution Regards, Raja G

This post made by @Monali_Vekariya received 2 likes!

Assign rank to each student based on its Total Marks. (Ex..For highest marks rank should be 1 and so on.) in uipath

yes i am changing the look up data table and i got the output so thank you so much @supermanPunch and @Shubham_Dutta

Top 3 Most Liked Solutions

This solution provided by @jack.chan received 1 likes!

How to extract the substring from a data table column

@Sami_Rajput try this basically in for each row activity assign CurrentRow("Document") = System.Text.RegularExpressions.Regex.Split(CurrentRow("Document").ToString, "---")(0) uipathF.xaml (9.3 KB)

This solution provided by @Yoichi received 1 likes!

How to extract matched data from any text?

Hi, Sorry for multiple replies. If you need to pass variable as part of regex pattern, the following will help you, for example. arrtitle = {"MR","MS","MRS","MISS"} Then m = System.Text.RegularExpressions.Regex.Match(currentItem.Value,"(?<FIRSTNAME>.*)(?<TITLE>"+String.Join("|",arrTitle)+")$") Note: this assumes there is no special character in arrTitle. Regards,

This solution provided by @supermanPunch received 1 likes!

How to concatenate two row data in particular column

@Raja.G , Could you Check the below workflow : DT_ConcatenateColumnValue_BasedOnSpace.zip (10.1 KB) As we are supposed to concatenate the value to the previous row, we could first reverse the Datatable values, so that we can get the check the condition of spaces first and then append those values to the next row. In this way, we are actually adding the values to the Previous row in the original Datatable. Let us know if this doesn’t work. Thank you for the wishes

---

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 October 2022

Top 3 Topics with Most Views

Activity 'WriteTextFile' not working in UIPath 2022.10.1 made by @applicatiebeheer with 49 views.

Uipath web automation 22.10 error made by @Allen_Huang with 46 views.

Writing one variable in single line in Write Line activity made by @anjasing with 45 views.

Top 3 Topics with Most Replies

How to get the wrong records? made by @ozgecatak with 31 replies.

How to handle title selectors in web application made by @Baby123 with 21 replies.

Why is it the case that i am no table to see some packages made by @srividhya_ramamurthy with 20 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 36 posts!

@supermanPunch made 31 posts!

@Sudharsan_Ka made 28 posts!

Top 3 Most Liked Posts

This post made by @Manoj_Batra received 4 likes!

How to find uppercase words in a given sting using LINQ in UiPath

Problem statement : we need to extract the uppercase words in a given sentence and display it to the user Here is the sample phrase [SampleText] Drag the assign activity to the workflow, write the following query [Query] Run the code and see the live action YouTube : Find uppercase words in a given sting using LINQ in UiPath - YouTube Medium: How to find uppercase words in a given sting using LINQ in UiPath - Manoj Batra - Medium Code: UiPathSamples/11 - Find All Uppercase in…

This post made by @postwick received 2 likes!

How to find uppercase words in a given sting using LINQ in UiPath

There is a Matches activity that will do this for you using Regex… [image] You can use the Matches activity to get an array of all the matching words.

This post made by @pavithra_pavi received 2 likes!

UiPath Automation Cloud, Studio‌ Web.

Check out my latest #youtube video on Studio web👇 In this video I have explained, – what is Studio‌ Web? – what are all advantages of using Studio‌ Web –how to use Studio‌ Web? –actives available in Studio‌ Web – How to start running the process from studio web – Overview on Time based trigger –what are event based trigger –Overview on Event based Trigger [UiPath Automation Cloud, | Studio‌ Web]

Top 3 Most Liked Solutions

This solution provided by @Sudharsan_Ka received 1 likes!

Strmanipulation

HI @Arya_Squares Try this expression System.Text.RegularExpressions.Regex.Match(Input,"(?<=MACC/PAC-).*").ToString.Trim.Equals("No") [image] Not System.Text.RegularExpressions.Regex.Match(Input,"(?<=Max of subscriptions - ).*").ToString.Trim.Equals("0") [image] Not System.Text.RegularExpressions.Regex.Match(Input,"(?<=RHP=)\d+").ToString.Trim.Equals("0") [image] Not System.Text.RegularExpressions.Regex.Match(Input,"(?<=HSI=)\d+").ToString.Trim.Equals("0") [image] Not System.Text.Re…

This solution provided by @Yoichi received 1 likes!

Error: No compiled code to run error BC30561:

Hi, This message says you need to modify it as either of the following. Dim messages As List(Of Microsoft.Graph.Message) OR Dim messages As List(Of Amazon.SQS.Model.Message) Regards,

This solution provided by @Nithinkrishna received 1 likes!

Get value to DT from other DT using Linq

Hey @Hendaryie_Tjoeng Here it is, //Select is always to customize the view of the DT DT_Input.AsEnumerable.Select(Function(row) //DT Rows add function to create the new rows with matching values DT_Final.Rows.Add( //Item Array of Objects formation to add as a row { row("A").ToString.Trim, //First DT first column added as it is //For second column, we are trying to match and find from 2nd DT, if not adding empty string If(DT_Master.AsEnumerable.Any(Function(row2) row2("A").ToString.Trim.…

---

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 October 2022

Top 3 Topics with Most Views

How to keep 0 before number in excel using uipath made by @Raja.G with 56 views.

Unable to open workflow made by @Manoj_Advitote with 51 views.

実行するにはコンパイルする必要があります made by @111860 with 43 views.

Top 3 Topics with Most Replies

0'zero' already belong to this datatable made by @guptasweb with 36 replies.

Re-Framework performer with queue made by @Sandhya_Gajare with 20 replies.

Read full PDF is missing made by @BBCC_0000 with 18 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 80 posts!

@Sudharsan_Ka made 43 posts!

@supermanPunch made 28 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

Instead of Add to Collection

We would use String.Join(", ", sarasas) and not String.Format

This post made by @Rahul_Unnikrishnan received 2 likes!

Multiple screnshots and copy into word file

Hello @I_am_Praj Welcome to Uipath community…! To take the screenshot you can use the Take screenshot activity and to attach that to word document you can use the word package. If the format is same you can create a Word Template with the bookmarks. There you can add the images. [Uipath- Word activities & Bookmark to create custom reports|Practical Demo] Thanks

This post made by @Gokul001 received 2 likes!

2022.10 Release is causing Compilation errors for Date conversions

Hi @Marco_Willigenburg Check the Double Quotation " in the Date Try with this expression "\kotvs003\KOT\Works\Poldat\Controlling\PBI\MPZW\InventoryPBI\Material Usage Per Month\Material Usage Per Month"+now.AddMonths(-1).ToString("MMyyyy")+".xlsx" Check out this thread Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

2022.10 Release is causing Compilation errors for Date conversions

Hi @Marco_Willigenburg Check the Double Quotation " in the Date Try with this expression "\kotvs003\KOT\Works\Poldat\Controlling\PBI\MPZW\InventoryPBI\Material Usage Per Month\Material Usage Per Month"+now.AddMonths(-1).ToString("MMyyyy")+".xlsx" Check out this thread Regards Gokul

This solution provided by @vishal.kp received 1 likes!

Remove characters from String

Hi @Paul_Andrei_Turcu , Refer to the below screenshot. [image] Happy Automation!

This solution provided by @Yoichi received 1 likes!

Count specific column value

HI, Can you try the following expression? dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("id").ToString, r("country").ToString)).Select(Function(g) dt.Clone.LoadDataRow({g.key.Item1.ToString,g.Key.Item2,g.Count.ToString},False)).CopyToDataTable() Sample20221018-3v2.zip (2.8 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 | 19 October 2022

Top 3 Topics with Most Views

Convert String made by @Sandhya_Gajare with 47 views.

How to convert secure string to string in uipath made by @shankar.arekonda.external with 45 views.

How to extract data between particular rows from excel? made by @Suggala_Tejaswi with 45 views.

Top 3 Topics with Most Replies

Convert String made by @Sandhya_Gajare with 30 replies.

How to convert secure string to string in uipath made by @shankar.arekonda.external with 23 replies.

How to import Packages in uipath made by @divya.17290 with 20 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 65 posts!

@Sudharsan_Ka made 41 posts!

@supermanPunch made 24 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 4 likes!

How to read excel

Hi @divya.17290 , Could you try with the Steps below : Read the Data from Excel using Read Range Activity, Get the Output as Datatable. Next, We use Look Up Datatable Activity to get the Index of the row and value of CPT for the matching Claim Number. Next, We can use Skip and Take Linq methods to get the rows we need and then select the CPT Values with the help of below Linq : cptValues = {cptValue}.Concat(DT.AsEnumerable.Skip(rowIndex+1).TakeWhile(Function(x)String.IsNullOrWhiteSp…

This post made by @Yoichi received 2 likes!

Excelファイルパスの一部に変数を使用したい

こんにちは 入力ダイアログからの文字列変数をvarInputとすると "C:\Users\"+varInput+"\OneDrive - jjjj\デスクトップ\フォーマット.xlsx" または System.IO.Path.Combine("C:\Users",varInput,"OneDrive - jjjj\デスクトップ\フォーマット.xlsx") をお試しいただければと思います。

This post made by @Gokul001 received 2 likes!

Convert String

Hi @Sandhya_Gajare Assign activity ReverseStr = strName.ToString.Split(" "c)(1)+","+strName.ToString.Split(" "c)(0) If activity ReverseStr.Contains(ExcelName) Check out the screenshot [image]

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 4 likes!

How to read excel

Hi @divya.17290 , Could you try with the Steps below : Read the Data from Excel using Read Range Activity, Get the Output as Datatable. Next, We use Look Up Datatable Activity to get the Index of the row and value of CPT for the matching Claim Number. Next, We can use Skip and Take Linq methods to get the rows we need and then select the CPT Values with the help of below Linq : cptValues = {cptValue}.Concat(DT.AsEnumerable.Skip(rowIndex+1).TakeWhile(Function(x)String.IsNullOrWhiteSp…

This solution provided by @Yoichi received 2 likes!

Excelファイルパスの一部に変数を使用したい

こんにちは 入力ダイアログからの文字列変数をvarInputとすると "C:\Users\"+varInput+"\OneDrive - jjjj\デスクトップ\フォーマット.xlsx" または System.IO.Path.Combine("C:\Users",varInput,"OneDrive - jjjj\デスクトップ\フォーマット.xlsx") をお試しいただければと思います。

This solution provided by @Gokul001 received 2 likes!

Convert String

Hi @Sandhya_Gajare Assign activity ReverseStr = strName.ToString.Split(" "c)(1)+","+strName.ToString.Split(" "c)(0) If activity ReverseStr.Contains(ExcelName) Check out the screenshot [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 | 20 October 2022

Top 3 Topics with Most Views

Microsoft.Activities.Extensions - missing availability for projects not set to Windows - Legacy made by @Antonio_Campos1 with 44 views.

Writing Insert Query in uipath studio made by @KavinduPerera with 40 views.

Studio CE版の自動更新が失敗し22.10.1と22.4.3両方存在しアンインストールできない made by @megDonuts with 40 views.

Top 3 Topics with Most Replies

Writing Insert Query in uipath studio made by @KavinduPerera with 19 replies.

Check c drive folder made by @C99 with 16 replies.

Creating seperate excel based on dates made by @sruthesanju with 16 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 55 posts!

@Sudharsan_Ka made 48 posts!

@supermanPunch made 32 posts!

Top 3 Most Liked Posts

This post made by @Folorunso received 3 likes!

Meet the UiPath Student Developer Champions 2022-2023!

I’m fortunate to have you as my mentor. Thank you for the great skills and knowledge you’ve imparted to me.

This post made by @Naoko_Sato received 3 likes!

ローカリゼーション品質満足度調査へのご協力のお願い

こんにちは！ UiPath製品のユーザーインターフェイスとドキュメントポータルの日本語化を担当している、プロダクトトランスレーションチーム（PTチーム）です。 このたび、PTチームではローカリゼーション品質満足度調査を実施することとなりました。普段UiPath製品やユーザーガイドをご利用いただく中で感じていることについて、ユーザーの皆さんの率直なご意見を大募集中です。本調査には2022年11月11日までご回答いただけます。 また、弊社Webサイトのデベロッパーブログに私たちのチームの紹介記事も掲載しました。UiPath製品の日本語化を進める中でチームが行ってきた、業務効率化に向けたさまざまな取り組みについて綴っています。お仕事の息抜きがてら、ぜひご覧になってみてください！

This post made by @afe.araromi received 2 likes!

Meet the UiPath Student Developer Champions 2022-2023!

The #uipathcommunity keeps building lives and contributing to career development for both students and professionals around the globe. Congrats to all the Student Developer Champions!! Kudos to my mentee, @Folorunso for this special recognition.

Top 3 Most Liked Solutions

This solution provided by @Emira received 1 likes!

Group data and sum only one of the groups in excel

Hi @Lynx Try this: Datatable1.AsEnumerable.Where(Function(x) x("col1").ToString.Equals("100")).Sum(Function(y) Cint(y("col2"))) Just change col1 and col2 with your column names. [image] Let me know if that works for you

This solution provided by @RajKumar_DC received 1 likes!

How to autoincrement cell index in Excel formula for Write Cell

Hi @mavsp8, Welcome to UiPath Community Create “Index” variable in For each Excel Row activity then user that variable in write cell activity [image] If not so use below method [image] Test.xaml (7.7 KB) Thanks, Rajkumar

This solution provided by @Yoichi received 1 likes!

Studioxの繰り返し(各シート)で2つのブックのシートを交互に繰り返す方法

こんにちは いくつか方法ありそうですが、例えば、両方のワークブックのシート名をそれぞれリストに格納しておいて、それをイテレートすれば良いように思えます。以下サンプルです。 [img20221020-1] NewBlankTask18.zip (68 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 | 21 October 2022

Top 3 Topics with Most Views

Studio 2022.10 not working properly made by @mohamedalthaf with 38 views.

Under for each row made by @manoj_verma1 with 38 views.

Hi i got error made by @Halimah with 38 views.

Top 3 Topics with Most Replies

Get text in loop ans string concatenation made by @RACHEL_PAUL with 16 replies.

Job stopped with an unexpected exit code: 0xC00000FD made by @MAdona_salah with 15 replies.

How can I convert String to a Dictionary(Of String, String())? made by @bibalesecret with 14 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 38 posts!

@Gokul001 made 34 posts!

@Rahul_Unnikrishnan made 32 posts!

Top 3 Most Liked Posts

This post made by @Desiree_Gil_Corral received 2 likes!

Ciphix - RPA Developer - Rotterdam - Netherlands - Full Time

Job title: RPA Developer Job role: RPA Developer Country: Netherlands City: Rotterdam Company name: Ciphix Employment Type: Full Time Seniority level: Associate 3 to 5 years Job Description: Ciphix is a Rotterdam-based IT implementation company dedicated to helping organizations unlock human potential through smarter business process automation. With an integrated approach to RPA and Machine Learning, we’re able to offer our clients – including global brands and government organizations …

This post made by @Gokul001 received 2 likes!

Not able to see Bala reva packages after the latest studio update

Hi @muhamed_fasil In the targetFramework - Window Legacy you can find the Balareva Package [image] UiPath Studio Version [image] In the targetFramework - Windows I don’t see the BalaReva Package [image] Regards Gokul

This post made by @supermanPunch received 2 likes!

Not able to see Bala reva packages after the latest studio update

Hi @muhamed_fasil , As the latest updates requires all packages to be compatible with .Net 6 ,some of the packages (Even UiPath Packages) are not available. Although I do not have the updated version, but it is a common occurring issue/post in forum. Check the below post :

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

Not able to see Bala reva packages after the latest studio update

Hi @muhamed_fasil In the targetFramework - Window Legacy you can find the Balareva Package [image] UiPath Studio Version [image] In the targetFramework - Windows I don’t see the BalaReva Package [image] Regards Gokul

This solution provided by @ppr received 2 likes!

How can I convert String to a Dictionary(Of String, String())?

when this string from excel “New Dictionary(Of String,String())From{{“010”,{“gesperrt”,“in Erstellung”,“im Hintergrund”,“in Bearbeitung”,“fehlerhaft”,“neu”}}}” should be used as VBCode code then you are blocked as compiling cannot be bypassed How about: stroring dictionaray as JSON String "{'010':['gesperrt','in Erstellung','im Hintergrund','in Bearbeitung','fehlerhaft','neu']}" Deserializing it to a dictionary [grafik] Newtonsoft.Json.JsonConvert.DeserializeObject(Of Dictionary(of St…

This solution provided by @Sudharsan_Ka received 1 likes!

How to assign value in datetime list variable

HI @Aleem_Khan Try like this New List(of DateTime) From{DateTime.ParseExact("4/5/2022 1:02 PM","d/M/yyyy h:mm tt",nothing),DateTime.ParseExact("4/5/2022 3:39 PM","d/M/yyyy h:mm tt",nothing),DateTime.ParseExact("4/5/2022 3:28 PM","d/M/yyyy h:mm tt",nothing),DateTime.ParseExact("4/5/2022 1:15 PM","d/M/yyyy h:mm tt",nothing)} To sort use this String.Join(",",list.OrderBy(Function(s) s)) [image] Hope this helps Regards Sudharsan

---

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 October 2022

Top 3 Topics with Most Views

How do I replace only certain characters of a filename? made by @ayeo22 with 39 views.

Error opening Excel file made by @chuan_ming_foo_from.tp with 35 views.

Chromeのプロセス名は？ made by @gorby with 35 views.

Top 3 Topics with Most Replies

How do I replace only certain characters of a filename? made by @ayeo22 with 34 replies.

Invoke Method (Rename) renames only filename1 when two filenames are similar made by @ayeo22 with 18 replies.

Not view the System Option made by @Castillo_Luis_Peru with 12 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 42 posts!

@ayeo22 made 31 posts!

@Sudharsan_Ka made 21 posts!

Top 3 Most Liked Posts

This post made by @lynnsong986 received 2 likes!

Multiple bots processing queue items and updating same excel workbook

I found some instructions on how to do this，thank you so much for your help!

This post made by @Gokul001 received 2 likes!

Need help with Excel formatting

HI @Sami_Rajput Check Out the XAML file GroupByLinq.xaml (18.7 KB) Output [image] Regards Gokul

This post made by @supermanPunch received 2 likes!

Invoke Method (Rename) renames only filename1 when two filenames are similar

@ayeo22 , Using this Expression in the second iteration, you might be picking up the renamed file again. You Should Store the file paths or the excel and pdf file path collection in two different collection variables (Array/ List of String), then use the collection variables instead of Directory.GetFiles("") pdfFilePaths = Directory.GetFiles("C:\XXX","*.pdf").ToArray excelFilePaths = Directory.GetFiles("C:\XXX","*.xlsx").ToArray Your Parameters in Invoke Method would then be : First argum…

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

Need help with Excel formatting

HI @Sami_Rajput Check Out the XAML file GroupByLinq.xaml (18.7 KB) Output [image] Regards Gokul

This solution provided by @supermanPunch received 2 likes!

Invoke Method (Rename) renames only filename1 when two filenames are similar

@ayeo22 , Using this Expression in the second iteration, you might be picking up the renamed file again. You Should Store the file paths or the excel and pdf file path collection in two different collection variables (Array/ List of String), then use the collection variables instead of Directory.GetFiles("") pdfFilePaths = Directory.GetFiles("C:\XXX","*.pdf").ToArray excelFilePaths = Directory.GetFiles("C:\XXX","*.xlsx").ToArray Your Parameters in Invoke Method would then be : First argum…

This solution provided by @jack.chan received 1 likes!

Excel Sheets formatting - need help

use this @Sami_Rajput Sequence7.xaml (15.6 KB) result (written to result.xlsx) [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 | 23 October 2022

Top 3 Topics with Most Views

Microsoft.Activities Package not found in any feed, NU1202 made by @mlevine with 40 views.

Set one default value for the entire fixed array made by @esraa_elzoghby with 35 views.

URL入力欄をテキストボックスに変更したい made by @gorby with 31 views.

Top 3 Topics with Most Replies

Get value from specific cell datatable1 and write it in specific datatable2 made by @ldiaz with 9 replies.

Get text save to excel is not showing made by @Siva_Ranjan with 8 replies.

Can't Use UiPathTeam.Interactive.Activities after uipath is updated made by @kunal.deshmukh with 6 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 6 posts!

@Rahul_Unnikrishnan made 6 posts!

@Sudharsan_Ka made 5 posts!

Top 3 Most Liked Posts

This post made by @Sudharsan_Ka received 4 likes!

Happy and safe diwali

Hello friends and uipath family!!! Wishing you happy and safe Diwali to you and your family. Love you all… Let’s learn and let learn!! Regards Sudharsan

This post made by @ptrobot received 2 likes!

Set one default value for the entire fixed array

You could use Repeat(). myArray = Enumerable.Repeat("Mango", 10).ToArray

This post made by @Rahul_Unnikrishnan received 1 likes!

Get value from specific cell datatable1 and write it in specific datatable2

Hello @ldiaz You can use below expression to get value from first datatbale str_output = Datatable1.Rows(rowindex)(“columnname”) Below expression to write to Datatable2 Datatable2.Rows(rowindex)(“yourcolumnname”) = “str_output” Thanks

Top 3 Most Liked Solutions

This solution provided by @ptrobot received 2 likes!

Set one default value for the entire fixed array

You could use Repeat(). myArray = Enumerable.Repeat("Mango", 10).ToArray

This solution provided by @ppr received 1 likes!

Random generator not so random?

@Andre_Santos Welcome to the forum give try at following: Define a variable: name: myRandom | DataType: System.Random | DefaultValue: new Random() Whenever you want to generate a random number use the following statement: myRandom.Next() Mod dtData.RowCount we just let us generate a more wide range of numbers and with the modulo operation we bring it to the restricted slot. When doing this we encountered a better distributed random result

---

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 October 2022

Top 3 Topics with Most Views

Roles and Responsibilities for your RPA Resume made by @Vajrang with 162 views.

Modern Activities Not Working if System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("de-de") made by @sava.tomov with 53 views.

Convert array string to integer made by @Aguirre with 40 views.

Top 3 Topics with Most Replies

Convert array string to integer made by @Aguirre with 22 replies.

Matches RegEx activity made by @ELISA_ARTALEJO_BARINAGA with 11 replies.

Expression activity type 'VisualBasicValue'1' requires compilation in order to run made by @Short with 11 replies.

Top 3 Users Who Posted The Most

@Sudharsan_Ka made 28 posts!

@supermanPunch made 23 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @sava.tomov received 9 likes!

Modern Activities Not Working if System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("de-de")

Hello, we noticed the following bug in UiPath Studio with Modern Activities. They DO NOT work properly if System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo(“de-de”) is set. Any culture info that interprets comma as decimal separator has the same issue. [image] If the culture info is set to “en-us”, the same activity works properly. [image] The desribed bug is observed with the following dependencies: UiPath.System.Activities 22.10.2 + UiPath.UIAu…

This post made by @charliefik received 1 likes!

RPA Developer Foundation - Feedback Space

Data Manipulation With Lists And Dictionaries course. There are a couple of issues with this course I think The documents at the end are all about regex (theres also one link that says date time but takes you to regex page) they look like the document list from the string manipulation course. In the Practice 2 Dictionaries there is a for each loop where in the solution the loop variable type has been set to system.collections.generic.KeyValuePair without any mention of what that is in any…

This post made by @sharon.palawandram received 1 likes!

Help us answer the topics where users are still waiting for your help

excellent idea!

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Extract date from string , the date format is not specific

refer to the cheat sheet linked above maybe a regex.IsMatch is what you are searching also we do have the success property [grafik]

This solution provided by @LeviGraff received 1 likes!

How to get the last row index of a Specific column in a DT?

You could loop through each row, check if your column is null or empty with String.IsNullOrEmpty(yourRow(“YourColumn”).ToString), and if false use the index from the for loop - 1 as your row number.

This solution provided by @Kyleb91 received 1 likes!

Display Datatable in a UiPath Action Center Form

I got it! I imported Datatable type, using data grid and text fields, the field properties need to be EXACT matches to the column names… I had a couple of spaces in between header names… Thanks!

---

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 October 2022

Top 3 Topics with Most Views

How to retrieve specific data from a txt file? made by @Kumar_Sahu_Sameer with 51 views.

Use if condition made by @guptasweb with 51 views.

How to get the amount matches with the input made by @sruthesanju with 48 views.

Top 3 Topics with Most Replies

How to get the amount matches with the input made by @sruthesanju with 27 replies.

Use if condition made by @guptasweb with 27 replies.

HRESULT からの例外:0x80131040 made by @miwa_yamamoto with 20 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 56 posts!

@Yoichi made 22 posts!

@guptasweb made 22 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

UiPath.PDF.Activitiesがダウンロードできない

こんにちは どうやら22.10ではオフィシャルフィードが従来と異なる場所が設定されているようです。 そこに必要なパッケージが無いためインストールできなくなっています。 そこでパッケージ管理→設定で下記のURLをフィードとして追加してもらえますでしょうか？（名前はOfficial_Old等適当なものをつけて） https://www.myget.org/F/workflow/api/v3/index.json 追加し終わったらPDFパッケージを再度導入してみてください。

This post made by @GT_Ropa received 2 likes!

Get the count of column

Hi @agathiyanv Try this please. [image] dt.AsEnumerable().Where(Function(row) Not String.IsNullOrWhiteSpace(row(“Column1”).ToString)).CopyToDataTable.RowCount count is a int32 variable dt is a name of datatable Column1 is a name of the column

This post made by @supermanPunch received 2 likes!

Regex Error Ui

@d.ulutas , Try updating to the below Expression : (?<=Supplier Item no\r?\n).*

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

UiPath.PDF.Activitiesがダウンロードできない

こんにちは どうやら22.10ではオフィシャルフィードが従来と異なる場所が設定されているようです。 そこに必要なパッケージが無いためインストールできなくなっています。 そこでパッケージ管理→設定で下記のURLをフィードとして追加してもらえますでしょうか？（名前はOfficial_Old等適当なものをつけて） https://www.myget.org/F/workflow/api/v3/index.json 追加し終わったらPDFパッケージを再度導入してみてください。

This solution provided by @GT_Ropa received 2 likes!

Get the count of column

Hi @agathiyanv Try this please. [image] dt.AsEnumerable().Where(Function(row) Not String.IsNullOrWhiteSpace(row(“Column1”).ToString)).CopyToDataTable.RowCount count is a int32 variable dt is a name of datatable Column1 is a name of the column

This solution provided by @supermanPunch received 2 likes!

Regex Error Ui

@d.ulutas , Try updating to the below Expression : (?<=Supplier Item no\r?\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 | 26 October 2022

Top 3 Topics with Most Views

Compare two excel sheet and get the data as per coondition made by @lokeshkumar.k with 39 views.

Regex Equation Help made by @amruta_George with 36 views.

How can I split Excel Data into multiple workbooks/files based on rows in Excel? made by @Israel_Silva with 35 views.

Top 3 Topics with Most Replies

Need to append datatable if the next value is already present made by @sruthesanju with 19 replies.

Read all file excel in folder and write range made by @gilang_ramadhan123 with 19 replies.

UiPath How to loop through rows and columns in Excel sort search inputbox made by @Pru with 17 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 57 posts!

@Sudharsan_Ka made 44 posts!

@anon88744563 made 20 posts!

Top 3 Most Liked Posts

This post made by @Pamela_Sibaja received 2 likes!

Compare two excel sheet and get the data as per coondition

Hi Lokeshkumar, In mi case, I used the LINQ query to match the correct comment. Do you need this result for the data table named Test1? [image] Example: DATA PROCESSING.xaml (9.2 KB) Have a great day! Please let me know if you need anything else.

This post made by @Gokul001 received 2 likes!

UiPath How to loop through rows and columns in Excel sort search inputbox

Hi @Pru Welcome to Uipath community As @Tapan_Behera1 Suggestion You can use For Each Row in DataTable activity to loop through all the row. Regards Gokul

This post made by @WYTham received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi all, I’m from Kuala Lumpur, Malaysia. I’ve been doing UiPath for half a year and happy to get alot of solutions from this forum. I’m here to learn more from the peers and get some feedback or solutions. One day hopefully I can also contribute to the answers to new peers. Cheers.

Top 3 Most Liked Solutions

This solution provided by @tudor.carean received 1 likes!

UiPath.DocumentUnderstanding.Persistence.OrchestratorException document understanding

The error message is not helpful at all unfortunately, and that will be fixed in a future version. It’s just how the .net httpClient behaves when you interrupt it while processing a response. It’s a strange kind of timeout caused by too much parallelism. The executor was doing too much work and didn’t manage to process a response that probably came in time. This can be easily fixed by setting a higher TimeoutMs value on the Create Validation Action activity, OR you could get rid of that Paralle…

This solution provided by @Roxana_Irinei received 1 likes!

[To be solved in 22.10.3] Modern Activities Not Working if System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("de-de")

Hello! This will be fixed with the upcoming version 22.10.3 of the UIAutomations package

This solution provided by @Gokul001 received 1 likes!

Help for understand selectors

Hi @mateo.drouillard Both are same, there is no any different between bot aaname tag is now mandatory for every website, it’s used to uniquely identify an element by Assistive Technologies. aaname stands for Active Accessibility name innertext tag is used to select the sample element in web page Check out the Documentation https://docs.uipath.com/studio/docs/about-selectors#:~:text=One%20of%20the%20ways%20in,shape%20of%20an%20XML%20fragment. [UiPath Selectos Tutorial | Full Tutori…

---

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 October 2022

Top 3 Topics with Most Views

What's wrong with this dynamic selector? made by @pprin001 with 45 views.

Learning Regex made by @Teck_Hwee_Goh with 42 views.

Round of decimals in string to 2 places made by @gokul1904 with 39 views.

Top 3 Topics with Most Replies

"message": "For each row: Collection was modified; enumeration operation might not execute." made by @gilang_ramadhan123 with 36 replies.

Exception has been thrown by the target of an invocation. assign activity made by @ldiaz with 15 replies.

How can I click on one bottom line in excel? made by @burak with 15 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 53 posts!

@Sudharsan_Ka made 46 posts!

@Yoichi made 33 posts!

Top 3 Most Liked Posts

This post made by @MAZO_YENDE received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, I am Mazo. I joined this forum because i am currently working on a school’s project. Looking forward to growing from learning from everyone.

This post made by @pratik.santani received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi Everyone, I am Pratik, a UiARD certified developer with experience of 3 years as UiPath Developer and 5 years as Web application developer using Java, Spring. I am here to share my knowledge and learnings with people who need it.

This post made by @ppr received 2 likes!

"Select type" popup not shown after use the "Add to dictionary" activity

@Arabic_Medical_ServiceVTN Welcome to the forum there are some issues / confusions onthis part caused by different reasons Instead add to dictionary you can do: Assign Activity YourDictVar(YourKey) = YourValue

Top 3 Most Liked Solutions

This solution provided by @Sudharsan_Ka received 2 likes!

While I'm trying to print the whole array value with help of a message box it's showing an empty message only

Hi @Kumar_Sahu_Sameer You should assign a array like {“Cat”,“Dog”,“Cow”,“Monkey”} Each should be seperated you are using inside single double quotes Use this Expression String.join(",",str_Array) Rrgards Sudharsan

This solution provided by @supermanPunch received 1 likes!

Extract Specific numbers from PDF

Hi @Justine , Could you try using the Regex Expression below : (?<=PAID-UP\s+,ORDINARY\s+SINGAPORE, DOLLARS\s+)[\d.,]+ [image] Expression : System.Text.RegularExpressions.Regex.Match(pdfText,"(?<=PAID-UP\s+,ORDINARY\s+SINGAPORE, DOLLARS\s+)[\d.,]+",RegexOptions.IgnoreCase).Value Let us know if this doesn’t work.

This solution provided by @Robert_Lansbergen received 1 likes!

Reframework settings

Hi @pauloengenharia5, [2022-10-27 20_56_10-RoboticEnterpriseFramework4_Windows - UiPath Studio Community] Check your Get TransactionItem activity in GetTransactionData.xaml in: [2022-10-27 20_55_17-Window] How do you retrieve your TransactionItem? Kind regards, Robert

---

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 October 2022

Top 3 Topics with Most Views

How to give datatable as input to append range activity? made by @RpaNoobMax with 42 views.

Http Request got excel format response, how to convert? made by @372402124 with 42 views.

Regex problem : working on regexr.com but not in UI path made by @Florent_Delage with 42 views.

Top 3 Topics with Most Replies

Http Request got excel format response, how to convert? made by @372402124 with 18 replies.

I want to scrap my page made by @Kuldeep_Pandey with 18 replies.

How to join two data table based on particular column made by @Raja.G with 13 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 93 posts!

@supermanPunch made 30 posts!

@Sudharsan_Ka made 27 posts!

Top 3 Most Liked Posts

This post made by @Manoj_Batra received 2 likes!

How to find element at a specific position from XML using LINQ in UiPath

Problem statement — We have an XML data file and need to extract the element at a specific position entered by the user in a dialog box [image] Import system.xml and system.xml.linq to the project. Now, add 2 assign activities to the workflow area and write the following code. [image] Query to Load xml file Now, write the query to get the element at a specific position [image] Here InputNumber is the integer variable entered by the user. As the numbering starts from 0 that is why we s…

This post made by @Gokul001 received 2 likes!

How to join two data table based on particular column

HI @Raja.G Check out the XAML file TwoDTJoinDataTable.xaml (16.0 KB) [image] Regards Gokul

This post made by @Raja.G received 2 likes!

How to join two data table based on particular column

@Gokul001 , @supermanPunch Thanks guys

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

Regex expression to extract numbers

@Justine , Maybe a Correction in the expression would work : (?<=PAID-UP ,ORDINARY\s+UNITED STATES OF\s+)[\d.,]+ System.Text.RegularExpressions.Regex.Match(yourText,"(?<=PAID-UP ,ORDINARY\s+UNITED STATES OF\s+)[\d.,]+").Value

This solution provided by @Gokul001 received 1 likes!

How to join two data table based on particular column

Hi @Raja.G How about this expression? (From data1 In Dt1.AsEnumerable() Join data2 In Dt2.AsEnumerable() On data1("XX no") Equals data2("XX no") Select DtClone.Rows.Add({ data2("XX no"),data1("Name"),data2("Status"),data2("Comment"),data2("Date")})).copytodatatable Check out the XAML file TwoDTJoinDataTable.xaml (12.4 KB) [image] Output [image] Hope it will helps Regards Gokul

This solution provided by @Gokul001 received 1 likes!

Choose current month dynamically

Hi @Justine How about this expression? Year = Now.Year.Tostring Monthnum =DateTime.Now.ToString("MM") MonthMMM = DateTime.Now.ToString("MMM") “V:\Finance\Systems-Risk-ERM\OrderToCash\C2C\ACRA Biz Profile\"+Year+"\"+Monthnum+". "+MonthMMM [image] 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.