Forum Engagement Daily Reports

[system]

Daily Forum Report | 03 June 2021

Top 3 Topics with Most Views

Possible to filter row by number of character made by @Anneng with 31 views.

Replacing text in Document doesn't work with string which contains "\r\n" made by @Assyl_Abetayev with 24 views.

Element Exist property.. understanding question made by @Latif with 22 views.

Top 3 Topics with Most Replies

Replacing text in Document doesn't work with string which contains "\r\n" made by @Assyl_Abetayev with 20 replies.

Converting String To Date In Desired Format made by @ashwin.ashok with 14 replies.

Possible to filter row by number of character made by @Anneng with 8 replies.

Top 3 Users Who Posted The Most

@postwick made 23 posts!

@Krishna_547 made 22 posts!

@Assyl_Abetayev made 11 posts!

Top 3 Most Liked Posts

This post made by @shinji received 2 likes!

長時間実行中のジョブを検知する方法はあるか？

ジョブのロングラン監視機能ほしいですよね。 OrchestratorはWebサーバーでイベント発生で動くので、現状、自分でタイマー実行が出来ない気がします。 監視用のロボットフローを作って、Orchestratorのスケジュール設定で実行させて、API叩いて検出するのが王道な気もしますが、 以下のような方法でも可能だと思います。 1）SQLServerのエージェントジョブで、ジョブテーブルから実行中で一定時間経過したものを抽出し、通知する（メールなど） 2）SQLServerまたはOrchestratorのタスクスケジューラトリガーで、SQLServerのジョブテーブルからSQLCMDまたはPowershell等からSQLで・・・同上 3）Orchestratorのタスクスケジューラトリガーで、OrchestratorのAPIから実行中で一定時間経過した・・・同上 4）他のマシンのタスクスケジューラトリガーで、OrchestratorのAPIから・・・同上 5）AzureFunction等のサーバーレスアプリで、OrchestratorのAPIから・・・同上 「2」は…

This post made by @Yoichi received 2 likes!

Data table dynamic code issue

Hi, How about the following? [img20210603-4] Main.xaml (8.6 KB) Regards,

This post made by @prasath_S received 2 likes!

Possible to filter row by number of character

Hi @Anneng Please try this dtTable - datatable dtTable = dtTable.asenumerable.where(function(d) d(“comments”).tostring.length <5).copytodatatable Thanks

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Data table dynamic code issue

Hi, How about the following? [img20210603-4] Main.xaml (8.6 KB) Regards,

This solution provided by @prasath_S received 2 likes!

Possible to filter row by number of character

Hi @Anneng Please try this dtTable - datatable dtTable = dtTable.asenumerable.where(function(d) d(“comments”).tostring.length <5).copytodatatable Thanks

This solution provided by @aitor.bengoetxea received 1 likes!

(DOCUMENT UNDERSTANDING)Export Extraction Result activitie Doesn´t work in orchestrator background process

I got the solution! The problem was not the Extraction Result activitie…The problem was because I have a realtive path on the “Wait” activitie. I have changed the path to this one and it works perfect: [image] Thanks @Lahiru.Fernando for your help!!

---

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 | 04 June 2021

Top 3 Topics with Most Views

I want to retrieve data from a table present in mail Body in outlook? it would be better if we can retrieve that table from mail in DataTable format made by @anjasing with 28 views.

How To Terminate Process in Middle of Whole Process? made by @hsendel with 25 views.

Format date in excel made by @fairymemay with 25 views.

Top 3 Topics with Most Replies

vbCrLf, Environment.NewLine doesn't work on Outlook made by @Wing_Ben_Wong with 16 replies.

How To Terminate Process in Middle of Whole Process? made by @hsendel with 12 replies.

I want to retrieve data from a table present in mail Body in outlook? it would be better if we can retrieve that table from mail in DataTable format made by @anjasing with 12 replies.

Top 3 Users Who Posted The Most

@ppr made 19 posts!

@postwick made 12 posts!

@Pankaj.Patil made 11 posts!

Top 3 Most Liked Posts

This post made by @mz3bel received 3 likes!

RPA France - Vulgarisation – Episode 3 : Comment faire ses premiers pas sur UiPath?

L’épisode 3 tant attendu est là !!! Comment faire ses premiers pas sur UiPath ? Comme pour tout langage informatique, crée ton premier “Hello, World” Si tu as raté l’épisode 2, tu peux retrouver le lien au bas de cet article Qu’est-ce que UiPath et pourquoi est-il utilisé ! L’un des outils d’automatisation les plus populaires, UiPath, est un outil d’automatisation de processus robotique utilisé pour l’automati…

This post made by @Pankaj.Patil received 2 likes!

I need to append date and time to the file name dynamically while using the move activity

@manjesh_kumar, Can you try with below? DestinationFolder+Path.GetFileNameWithoutExtension(SourceFolder)+"_"+Now.ToString(“dd.MM.yyyy”)+".txt"

This post made by @vasile.bujac received 2 likes!

API => GET Jobs not working

The order in which jobs are returned from odata/Jobs endpoint without any OData parameters isn’t technically defined. If you’d like to find out the status of the last job that was run, try ordering by StartTime desc or EndTime desc, for example /odata/Jobs?$top=1&$orderby=StartTime desc should return the last job that has started. Use StartTime if you’d like to include running jobs which do not have an EndTime property set. If you’re interested in completed jobs only, successful or failed, use E…

Top 3 Most Liked Solutions

This solution provided by @Pankaj.Patil received 2 likes!

I need to append date and time to the file name dynamically while using the move activity

@manjesh_kumar, Can you try with below? DestinationFolder+Path.GetFileNameWithoutExtension(SourceFolder)+"_"+Now.ToString(“dd.MM.yyyy”)+".txt"

This solution provided by @ppr received 2 likes!

How to duplicate rows with ignorecase

@fightblue give a try on: Assign activity Left side: dtCleansed | Datatype: Datatable Right side: (From d in YourDataTableVar.AsEnumerable Group d by k1=d(“city”)toString.Trim.ToUpper, k2=d(“ammount”).toString into grp=Group Select grp.First()).CopyToDataTable Kindly note: Cross check the column names on spellings and ensure that the LINQ statement is using the names as in your real data

This solution provided by @J0ska received 1 likes!

How To Terminate Process in Middle of Whole Process?

There is enough resources about T/C. Search and test. It is the best learning. Cheers

---

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 | 05 June 2021

Top 3 Topics with Most Views

How can I perfom a write range every 100 rows made by @4751203118d5c62d58b6be22a with 28 views.

Help with for each in excel made by @NHoe with 24 views.

How to trigger a workflow when a new row is added in Excel file made by @salax_sunny with 21 views.

Top 3 Topics with Most Replies

How can I perfom a write range every 100 rows made by @4751203118d5c62d58b6be22a with 8 replies.

