Forum Engagement Daily Reports

[system]

Daily Forum Report | 22 November 2021

Top 3 Topics with Most Views

Find duplicate rows in excel and add particular column value made by @Chirag1991 with 40 views.

"Invoke Workflow File" between private workflows not working in a library project made by @Tom_Lee with 39 views.

Unable to Vlookup in Uipath made by @Asitabha_Deb_asitabhad with 36 views.

Top 3 Topics with Most Replies

Unable to Vlookup in Uipath made by @Asitabha_Deb_asitabhad with 24 replies.

列を読み込み→範囲に書き込みの流れ made by @lukatopdesrlat with 17 replies.

Find duplicate rows in excel and add particular column value made by @Chirag1991 with 15 replies.

Top 3 Users Who Posted The Most

@kirankumar.mahanthi1 made 23 posts!

@Yoichi made 20 posts!

@Carolina_Salgueiro made 16 posts!

Top 3 Most Liked Posts

This post made by @Jeroen_van_Loon received 3 likes!

Need to remove the filename in the path

Your scraped string: myFullPath = "C:\User\This\is\Sample\Folder…many more directories(Dynamically changes)\FG0034CR_1.txt" Just the folder: path.GetDirectoryName(myFullPath) → C:\User\This\is\Sample\Folder…many more directories(Dynamically changes) Just the file: path.GetFileName(myFullPath) → FG0034CR_1.txt Just the file without extension: path.GetFileNameWithoutExtension(myFullPath) → FG0034CR_1 Just the file extension: path.GetExtension(myFullPath) → .txt Just the root folde…

This post made by @LevKushnir received 2 likes!

SAP Logon Activity Error

HI @RpaJin Check all setting please: If “activity worked well a few days ago”, it means, the issue has nothing to do with Activity, but with the SAP system itself Best regards, Lev

This post made by @ignasi.peiris received 2 likes!

How do I skip over an expected null entry in a data table?

Hi @dr1992! you can check if a variable (or a DT Value) is null by using the following: String.IsNullOrempty("YourString") → Replace “yourString” with your variable and ready! this will output True if null or empty, False if it contains data!

Top 3 Most Liked Solutions

This solution provided by @Jeroen_van_Loon received 3 likes!

Need to remove the filename in the path

Your scraped string: myFullPath = "C:\User\This\is\Sample\Folder…many more directories(Dynamically changes)\FG0034CR_1.txt" Just the folder: path.GetDirectoryName(myFullPath) → C:\User\This\is\Sample\Folder…many more directories(Dynamically changes) Just the file: path.GetFileName(myFullPath) → FG0034CR_1.txt Just the file without extension: path.GetFileNameWithoutExtension(myFullPath) → FG0034CR_1 Just the file extension: path.GetExtension(myFullPath) → .txt Just the root folde…

This solution provided by @LevKushnir received 2 likes!

SAP Logon Activity Error

HI @RpaJin Check all setting please: If “activity worked well a few days ago”, it means, the issue has nothing to do with Activity, but with the SAP system itself Best regards, Lev

This solution provided by @lakshman received 1 likes!

How do I skip over an expected null entry in a data table?

@dr1992 Use below condition in IF activity to check whether value is null or not. String.IsNullOrEmpty("String Value") Then Value is empty Else Value is not empty and you can use Assign activity here

---

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.