Format date in excel not match file original? made by @fairymemay with 8 replies.

BOT is not able to login to acmetest website made by @Rakesh_Tiwari with 7 replies.

Top 3 Users Who Posted The Most

@Hiba_B made 11 posts!

@AndyMenon made 8 posts!

@postwick made 5 posts!

Top 3 Most Liked Posts

This post made by @prasath_S received 2 likes!

How can I perfom a write range every 100 rows

Hi @4751203118d5c62d58b6be22a You can give cell address in write range as A101,A201 etc it will start writing from that cell. Or You can use append range activity for appending the datatable to excel. Thanks

This post made by @cheez_RPA received 1 likes!

プロジェクトにロックをかけたい

UiPath自体にはそのような仕組みはありません。

This post made by @ken_infield received 1 likes!

ブラウザ拡張機能のブラウザごとの差異と途中で変更したときの影響

こんにちは。 １、サイトからのデータダウンロードがものすごく違います。 他にも動作の違いはあるのではないでしょうか。 ２、セレクタの修正は必須だと思います。 IEのサポート切れ非常に気になり、ChromiumEdgeの IEモードを試してみました。 設定はこちらを参考に セレクタの修正はやはり必須ですが、IEと同じ動作をする（と思う）ので IEモードで動作させるのが一番修正の手間が少ないと感じました。

Top 3 Most Liked Solutions

This solution provided by @Chris_Bolin received 1 likes!

Problem with index on dynamic selector

I did something similar. Although the dt that is extracted is not a true datatable, I was able to determine the number of times the word “Download” appeared using Match. For each single “Download” view, the table showed 2 so it is a 2 to 1 relationship so I divided by 2 and got the number of “rows” the bot would need to get a download from. I then had a counter run through a get attribute looking for the idx of each of the items according to the number of times “Download” appeared and allowed…

---

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 | 06 June 2021

Top 3 Topics with Most Views

プログラムを編集者以外は編集不可にする方法 made by @111131 with 22 views.

Add Data Row Object reference not set to an instance of an object made by @himanshur with 22 views.

Invoke Method -What possible functions? -Method NAME made by @Tamar_Markowitz with 21 views.

Top 3 Topics with Most Replies

Invoke Method -What possible functions? -Method NAME made by @Tamar_Markowitz with 16 replies.

検索サイトのウェブスクレーピング結果を更新する方法 made by @111701 with 7 replies.

How do i split this string from get full text activity? made by @nicholas.harvey with 7 replies.

Top 3 Users Who Posted The Most

@kumar.varun2 made 19 posts!

@Tamar_Markowitz made 7 posts!

@111701 made 6 posts!

Top 3 Most Liked Posts

This post made by @dawn.andromeda received 1 likes!

ChromeからPDF作成について

お返事が遅くなってしまい申し訳ございません。Windows側の印刷で行いましたらできました。ありがとうございました！

This post made by @ken_infield received 1 likes!

ブラウザ拡張機能のブラウザごとの差異と途中で変更したときの影響

こんにちは。 １、IEの通知バーの振る舞いはIE=EdgeIEモード で変わりませんでした。 ２、修正は必須と書きましたが、私の場合絶対セレクタを使用しているところがあり、 すべて見直しましたが、相対セレクタを使用しているアクティビティーは ブラウザにアタッチの使用ブラウザをEdgeに変更して、セレクターを変更するだけで 動作するかもしれません。

This post made by @salax_sunny received 1 likes!

How to trigger a workflow when a new row is added in Excel file

@GouthamVijay Thanks for the solution.

Top 3 Most Liked Solutions

This solution provided by @ken_infield received 1 likes!

ブラウザ拡張機能のブラウザごとの差異と途中で変更したときの影響

こんにちは。 １、IEの通知バーの振る舞いはIE=EdgeIEモード で変わりませんでした。 ２、修正は必須と書きましたが、私の場合絶対セレクタを使用しているところがあり、 すべて見直しましたが、相対セレクタを使用しているアクティビティーは ブラウザにアタッチの使用ブラウザをEdgeに変更して、セレクターを変更するだけで 動作するかもしれません。

This solution provided by @ppr received 1 likes!

How to add two lists or arrays?

L1.concat(L2).tolist / toArray

---

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 | 07 June 2021

Top 3 Topics with Most Views

Regex for 2 different conditions made by @AhmedKutraphali with 69 views.

How to get the first item in matchcollection uipath without loop? made by @AhmedKutraphali with 43 views.

Unable to extract data from pdf as it contains AVL_AVView made by @sayali.suyal with 42 views.

Top 3 Topics with Most Replies

Regex for 2 different conditions made by @AhmedKutraphali with 17 replies.

How to get the first item in matchcollection uipath without loop? made by @AhmedKutraphali with 13 replies.

Get Date text from excel made by @Vincent_Nuestro with 11 replies.

Top 3 Users Who Posted The Most

@prasath17 made 21 posts!

@ppr made 21 posts!

@Cristian_Negulescu made 20 posts!

Top 3 Most Liked Posts

This post made by @shinji received 2 likes!

プログラムを編集者以外は編集不可にする方法

Winactorのシナリオ編集・閲覧・実行パスワードのような機能ですよね。 UiPathには基本的にはパスワード保護の機能は無いみたいです。 nupkg署名という形で、改ざんされていないことを証明する機能はあり、UiRobotの設定ファイルで「正しい署名が付いてないと実行させない」という設定にさせることは出来るようですが。 使っている現場を見聞きしたことが有りません。。。

This post made by @ppr received 2 likes!

How to skip columns using LINQ?

not mandatory removing the last column we can do: filterdatatable activity -col settings - remove - index: dtData.Columns.Count - 1 Working with DataTableVar.DefaultView.toTable(False, arrColSet) arrColSet can be done by DataTableVar.Columns.Cast(Of DataColumn).Select(Function (x) x.ColumnName.Except({“Col1”,“Col4”,“Col34”}).toArray

This post made by @ppr received 2 likes!

Convert date to year/week number format

[grafik] [grafik] ensure System.Globalization is imported to namespaces [grafik]

Top 3 Most Liked Solutions

This solution provided by @shinji received 2 likes!

プログラムを編集者以外は編集不可にする方法

Winactorのシナリオ編集・閲覧・実行パスワードのような機能ですよね。 UiPathには基本的にはパスワード保護の機能は無いみたいです。 nupkg署名という形で、改ざんされていないことを証明する機能はあり、UiRobotの設定ファイルで「正しい署名が付いてないと実行させない」という設定にさせることは出来るようですが。 使っている現場を見聞きしたことが有りません。。。

This solution provided by @ppr received 2 likes!

How to skip columns using LINQ?

not mandatory removing the last column we can do: filterdatatable activity -col settings - remove - index: dtData.Columns.Count - 1 Working with DataTableVar.DefaultView.toTable(False, arrColSet) arrColSet can be done by DataTableVar.Columns.Cast(Of DataColumn).Select(Function (x) x.ColumnName.Except({“Col1”,“Col4”,“Col34”}).toArray

This solution provided by @ppr received 2 likes!

Convert date to year/week number format

[grafik] [grafik] ensure System.Globalization is imported to namespaces [grafik]

---

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 | 08 June 2021

Top 3 Topics with Most Views

How to run the RPA regularly? made by @karol.pang with 30 views.

Linq query show output 0 made by @fairymemay with 27 views.

How to keep the integer variable a constant number? made by @lmoham with 27 views.

Top 3 Topics with Most Replies

RPA Challenge data made by @Katherine_Ward with 19 replies.

Unable to view/create Environment in orchestrator2021.6.2 release made by @itsmegovardhan with 14 replies.

How to add Excel file Headers into another DataTable made by @nilesh.mahajan with 12 replies.

Top 3 Users Who Posted The Most

@Yoichi made 22 posts!

@Pankaj.Patil made 22 posts!

@ppr made 18 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 4 likes!

Code issue to count recurring letters in a word

Hi, How about the following? [img20210608-4] Sequence1.xaml (6.8 KB) Regards,

This post made by @edavis4 received 2 likes!

Issues with remote run not finding IE

We have a bot that was running fine for an extended period of time. About a month ago our VDIs were rebuilt, and since then we are experiencing issues with one of our bots. It should be a remote bot, but any time we run it now without logging into the VDI, it experiences one of two primary errors: RemoteException wrapping UiPath.Core.BrowserOperationException: Cannot communicate with Internet Explorer browser RemoteException wrapping System.Runtime.InteropServices.COMException: Timeout reached…

This post made by @Yoichi received 2 likes!

Having trouble with the Switch Case activity

Hi, We need to use ReadCell activity instead of ReadCellFormula activity because ReadCellFormula returns empty if there is no formula (even there is data). Then you need to change type of isEmpty from String to GenericValue, (and might be modift from isEmpty to isEmpty.ToString In addition initial value of counter should be 1. Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 4 likes!

Code issue to count recurring letters in a word

Hi, How about the following? [img20210608-4] Sequence1.xaml (6.8 KB) Regards,

This solution provided by @Yoichi received 2 likes!

Having trouble with the Switch Case activity

Hi, We need to use ReadCell activity instead of ReadCellFormula activity because ReadCellFormula returns empty if there is no formula (even there is data). Then you need to change type of isEmpty from String to GenericValue, (and might be modift from isEmpty to isEmpty.ToString In addition initial value of counter should be 1. Regards,

This solution provided by @NIVED_NAMBIAR received 2 likes!

LINQ-Get Only Columns without where

Hi @KarthikBallary another way of acheveing this is by using below assign activity suppose u had stored ur excel in dt1 then use below assign activity dt2 = dt1.DefaultView.ToTable(False,{“col1”,“col3”}) then dt2 will only contains col1 and col3 Regards, Nived N Happy Automation

---

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 | 09 June 2021

Top 3 Topics with Most Views

Capgemini - UiPath Developer - Bangalore - India - Full Time made by @Vibhor.Shrivastava with 31 views.

プロシージャの呼び出し または引数が不正です made by @miwa_yamamoto with 29 views.

How to update Remark in Excel file specific column from first used cell till last used cell made by @nilesh.mahajan with 24 views.

Top 3 Topics with Most Replies

Error trying to import package into Orchestrator - invalid package details made by @postwick with 8 replies.

Directory.GetFiles with a List of Files made by @NHoe with 7 replies.

Lookup using two columns made by @MANISHA_V_ARORA with 7 replies.

Top 3 Users Who Posted The Most

@kumar.varun2 made 20 posts!

@postwick made 16 posts!

@ppr made 12 posts!

Top 3 Most Liked Posts

This post made by @Michelle_Yurovsky received 2 likes!

Introducing UiPath Insights Cloud

hey @balramrv, we will be building the import/dashboard export feature. It will be coming towards the end of the year. However, the LRW dash that’s on the marketplace will not work for Cloud Insights. We will likely release a separate one specifically for cloud

This post made by @Yoichi received 2 likes!

Need to store unique values in a column

Hi, How about the following? [img20210609-8] Sample20210609-4.zip (2.6 KB) Regards,

This post made by @alexandretperez received 2 likes!

Need to pick 9 digit numeric value

Hi @Fresher You need then specify what kind of characters you can have before and after this 9 digit group. [image]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Need to store unique values in a column

Hi, How about the following? [img20210609-8] Sample20210609-4.zip (2.6 KB) Regards,

This solution provided by @ppr received 2 likes!

Directory.GetFiles with a List of Files

Directory.GetFiles(YourDirPath, “Test*.xlsx”) for a prefiltering Or Filtering before for each e.g. arrFiles = Directory.GetFiles(YourDirPath) arrMask = {“Test1”,“Test3”} arrFilesFiltered = arrFiles.Where(Function (x) arrMask.Any(Function (f) x.Contains(f))).toArray

This solution provided by @ppr received 1 likes!

Split string not working and throwing two errors

YourStringVar.Split(","c) [grafik]

---

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 June 2021

Top 3 Topics with Most Views

Dictionary型の操作サンプル made by @Yoshi_Akiyama with 33 views.

UipathからのGASの実行方法に関して made by @1111047 with 27 views.

Move File with Unique Name made by @NAJAA_BAZILAH with 25 views.

Top 3 Topics with Most Replies

Click many times made by @Soudios with 16 replies.

Getting an error in Matches made by @Puneet_Singh1 with 14 replies.

Move File with Unique Name made by @NAJAA_BAZILAH with 12 replies.

Top 3 Users Who Posted The Most

@postwick made 28 posts!

@ppr made 20 posts!

@Yoichi made 14 posts!

Top 3 Most Liked Posts

This post made by @Yoshi_Akiyama received 4 likes!

Dictionary型の操作サンプル

API系アクティビティを使っていると、帰ってくるデータがDictionary型の場合があって、 dictionaryの中身の調べ方は少し難しいのでサンプルを作りました。 よければ使って見てください。 使って見た人の不明点に回答するために解消するためにしばらく（２営業日ぐらい？）オープンにしときます。 DictionaryEnumerationTest.zip (3.1 KB)

This post made by @NIVED_NAMBIAR received 3 likes!

Lookup using two columns

Hi @MANISHA_V_ARORA after a long testing got this code dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“c_comp_prop_cd”)= If(dt2.AsEnumerable().Where(Function(r) r(“c_rev_center_cd”).ToString.Trim.Equals(row(“c_comp_prop_cd”).ToString.Trim) And r(“c_prop_cd”).ToString.Trim.Equals(row(“c_prop_cd”).ToString.Trim)).Count<>0,dt2.AsEnumerable().Where(Function(r) r(“c_rev_center_cd”).ToString.Trim.Equals(row(“c_comp_prop_cd”).ToString.Trim) And r(“c_prop_cd”).ToString.Trim.Equals(row(“c_prop_cd”).…

This post made by @StefanSchnell received 2 likes!

How to Read SAP Tables with a Generic ABAP Approach from UiPath

A longer time ago I published here a solution how to use the remote enabled function module RFC_READ_TABLE with the Invoke Code activity in the SAP back-end. Here now a solution to the same with an ABAP report, which works directly in the context of the UiPath automation workflow. The first question that can be asked here is, why should I go into this trouble when I have a remote enabled function module available? Well, this approach offers a few advantages: The output size is 1024 character…

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 3 likes!

Lookup using two columns

Hi @MANISHA_V_ARORA after a long testing got this code dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“c_comp_prop_cd”)= If(dt2.AsEnumerable().Where(Function(r) r(“c_rev_center_cd”).ToString.Trim.Equals(row(“c_comp_prop_cd”).ToString.Trim) And r(“c_prop_cd”).ToString.Trim.Equals(row(“c_prop_cd”).ToString.Trim)).Count<>0,dt2.AsEnumerable().Where(Function(r) r(“c_rev_center_cd”).ToString.Trim.Equals(row(“c_comp_prop_cd”).ToString.Trim) And r(“c_prop_cd”).ToString.Trim.Equals(row(“c_prop_cd”).…

This solution provided by @Yoichi received 2 likes!

Calculate all invoice amounts on a particular day/ss

Hi, Can you try the following? [img20210610-5] Sample20210610-3.zip (8.6 KB) Regards,

This solution provided by @ppr received 1 likes!

Need an example to loop Get Queue items activity after reaching 100 and should check all the items in Queue

Sorry for the reduced screenshot: ListQueueItems = new List(Of QueueItem) - Init it before usage ListQueueItems = ListQueueItems.Concat(tmpQueueItems).toList (within correct spell form)

---

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 June 2021

Top 3 Topics with Most Views

UiPath Best Practices made by @Manikandan_Ckj with 186 views.

InnovSol - UiPath Solution Architects - Across India - India - Full Time made by @Manikandan_Ckj with 52 views.

URの処理実行 made by @Shuichiro_Yamashita with 28 views.

Top 3 Topics with Most Replies

Invoke Code to convert date format MM/dd/yy h:mm tt to yy-MM-dd hh:mm:ss made by @jsilvestre with 20 replies.

Click Activities does not work as expected made by @CrazyTrunk with 14 replies.

Looping through PDF files to create a txt file per pdf with their names made by @Sthefanie_Urquilla with 12 replies.

Top 3 Users Who Posted The Most

@postwick made 27 posts!

@Srini84 made 22 posts!

@Yoichi made 17 posts!

Top 3 Most Liked Posts

This post made by @Manikandan_Ckj received 7 likes!

UiPath Best Practices

1. Organizing your project Use RE Framework to make skeleton of your process Reliable — create solid, robust workflows that can handle errors. Efficient — create a structure that: Helps to short down development time. Helps to reduce errors in production. Maintainable — create a structure that makes it easy to update when needed. Extendable — new requirements should be able to be implemented easily. Choose the right layout The main workflow works best as a Flowchart or a State Machine. Bus…

This post made by @Yoichi received 4 likes!

How to find a number and update the status as 'found' in excel without using loop

Hi, Thank you for sharing. Hope the following helps you. [img20210611-4] Sample20210611-4.zip (16.2 KB) Regards,

This post made by @Lahiru.Fernando received 2 likes!

Don't miss an amazing opportunity to win UiPath DevCon T-Shirt

Don’t miss an amazing opportunity to win UiPath #DevCon T-Shirt. As UiPath MVP I have 3 Coupons to give away! Let’s play a contest to win an exciting gift from UiPath. 𝑫𝒆𝒗𝑪𝒐𝒏 𝑹𝒆𝒈𝒊𝒔𝒕𝒓𝒂𝒕𝒊𝒐𝒏 𝑳𝒊𝒏𝒌: RPA Developer Conference - DevCon 2021 | UiPath 𝐓𝐚𝐬𝐤: Re-share the LinkedIn post quoting, why would you want your connections to attend the “𝐃𝐨𝐜𝐮𝐦𝐞𝐧𝐭 𝐔𝐧𝐝𝐞𝐫𝐬𝐭𝐚𝐧𝐝𝐢𝐧𝐠” session in UiPath DevCon? 𝐖𝐢𝐧𝐧𝐢𝐧𝐠 𝐜𝐫𝐢𝐭𝐞𝐫𝐢𝐨𝐧: Most 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐟𝐮𝐥 quote of the re-shared post. 𝐂𝐨𝐧𝐝𝐢𝐭𝐢𝐨𝐧𝐬: Your post has to be re-share …

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 4 likes!

How to find a number and update the status as 'found' in excel without using loop

Hi, Thank you for sharing. Hope the following helps you. [img20210611-4] Sample20210611-4.zip (16.2 KB) Regards,

This solution provided by @Srini84 received 1 likes!

Column selection based on data

@MrKezay Is it this you are trying? [image] Hope this may help you Thanks

This solution provided by @postwick received 1 likes!

Click many times

That’s correct, but NbreClick needs to be an Int32, not String. Also, you don’t really need the variable and an assign. Just directly put CInt(row.Item(“Position”)) into the “Repeat number of times” property.

---

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 June 2021

Top 3 Topics with Most Views

Xebia - UIPATH Developer - Across India - India - Full Time made by @Manikandan_Ckj with 116 views.

SOAP API Post Method Integration in Uipath made by @Manikandan_Ckj with 46 views.

How to sum inside excel and I tried and getting expression expected made by @prasathsunkara with 28 views.

Top 3 Topics with Most Replies

How to sum inside excel and I tried and getting expression expected made by @prasathsunkara with 14 replies.

Regex for uppercase (capital) letters made by @EmirY with 5 replies.

Excel send hot key failure into specific cell made by @Basak_Demirel with 5 replies.

Top 3 Users Who Posted The Most

@kumar.varun2 made 13 posts!

@prasathsunkara made 9 posts!

@Manikandan_Ckj made 8 posts!

Top 3 Most Liked Posts

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

UiPath Best Practices

Very useful information. Great efforts.

This post made by @Manikandan_Ckj received 1 likes!

SOAP API Post Method Integration in Uipath

Install Uipath.web.activties in Manage packages. Read Text file activity – > .xml file → properties pane – > Output → create a variable (ex name : output file) → pass into → output To → (ex name : output file) Assign activity – > call read text file’s output variable – > replace relevant fields to variables (.replace). Use http request activity. End Point – > API KEY URL?.wsdl Authentication → Simple HTTP (Valid Username and password) Click Ok Properties pane – > Input – > Method – >…

This post made by @Manikandan_Ckj received 1 likes!

Amayztech - UIPATH Developer - India - India - Full Time

Job title: UIPATH Developer Job role: RPA Developer Country: India City: India Company name: Amayztech Employment Type: Full Time Seniority level: Junior 1 to 2 years Job Description: Role : Rpa UIPATH Developer Experience : 2 years Apply here: careers@amayztech.com

Top 3 Most Liked Solutions

This solution provided by @sowndaryacse1505 received 1 likes!

Click Activities does not work as expected

Hey @CrazyTrunk Refer this

---

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 June 2021

Top 3 Topics with Most Views

Adding data for every month made by @sathish_kumar3 with 30 views.

KTech Products - RPA Multiple titles, FTE, PT, Contractors, India, USA - Dallas - United States - Full Time made by @jchitkara with 27 views.

I wonder why there are no topics on merging multiple excel sheets into 1 here made by @er_bar with 26 views.

Top 3 Topics with Most Replies

Adding data for every month made by @sathish_kumar3 with 9 replies.

How to read row 2-3 only? made by @fairymemay with 7 replies.

Initialize List of Lists made by @vijithhhhh with 6 replies.

Top 3 Users Who Posted The Most

@Srini84 made 19 posts!

@prasath17 made 6 posts!

@fairymemay made 5 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Regex for uppercase (capital) letters

have alook below and unselect Ignore case option

This post made by @Srini84 received 2 likes!

How to read row 2-3 only?

@fairymemay Check as below [image] dt1.AsEnumerable.Take(Number of rows).CopyToDataTable Like as dt1.AsEnumerable.Take(2).CopyToDataTable to get first two rows In assign use the above expression Hope this may help you Thanks So it will take

This post made by @Srini84 received 1 likes!

Split text?

@fairymemay Check below for your reference [image] sampleString.Substring(0,(sampleString.IndexOf("_",sampleString.IndexOf("_")+1))) Above expression will split the text at second occurence of " _" Hope this may help you Thanks

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Regex for uppercase (capital) letters

have alook below and unselect Ignore case option

This solution provided by @Srini84 received 2 likes!

How to read row 2-3 only?

@fairymemay Check as below [image] dt1.AsEnumerable.Take(Number of rows).CopyToDataTable Like as dt1.AsEnumerable.Take(2).CopyToDataTable to get first two rows In assign use the above expression Hope this may help you Thanks So it will take

This solution provided by @Srini84 received 1 likes!

Split text?

@fairymemay Check below for your reference [image] sampleString.Substring(0,(sampleString.IndexOf("_",sampleString.IndexOf("_")+1))) Above expression will split the text at second occurence of " _" Hope this may help you 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 | 14 June 2021

Top 3 Topics with Most Views

How to edit linq query? made by @fairymemay with 35 views.

Configファイルについて made by @kojikoji with 31 views.

Lesson 7 - 7.1 Screen Scraping Practice 1 made by @CN26831 with 31 views.

Top 3 Topics with Most Replies

入力ダイアログのラジオボタンでの初期値設定。 made by @r.nakanishi with 21 replies.

Select excel cells copy and paste after url made by @mahmoud_mohamed with 18 replies.

I am caluclating the start_time end_time and total_time but i am unable to calulate the total time due the error please help me made by @praveen_sonkusare with 13 replies.

Top 3 Users Who Posted The Most

@postwick made 43 posts!

@kumar.varun2 made 25 posts!

@Yoichi made 15 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

How to edit linq query?

Hi, The following will also work, without pre-build datatable, FYI. dt.AsEnumerable.Where(function(r) r("Reason Of AA").ToString()=item).CopyToDataTable().DefaultView.ToTable("NewTable",False,{"Reason Of AA"}) Regards,

This post made by @Jeremy_Tederry received 3 likes!

UIPath Post Request error after making ML Skill public

Ok we have identified the issue on our side and we will fix it. This is due to the fact that for endpoints we are handling only json string and not any string. So we are applying json.loads to your output and of course this fails. We’ll fix that bug but if you need that now you have two workaround: Use the robot connection Modify the ML Package to return a json string. In you python code something like: result = dict() result["Supplier ID"] = <supplier_id_value> result["Confidence"] = <confi…

This post made by @prasath17 received 2 likes!

Split text?

@fairymemay - Another solution… [image] "Suspend_de_20210613_175410.xlsx".Split("2"c)(0).trim("_"c) Assuming you will get 2021 always [image] "Suspend_de_20210613_175410.xlsx".Split({"2021"},StringSplitOptions.None)(0).trim("_"c) to make generalized "Suspend_de_20210613_175410.xlsx".Split({now.year.tostring},StringSplitOptions.None)(0).trim("_"c)

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

How to edit linq query?

Hi, The following will also work, without pre-build datatable, FYI. dt.AsEnumerable.Where(function(r) r("Reason Of AA").ToString()=item).CopyToDataTable().DefaultView.ToTable("NewTable",False,{"Reason Of AA"}) Regards,

This solution provided by @prasath17 received 2 likes!

Capture just the foldername from directory structure

@herman - This query will print only the folder names without the path… Directory.GetDirectories("YourFolderPath").select(Function(x) new fileinfo(x).Name).ToArray() Try and let us know… This is my folder structure [image] And this is output printing without path… [image]

This solution provided by @Yoichi received 2 likes!

Regex to extract 2 first character from different patterns

Hi, How about the following expression? System.Text.RegularExpressions.Regex.Match(yourString,"(?<=-)[A-Z]{2}|^[A-Z]{2}",System.Text.RegularExpressions.RegexOptions.RightToLeft).Value 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 | 15 June 2021

Top 3 Topics with Most Views

📢 Announcing UiPath HyperHack - #AutomationForGood Winners! made by @Vibhor.Shrivastava with 371 views.

Uipath Devcon made by @Manikandan_Ckj with 33 views.

Team Lease - Uipath Development and support - Pan India - India - Full Time made by @Manikandan_Ckj with 31 views.

Top 3 Topics with Most Replies

Error : String was not recognized as a valid DateTime made by @Vrushali_Gave with 13 replies.

記入したいRangeの設定方法について made by @Carmen_F with 13 replies.

Dynamic sheet name in excel formula made by @acdeleon123 with 9 replies.

Top 3 Users Who Posted The Most

@postwick made 32 posts!

@Yoichi made 23 posts!

@prasath17 made 11 posts!

Top 3 Most Liked Posts

This post made by @Vibhor.Shrivastava received 13 likes!

Announcing UiPath HyperHack - #AutomationForGood Winners!

[A4G 3] And here we are, as every great contest reaps glory on its finish line! We embarked on this grand journey with over 350 participants on board for the 2021 UiPath HyperHack – Automation For Good! After kicking off this event in mid-April, with 10 finalists presenting in a live pitching round on June 2nd, now we’ve reached the much-awaited moment of the winners’ announcement! 2 phases and an impressive judging round later, our ‘best for good’ developers have been announce…

This post made by @ppr received 4 likes!

Compare tables based on more than one column using LINQ?

do some preperations for the target structures: Clone dt1 and add the status datacolumn to the dtReportTMPL Clone for dtOut1/2 [grafik] First LINQ: (From d1 In dt1.AsEnumerable Group Join d2 In dt2.AsEnumerable On d1("PLCNO").toString Equals d2("PLCNO").toString And d1("DDNO").toString Equals d2("DDNO").toString And d1("EML").toString Equals d2("EML").toString Into gj = Group From g In gj.DefaultIfEmpty Let status = If(isNothing(g), Nothing, g("STATUS")) Let ra = d1.ItemArray.Append(statu…

This post made by @Manikandan_Ckj received 3 likes!

Reframwork concepts

Uipath Reframework concepts Robotic Enterprise Framework is a project template based on State Machines . It is created to fit all of the best practices regarding logging, exception handling, application initialization, and others, being ready to tackle a complex business scenario. Total 4 States, Initialization Get transaction Process Transaction End Process What is Initialization? Initialization all project relevant details in config file. (Ex: Asset, Folder path, excel sheet name, queue …

Top 3 Most Liked Solutions

This solution provided by @ppr received 4 likes!

Compare tables based on more than one column using LINQ?

do some preperations for the target structures: Clone dt1 and add the status datacolumn to the dtReportTMPL Clone for dtOut1/2 [grafik] First LINQ: (From d1 In dt1.AsEnumerable Group Join d2 In dt2.AsEnumerable On d1("PLCNO").toString Equals d2("PLCNO").toString And d1("DDNO").toString Equals d2("DDNO").toString And d1("EML").toString Equals d2("EML").toString Into gj = Group From g In gj.DefaultIfEmpty Let status = If(isNothing(g), Nothing, g("STATUS")) Let ra = d1.ItemArray.Append(statu…

This solution provided by @prasath_S received 2 likes!

Read row until row blank

Hi @fairymemay Please try this dtTable.AsEnumerable.TakeWhile(Function(row) row.ItemArray.Any(function(col) not string.IsNullOrEmpty(col.ToString))).CopyToDataTable [image] [image] Thanks

This solution provided by @balupad14 received 1 likes!

How can i delete sheet in Excel

Thank you @Soudios. I think the problem solved now…

---

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 June 2021

Top 3 Topics with Most Views

Read 2 GB text file and convert to DT made by @shrayud with 77 views.

データに対応したWeb上の任意の場所をクリックしたい made by @hiroshi2 with 46 views.

Expertsville@ UiPath DevCon 2021 made by @DeaTo with 39 views.

Top 3 Topics with Most Replies

要素の消滅を待つ の使い方 made by @miwa_yamamoto with 13 replies.

Delete rows below one specified one in a datatable made by @abdel with 12 replies.

Error in Convert String into int32/Double/Int64 made by @skg_161125 with 11 replies.

Top 3 Users Who Posted The Most

@postwick made 23 posts!

@ppr made 18 posts!

@Pranav_KomandurPK made 11 posts!

Top 3 Most Liked Posts

This post made by @CN26831 received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello everyone. My name is Cory and I am new to UiPath and the Forum. I teach a graduate class in accounting and I incorporated RPA for the first time. I have received assistance on three workflows already. So thankful to UiPath Forum Community for sharing their expertise!

This post made by @Geoff received 2 likes!

The new Customer Portal is rolling out!

We’re happy to announce that the UiPath Customer Portal has started onboarding for UiPath Enterprise customers! Customer Portal is a self-service portal for organizations to access UiPath products and platform-related information, and interact with UiPath teams. It’s designed to give UiPath customers all the required support via a single, modern experience, to help accelerate their automation journey. [CP-dashboard] Onboarding will be invitation-based and is split into 3 waves over the next …

This post made by @HANACCHI received 2 likes!

セレクターのハイライトがずれる

IEとCHROMEでそういった違いがあった事がありました。 CHROMEではチャンと取れる、細かいUI要素が表現できる。この状況で、後輩にロボ作ってみ！と指示だしたらどうもうまくいかない。後輩はIEで実装していました。 IEだと、細かいUI要素が取れない、ズレる。。。 今後を見据えて、CHROMEで開発してねってお願いしました。 もしかしたら、ブラウザのバージョンアップでもこのような事が起きるかもしれません。

Top 3 Most Liked Solutions

This solution provided by @Vijay_Kumar_C received 2 likes!

Adding Color to Headers

Hi @Pranav_KomandurPK, We have Set Range Color in Excel Application Scope Activity. Use Excel Application Scope activity and provide file path. Drag Set Range Color activity and provide below parameters. Color = System.Drawing.Color.Blue Range = "A1:F1" SheetName = "March 2021_temp" Please find below attached image for more information. Regards, Vijay. [HeaderColor]

This solution provided by @uiuiki received 1 likes!

データスクレイピングしたデータのエクセル反映

おはようございます。 エラー解消いたしました！適切なアドバイスをありがとうございます。

This solution provided by @ppr received 1 likes!

Regex multilne

[grafik]

---

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 June 2021

Top 3 Topics with Most Views

Web Selectors for click button made by @pari_patel with 50 views.

Using Image Variable made by @Sahil_J_Patel with 47 views.

Excel data processing question made by @MF.RPA with 45 views.

Top 3 Topics with Most Replies

Move File from one folder to another in uipath studio activities made by @pari_patel with 17 replies.

Creata a datatable from a text file made by @skg_161125 with 14 replies.

Regex (Last Line txt) made by @Julian_Yamid_Torres_Torre with 11 replies.

Top 3 Users Who Posted The Most

@postwick made 36 posts!

@Srini84 made 15 posts!

@ppr made 15 posts!

Top 3 Most Liked Posts

This post made by @My_Channel received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, I’m just starting on my UiPath journey and so far I’m enjoying it. My goal is to become a StudioX expert and be able to teach others.

This post made by @jeevith received 2 likes!

The new Customer Portal is rolling out!

Hello @Geoff, This feature will be a great time saver for all enterprise users. One important feature in such a portal is to have access to the stable LTS versions of platform installer / robot / studio pro (.msi) installers may be also the latest preview versions as well. At the minimum, the organizational admin of the portal should have access to all relevant installers depending on the licenses purchased. We have wasted a lot of time trying to find the correct installer files and had to u…

This post made by @sa.tk received 2 likes!

PDFの印刷について

N2027さん＞ お教えいただきました、「Ctrl＋Shift＋P」ですが、「Ctrl＋P」同様うまく反応いたしませんでした。 最終的に、右クリックでメニューを表示させ、印刷（P）ボタンをクリックさせることで問題解消いたしました。 この度は、ありがとうございました。

Top 3 Most Liked Solutions

This solution provided by @postwick received 1 likes!

Web Selectors for click button

Is the applicationId always 300 in the Iframe URL? First thing I would try is to replace all the spaces in aaname with *. So… <webctrl aaname='*Retrieve*' tag='A' />

This solution provided by @prasath17 received 1 likes!

How to loop zip folder

@fairymemay - Please check this… [image] For Each Argument type is string. Note: Replace MoveFiles with your FolderName My Output [image] Hope this helps…

This solution provided by @Srini84 received 1 likes!

Orchestrator database info (Queue Items)

@Felipe_Kotinda It can be possible, but you need to understand which tables are updated As it is related to their SQL schema, and I believe UiPath will not give those details Hope this may help you 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 | 18 June 2021

Top 3 Topics with Most Views

How to choose row for click in web? made by @fairymemay with 42 views.

Calculate the Age of a person by now - BOD made by @ayana_augustine with 33 views.

How to add a column in-between the column in datatable made by @T_Y_Raju with 27 views.

Top 3 Topics with Most Replies

How to choose row for click in web? made by @fairymemay with 26 replies.

Calculate the Age of a person by now - BOD made by @ayana_augustine with 23 replies.

How do i maximise the excel file it changes every month? made by @SIM_JUN_HUI_BERTRAM_CSOD with 13 replies.

Top 3 Users Who Posted The Most

@ppr made 26 posts!

@kumar.varun2 made 14 posts!

@GreenTea made 13 posts!

Top 3 Most Liked Posts

This post made by @aroua.jouini received 4 likes!

RPA France - Cas d’usage – Episode 4 : Gestion des CVs au sein de la DGRH et rapprochements bancaires

Précédemment, nous avons introduit les notions en relation avec l’automatisation, les étapes à suivre pour utiliser les produits UiPath. Dans cet article, je vais attaquer le vif du sujet et vous parler de deux cas d’usage de la RPA au sein des “corporates” Les processus dans une entreprise ont tendance à être répétitifs, manuels et consomment trop de temps. Voyons ensemble des exemples de ces cas et comment les automatiser. :point_right:Use case du département DGRH : …

This post made by @NIVED_NAMBIAR received 2 likes!

Outlook Mail Message filter 3 subject keyword

Hi @CoolRobot you can filter by using the assign activity read the outlook mail messages uisng Get Outlook mails and store in mail_list now use the assign activity mail_list= mail_list.AsEnumerable().Where(Function(mail) mail.Subject.ToString.Contains(“ITT2 File”) or mail.Subject.ToString.Contains("[YCS] Shift Summary Report") or mail.Subject.ToString.Contains("[YCS] Performance Report")).ToList() Then the mail_list contains only the mails which contains the above subject lines Regards, N…

This post made by @jack.chan received 1 likes!

Image exist working randomly

because your image is small and doesnt contain a lot of information, you can try select “Enhanced” under profile instead of basic and change the accuracy to 0.9 [image] *if you need the text to be the same, maybe change accuracy to be 1 , if you dont care about the text and only want to check if its blue, then use 0.9

Top 3 Most Liked Solutions

This solution provided by @Srini84 received 1 likes!

Unable to click on drop down item

@hyou_issei Welcome to forums You can pass a Enter key in TypeInto activity Or use Send Hotkey Activity - Enter key Hope this may help you Thanks

This solution provided by @Yoichi received 1 likes!

データテーブルの任意の文字列を切り出し

こんにちは いろいろやり方ありそうですが、以下一例です。 dt = dt.AsEnumerable.Select(Function(r) r("Column0").ToString().Substring(4,2)).Distinct().Select(Function(s) dt.Clone.LoadDataRow({s},False)).CopyToDataTable() Sample20210618-2.zip (8.5 KB)

This solution provided by @ppr received 1 likes!

How to add a column in-between the column in datatable

In case of further questions we are here and will help. Once you have done with the final testing mark the solving post as solution. So others can benefit from it. 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 | 19 June 2021

Top 3 Topics with Most Views

Searching string with case insensitive made by @kavya_mamidishetti with 43 views.

How to get all values from datatable except the mentioned value made by @Prince1 with 35 views.

Powershell usage? made by @Felipe_Kotinda with 28 views.

Top 3 Topics with Most Replies

How to convert IEnumerable<FtpObjectInfo> into a datatable made by @kduvvuri with 7 replies.

How to get all values from datatable except the mentioned value made by @Prince1 with 5 replies.

Assign file date with wildcard? made by @erik1 with 5 replies.

Top 3 Users Who Posted The Most

@Subhas_Malik made 5 posts!

@NIVED_NAMBIAR made 4 posts!

@kumar.varun2 made 4 posts!

Top 3 Most Liked Posts

This post made by @jack.chan received 2 likes!

Concat multiple column data into another column through linq

assuming your datatable variable is called dt a. use add data column activity to add data column called Col6 (if it doesnt exist) b. use invoke code click edit arguments and add in/out argument dt [image] then click edit code and paste this dt.AsEnumerable().ToList().ForEach(Sub(row) row("Col6")= row("Col1").ToString+row("Col2").ToString+row("Col4").ToString+row("Col5").ToString) this will set Col6 = col1+col2+col4+col5

This post made by @RGudi received 1 likes!

Lesson 9 - Filter Wizard not filtering data table as expected

Late reply but I have just joined the RPA community. This may help for any future user encountering the issue. This problem has been resolved in Modern Design Experience. You can change the data format using Extract Data Table wizard available in Modern design Experience. So filtering on integers is direct and no more workarounds needed. Hope this helps.

This post made by @aparna3010 received 1 likes!

I want to add amt col and do the calculation as amount=mrp-SchemeDiscAmt-LotDisc and also remove total row at the end

Thank you sooo Much!! It Means a lott to me!!Thanks a ton!!

Top 3 Most Liked Solutions

This solution provided by @asgRPA received 1 likes!

When filling in excel only write (overwrite) in the first line

Hi, In your while loop you are restarting the TablaDatosCreada for every iteration. This implies nothing remains stored in your data table. The solution is to move that Build Data Table activity outside the while loop.

---

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 June 2021

Top 3 Topics with Most Views

Take a specific piece of text and the page it is on, from a PDF file made by @Araceli91 with 30 views.

Need Help:Yearly Generate report for vendor made by @Priyanka_Jadhav with 25 views.

PDF Invoice data Extraction Problem made by @ranaprathap928 with 25 views.

Top 3 Topics with Most Replies

PDF Invoice data Extraction Problem made by @ranaprathap928 with 18 replies.

Take a specific piece of text and the page it is on, from a PDF file made by @Araceli91 with 8 replies.

How to Add dynamique number of rows to Auto fill Range activity made by @Soudios with 7 replies.

Top 3 Users Who Posted The Most

@ranaprathap928 made 9 posts!

@prasath17 made 8 posts!

@Krishna_547 made 7 posts!

Top 3 Most Liked Posts

This post made by @Srini84 received 1 likes!

Extract each text between parentheses

@malak_s You can use Regex for this scenario Check below for your reference [image] sampleString = YourString use Assign sampleString = System.Text.RegularExpressions.Regex.Replace(sampleString,"[(]|[)]","") This will trim down the () brackets use Assign sampleString = System.Text.RegularExpressions.Regex.Replace(sampleString,"[-]|[+)]"," ") This will search for - and + and replace with space Hope this may help you Thanks

This post made by @malak_s received 1 likes!

Extract each text between parentheses

Thank you, I think I will do that

This post made by @MrKezay received 1 likes!

I don't want to add some columns in Excel to the table

This is how I did the solution but forgot to write it here. Thank you @Krishna_547

Top 3 Most Liked Solutions

This solution provided by @Srini84 received 1 likes!

Extract each text between parentheses

@malak_s You can use Regex for this scenario Check below for your reference [image] sampleString = YourString use Assign sampleString = System.Text.RegularExpressions.Regex.Replace(sampleString,"[(]|[)]","") This will trim down the () brackets use Assign sampleString = System.Text.RegularExpressions.Regex.Replace(sampleString,"[-]|[+)]"," ") This will search for - and + and replace with space Hope this may help you Thanks

This solution provided by @Krishna_547 received 1 likes!

I don't want to add some columns in Excel to the table

Hi , clone the original dt to another and remove the columns in the duplicate dt to send email and after that use the original dt for further operations.

---

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 June 2021

Top 3 Topics with Most Views

「呼び出しのターゲットが例外をスローしました。」 made by @miwa_yamamoto with 32 views.

How to detect a select menu is blank made by @BlakeSmith with 32 views.

When will UiPath solve the Type Into % bug? made by @Roman_hruska with 31 views.

Top 3 Topics with Most Replies

Unable to install the UiPath Studio through UiPathStudioSetup file made by @shailendra.jyoti with 17 replies.

Linq query to update End date with next line start date -1 made by @Aravinthan with 10 replies.

「呼び出しのターゲットが例外をスローしました。」 made by @miwa_yamamoto with 9 replies.

Top 3 Users Who Posted The Most

@ppr made 16 posts!

@postwick made 15 posts!

@Yoichi made 14 posts!

Top 3 Most Liked Posts

This post made by @LevKushnir received 2 likes!

BAPI Functionality in UI Path

hi @abdel See more in post 46 above. This was done by @gabi_verzea and shows the full journey from Zero to the automation https://forum.uipath.com/t/bapi-functionality-in-ui-path/84739/46?u=levkushnir additionally check this video, where UiPath Accelerators for SAP are used to speed up the implementation https://www.youtube.com/watch?v=YJ8mcy-Ci04 Learn more in the full webinar UiPath Accelerators for SAP : https://start.uipath.com/immersion-lab-jumpstart-sap-automation.html

This post made by @Haenneler received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, my name is Luca. I work with UiPath and RPA almost two years. This forum has already helped me a lot during my journey so thank you a lot.

This post made by @StefanSchnell received 2 likes!

How to Copy Data from SAP Table into SQLite DataBase

At the UiPath DevCon I had a very interesting discussion in the AMER room about the possibility to copy data from an SAP table directly into an SQLite database. The advantage of such an approach is that the data model of the SQLite database prevents inconsistent data. Furthermore, the standard query language SQL can be used. Based on my post about building your own SQLite package, here two Invoke Code Activity routines that can be used to transfer tables directly from SAP into an SQLite database…

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

How to implement dynamic IDX using the loops index?

https://forum.uipath.com/t/how-to-use-variables-in-selectors-in-studio-dynamic-selectors-without-string-manipulation/154110

This solution provided by @ppr received 2 likes!

Problem with datetime.ParseExact() - Portugal

it was asked as your used format string was not matching the input format. Have a look below: [grafik]

This solution provided by @Yoichi received 1 likes!

「呼び出しのターゲットが例外をスローしました。」

こんにちは データを直接確認するのではなく、 RowsプロパティのCountを確認してみてください [img20210621-1]

---

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 June 2021

Top 3 Topics with Most Views

IEのサポート終了 made by @komasuda with 42 views.

Checking data types of columns of datatable made by @WASEEM_KHAN with 30 views.

Max length problem with column made by @sayali_rokade with 28 views.

Top 3 Topics with Most Replies

Convert datatable to collection by validating values made by @JavXult with 14 replies.

Max length problem with column made by @sayali_rokade with 10 replies.

Checking data types of columns of datatable made by @WASEEM_KHAN with 9 replies.

Top 3 Users Who Posted The Most

@Cristian_Negulescu made 20 posts!

@ppr made 17 posts!

@NIVED_NAMBIAR made 15 posts!

Top 3 Most Liked Posts

This post made by @ermanoj3101 received 3 likes!

Where can I find UiPath AI fabric courses in UiPath academy?

You will find it in academy.uipath.com. Inside courses you will find it as AI Center (Previously known for AI Fabric)

This post made by @prasath_S received 3 likes!

Checking data types of columns of datatable

Hi @WASEEM_KHAN Please try this to find the column type of 2nd column dtTable.Columns(1).DataType.ToString [image] finding datatype of 2 columns [image] [image] Thanks

This post made by @ppr received 3 likes!

Checking data types of columns of datatable

As an variation for report retrieval: [grafik]

Top 3 Most Liked Solutions

This solution provided by @ermanoj3101 received 3 likes!

Where can I find UiPath AI fabric courses in UiPath academy?

You will find it in academy.uipath.com. Inside courses you will find it as AI Center (Previously known for AI Fabric)

This solution provided by @rfu received 2 likes!

ポップアップのボタンがクリックできない

こんにちは。 ひょっとするとアプリの作り的に、親ウインドウの「登録」ボタンクリック時に 処理されるイベントの中に 子ウインドウが表示されて「OK」ボタンをクリックされて消える・・という処理が 含まれているのかもしれませんね。 「並列」アクティビティを使って、その中の左側に親ウインドウの登録ボタンクリック、右側に子ウインドウのOKボタンクリックイベントを配置してみたらうまくいったりしないでしょうか。

This solution provided by @Hiba_B received 1 likes!

Getting error - Move File: Could not find file 'E:\Folders_To_Move_Source'

Hi @Chinmay_Bhalerao ! To move the file by using Move file activity, you need to indicate file paths not folder paths. For instance, let’s say you have an excel file named “A.xlsx”, you need in the from section to write: “E:\Name of the source folder\A.xlsx” in the to section to write: “E:\Name of the output folder\A.xlsx” So in your situation, you have to write: in the from: item in the to: "E:\Folders_To_Move_Source\" + Path.Getfilename(item)

---

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.