Forum Engagement Daily Reports

[system]

Daily Forum Report | 19 September 2022

Top 3 Topics with Most Views

Assign Activity LINQ Query made by @Ishan_Shelke with 54 views.

Action Center notifications in public preview made by @Liji with 53 views.

How to convert dd-MMM-yy to yyyy.MM.dd format? made by @vanithavs with 52 views.

Top 3 Topics with Most Replies

Error in Core activities configuration in Studio when using company laptop, not happen with personal laptop made by @tueminh290597 with 17 replies.

MY Last folder name made by @rAE_rAS with 15 replies.

[LINQ] - Remove Duplicate Rows with Multiple Unique Identifier Columns from Multiple Data Table made by @anthonyjr with 14 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 42 posts!

@Rahul_Unnikrishnan made 28 posts!

@sharon.palawandram made 23 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 5 likes!

G-Suite Guidelines

Hello Everyone, I would like to present this post who are looking for the G-Suite Automation Google Workspace Steps Open the console and create a new project. [image] Enable all the APIs which are necessary for the project [image] Create a credential based on the project need (API, OAuth, Service Account). [image] [image] If created Service Account, generate the key and store them in the project folder or the folder to which the bot has access. [image] [image] The Key will …

This post made by @Liji received 5 likes!

Action Center notifications in public preview

We are happy to announce the new notifications feature within Automation cloud portal for Action Center events in public preview. Action Center users will now receive built-in notifications through two channels, in-app and email to notify them with the most relevant events like Action assignment (bulk& single), Action forward and Action un-assignments. Users can manage their own preferences for opting-in or opting-out of these notifications from user profile itself. All cloud customers…

This post made by @Liji received 2 likes!

Is is possible to have email notifications when a task is added to the action center

Hi @lukasziebold We have notifications opening up in public preview for all cloud customers very soon Action Center notifications in public preview

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

Linq to Select first few columns using index in datatable

Hi @Ray_Sha1 How about this expression? New DataTable → DtOutput (From d In Dt.AsEnumerable let ra = d.ItemArray.Take(9).toArray Select DtOutput.Rows.Add(ra)).CopyToDataTable Regards Gokul

This solution provided by @Gokul001 received 1 likes!

Googleフォームの回答が入力されるスプレットシートから当日分の回答だけフィルターしたい

Hi @T_Hirao1 How about this expression Use Assign activity DtOut → Variable Type is System.Data.DataTable DtOut = DTInput.Asenumerable.Where(Function(r) CDate(r(“Column Name”).ToString).Date=DateTime.Now.Tostring("dd-MM-yyyy")).Copytodatatable Note - “dd-MM-yyyy” → spreadsheet format that need to give here. Regards Gokul

This solution provided by @Yoichi received 1 likes!

トリガースコープについて

こんにちは トリガースコープはタイムアウトの設定等がなく、設定により回数制限なく繰り返すことが 可能なので、例えば常時特定アクションの監視を行う専用のプロセスに用いられるケースが 考えられます。 もう少し具体的に例を挙げるとOutlookのメールが着信したら何らかのアクションを行う あるいはファイルが更新されたら何らかのアクションを行う専用のプロセス等が考えられます。 通常のプロセスの一部として使うこともできますが、その場合は例えばタイムアウト処理や 通常の処理等を並列アクティビティを用いて疑似並列に走らせる等が必要になるかと思います。

---

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

Top 3 Topics with Most Views

How to get the Robot ID made by @Juan_Esteban_Valencia with 45 views.

I can't send screenshoot in e-mail body made by @Patrycja_Cwikla with 42 views.

Orchestrator API/getting output from the process made by @db64a40e754add3bd2df0ad39 with 41 views.

Top 3 Topics with Most Replies

I can't send screenshoot in e-mail body made by @Patrycja_Cwikla with 23 replies.

Logging onto Orchestrator in Unattended Mode made by @zackattack0517 with 18 replies.

Copy and paste one column in other column in same excel sheet made by @lokeshkumar.k with 17 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 42 posts!

@Gokul001 made 38 posts!

@marian.platonov made 31 posts!

Top 3 Most Liked Posts

This post made by @matti.grove received 1 likes!

Automation Awareness - The Automation Journey - We want to hear your thoughts!

I’m most intrigued by the discover phase, and I think StudioX will be the best product for me to try out.

This post made by @heyium received 1 likes!

While the file is running, the macro works fine, but when I open the excel file after the process is completed, half of the operations that need to be done in the macro are saved

Thank you @Rahul_Unnikrishnan , it worked!

This post made by @Rahul_Unnikrishnan received 1 likes!

While the file is running, the macro works fine, but when I open the excel file after the process is completed, half of the operations that need to be done in the macro are saved

Hello @heyium Please check the below similar post. https://forum.uipath.com/t/execute-macros-document-was-not-saved/260873/7 Thanks

Top 3 Most Liked Solutions

This solution provided by @Rahul_Unnikrishnan received 1 likes!

While the file is running, the macro works fine, but when I open the excel file after the process is completed, half of the operations that need to be done in the macro are saved

Hello @heyium Please check the below similar post. https://forum.uipath.com/t/execute-macros-document-was-not-saved/260873/7 Thanks

This solution provided by @ashwin.ashok received 1 likes!

How to delete rows with multiple conditions - LINQ

Hi @Gabriel_Wisniewski , Instead of deleting rows, we can look at it this way. Lets focus on the rows that we are interested in retaining. If you are unsure about the number of columns, and/or its names, or if the rows contain alphanumerical characters, then this might be the solution you are looking for: Dt.AsEnumerable().Where(Function(w) w.ItemArray.Any(Function(a) If(Integer.TryParse(a.ToString,New Int32),Convert.ToInt32(a),0)>2)).CopyToDataTable() [image] CheckAllCellsInGivenRow.xaml …

This solution provided by @ppr received 1 likes!

AsEnumerable is not a member of System.data.DataTable issue

First we check following: Then lets clear if the project is set to VB or C#

---

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

Top 3 Topics with Most Views

HyperHack 2022 update! Winners have been announced! made by @Rohit_Radhakrishnan with 73 views.

Plzz help me made by @katta_nikhil with 41 views.

Linq how to exclude OrderID from a other Datatable made by @raiko.m with 35 views.

Top 3 Topics with Most Replies

Convert to Date Time From String made by @nilesay with 19 replies.

Plzz help me made by @katta_nikhil with 19 replies.

Problem With Text File To Data Table To CSV File Conversion made by @worldwynj with 12 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 32 posts!

@raja.arslankhan made 23 posts!

@postwick made 23 posts!

Top 3 Most Liked Posts

This post made by @Rohit_Radhakrishnan received 10 likes!

HyperHack 2022 update! Winners have been announced!

UiPath Community organized this years edition of HyperHack, global community hackathon, with more than 560 participants from 38 countries this year, the competition drew diverse participation with over 30% women participation around the world from over 230 unique organizations. We challenged our community to solve business problems across 3 categories and we have been really excited to see the teams present innovative solutions. Here are our ama…

This post made by @Sudharsan_Ka received 2 likes!

Convert to Date Time From String

@nilesay You need to change the column type to date in excel right? you can achieve it using a modern activity or BalaReva Activity Check out this image and skeleton xaml file for modern [image] Sequence.xaml (8.2 KB) Checkout this thread for Balareva activities Regards Sudharsan

This post made by @raja.arslankhan received 1 likes!

Introducing Canary Tenant for Automation Cloud

wao New Addition

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Error IN DATATABLE

Hi, Can you try the following out_dt_table.AsEnumerable() Then set DataRow in TypeArgument property in Parallel For Each. BTW, do you need to use Parallel For Each? I recommend to use ForEach or ForEachRow if you don’t have special reason. Regards,

This solution provided by @Yoichi received 1 likes!

Add column values of each Id in data table (1st row of each id)

Hi, How about the following sample? [image] dt.AsEnumerable().GroupBy(Function(r) r("Id").ToString).ToList.ForEach(Sub(g) g.First().Item("A")=g.Sum(Function(r) CDbl(r("A").ToString)) g.First().Item("B")=g.Sum(Function(r) CDbl(r("B").ToString)) g.First().Item("C")=g.Sum(Function(r) CDbl(r("C").ToString)) g.First().Item("D")=g.Sum(Function(r) CDbl(r("D").ToString)) End Sub) Sample20220921-2.zip (8.8 KB) Regards,

This solution provided by @Yoichi received 1 likes!

Linq how to exclude OrderID from a other Datatable

Hi, How about using DtExclude as the following? DtOutput = (From d In dtInput.AsEnumerable Where Not DtExclude.AsEnumerable.Any(Function(r) r("Order").ToString=d("Order").ToString) Where Convert.ToDateTime(d("Date").ToString) <= DateTime.Today Select d).CopyToDataTable And as @ashwin.ashok mentioned, perhaps you should evaluate value as numeric as the following. dtExcluse = (From d In dtInput.AsEnumerable Where Int32.TryParse(d("Rate").ToString,New Int32) AndAlso Int32.Parse(d("Rate").ToSt…

---

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

Top 3 Topics with Most Views

Problems with converting a DT from String to Int made by @juergenh1975 with 39 views.

Convert critical Json To DataTable made by @Deepak_Kumar_Patel with 39 views.

Practice Test Advanced Certification question made by @Heng with 36 views.

Top 3 Topics with Most Replies

Extract Number and text from webpage and add to excel made by @NATHAN_MORA with 20 replies.

REFramwework, DataTable, Assing made by @Yurdanur_Yusuf with 15 replies.

Encrypting an entire folder made by @amruta_George with 15 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 40 posts!

@Rahul_Unnikrishnan made 40 posts!

@ppr made 23 posts!

Top 3 Most Liked Posts

This post made by @Sudharsan_Ka received 3 likes!

Minimize all the other application

Hello Everyone, I really dont know about others but i will do this each and every time when iam running the process It is minimizing each and every application after clicking on the run file button It will be helpful if you are running a process in the VM in unattended mode and the bot tries to access chrome or some other application , there is a chance to be some other folders or even Server Manager will be opened in the foreground which will affect the interactions so you can use…

This post made by @cindy10 received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

hi i am Germany. I am new to Data management. Hope this forum helps me in moving forward.

This post made by @dsellers received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hey would you like to study sometime ? Im taking the exam again soon and need help studying

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

Creating a list/array from input dialog

Hi @Short , You would need to use a String type variable as the output variable for this. In the Input Dialog, we could mention as to How the words would be considered as separate words like below : [image] We could then perform a Split by comma to get the data in an array format, if that is the intended output. [image]

This solution provided by @Gokul_Jayakumar received 1 likes!

Chrome download box appear issue

@learning_sourav try this activity, Wait for Download [image]

This solution provided by @ppr received 1 likes!

Filtering repeating values in excel join datatable

just handle outcomes seperated: A: Protoype code in its box where do see the results or fails B: the adapted own implementation For A: show the case of fail by get bound to the sample data schema For B: share with us your implementation About: where data is: [grafik] with a given requirement / discussions and mentioning: where we also see: [grafik] then it is explained, why a single line is blocked. Looks like a defect in the requirement definition. but with the highlight to fi…

---

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

Top 3 Topics with Most Views

How to fix this error using Linq Query made by @Sai.Srinivas with 48 views.

How Artificial Intelligence helps Businesses made by @hardinscott771 with 43 views.

Renames made by @Ak_4 with 39 views.

Top 3 Topics with Most Replies

I need to extract all the subFolder(including subFolder of subfolders) made by @manipreethi410 with 27 replies.

Xls to xls problem made by @heyium with 27 replies.

assing,reFramework,get text made by @iremdgn42 with 24 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 66 posts!

@Sudharsan_Ka made 47 posts!

@Rahul_Unnikrishnan made 24 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 11 likes!

ppr 2000th Solution Flag Celebration

@ppr Congratulations on your 2000th Solution Flag! [image] We would like to express our thanks for your great contributions!

This post made by @Veera_Raj received 5 likes!

Has Failed In Uiard exam

Hi All, Hope you all doing well. I’m sharing my experience of Uipath UIard exam. recently i have given the UiArd exam but got failed with 69%. whoever going to give exam please go through the documentation carefully and read question very careful before select answer. I prefer go through some practical training. From uipath side at least they should provide some Appreciation certificate with how much we scored in exam that will more for encourage the developers for try again. @loginerror @UiPa…

This post made by @ppr received 4 likes!

ppr 2000th Solution Flag Celebration

@Yoichi @jeevith Thank you for the congratulations. It’s nice to make this journey together with the active UiPath community. It always makes me happy when I can support members in their journey and we grow together. A great future lies ahead with many rocking still waiting to be created. Thank you all

Top 3 Most Liked Solutions

This solution provided by @Sudharsan_Ka received 1 likes!

Best practice for credentials

HI @ludovic.vetter Credential must be unaccessable by others so it will be either on orchestrator and Windows Credential manager If your process will run on other machine orchestrator will be good if you ran in the same machine as developed windows credentials is fine Else you can do this way First check on windows credentials and if it has credential you can go ahead if not get if from orchestrator and go ahead Regards Sudharsan

This solution provided by @supermanPunch received 1 likes!

Remove Data Column by index

Hi @MikeC , Have you used Filter datatable Activity and mentioned the indices you want to remove? [image]

This solution provided by @Sudharsan_Ka received 1 likes!

How to fix this error using Linq Query

Hi @Sai.Srinivas Checkout your updated xaml and output file Main.xaml (10.2 KB) Status.xlsx (10.4 KB) 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 | 24 September 2022

Top 3 Topics with Most Views

File path made by @guptasweb with 36 views.

9/14/2022(MM/dd/yyyy) Change this date to 14/9/2022(dd/MM/yyyy) made by @428e10c08f35f5a9e7b4cece6 with 34 views.

Linq Query To get data from json made by @RK_0 with 32 views.

Top 3 Topics with Most Replies

9/14/2022(MM/dd/yyyy) Change this date to 14/9/2022(dd/MM/yyyy) made by @428e10c08f35f5a9e7b4cece6 with 12 replies.

File path made by @guptasweb with 12 replies.

Orchestrator is unable to connect to studio and Uipath assistant made by @VJ_KY with 10 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 20 posts!

@Gokul_Jayakumar made 14 posts!

@Sudharsan_Ka made 13 posts!

Top 3 Most Liked Posts

This post made by @AMALRAJ received 1 likes!

ppr 2000th Solution Flag Celebration

Congratulations @ppr . Heartfelt congratulations on your hard-earned 2000th solution achievement. keep rocking. Regards AMALRAJ

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

ppr 2000th Solution Flag Celebration

Congratulations @ppr for your contribution to the community and providing the high quality solutions. I wish you continue the same and keep guiding us.

This post made by @Sudharsan_Ka received 1 likes!

文字列の分割について

Hi @CaptNob Welcome To the Community!! Check out these expressions Split(System.Text.RegularExpressions.Regex.Replace("_____123_______12,345_____123.45","_+","_"),"_")(1) Split(System.Text.RegularExpressions.Regex.Replace("_____123_______12,345_____123.45","_+","_"),"_")(2) Split(System.Text.RegularExpressions.Regex.Replace("_____123_______12,345_____123.45","_+","_"),"_")(3) If you needed in the array of string use this in your for each and loop through the items Split(System.Text.Regula…

Top 3 Most Liked Solutions

This solution provided by @jeevith received 1 likes!

How do i update the header of my test case?

Hi @tile2, The manual way Sadly renaming the .xaml file does not update the Display Name or Click on the outermost sequence in your test case then see the properties panel, you will then need to update the name to your required name. To achieve what you are trying, you need to change the “DisplayName” property of the test case. Click on the outermost container not within the sequence but outside (sadly I cannot show this because of a recent bug/feature : The Sequence (container) is not shown…

This solution provided by @Sudharsan_Ka received 1 likes!

I need to extract all the subFolder(including subFolder of subfolders)

I have received all the folders inside the folder have checked it untill the end It will loop like First root folders Root Folder → Folder Root Folder → Folder-> FOlder and etc Regards Sudharsan

This solution provided by @ppr received 1 likes!

Linq Query To get data from json

Sound like filtering. Give a try at: myResult | List(Of JObject) YourDeserializedJSONObjectVar("Rules").Values(Of JObject).Where(Function (x) x("RuleId").Value(Of String).Equals("001")).toList then depending on the return result: 0, 1 possible also more JObjects, we can retrieve the DeffaultErrorLevel Some additional illustrations with similar test data: [grafik] So we prefer to filter for the Rule JObject and deciding then, when existing after filtering to use the retrieval for the Defa…

---

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

Top 3 Topics with Most Views

Unable to get a Dropdown in Form made by @Jayavignesh_G with 60 views.

How to extract one part of the string made by @gokul1904 with 35 views.

Error: A foreground process is already running made by @raven with 35 views.

Top 3 Topics with Most Replies

Error: A foreground process is already running made by @raven with 13 replies.

DT Remove Row on Condition (Filter Wizard) made by @MikeC with 6 replies.

Compare two excel sheet and check the two column values are match or not made by @lokeshkumar.k with 6 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 11 posts!

@raven made 11 posts!

@marian.platonov made 5 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Update value of a json file

Cross reference:

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

How to call Data from Data service using Basic Authentication in Postman API

Thank You so much I’ll try this method.

This post made by @gokul1904 received 1 likes!

How to extract one part of the string

Hi team , I have below - stringA - C:\ABC_Company\AP_Bot_Invoices - Documents\Development\AP\Sep 2022\09242022\HRC12309853768\In-Progress\HRC12309853768_2022-09-24_12.pdf I want to get stringB - Development\AP\Sep 2022\09242022\HRC12309853768\In-Progress\HRC12309853768_2022-09-24_12.pdf i.e Want to extract everything after Documents\ I always want to extract part of string after “Documents\” Can you please help achieve this

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Update value of a json file

Cross reference:

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

How to extract one part of the string

you can get stringB using regular expression System.Text.RegularExpressions.Regex.Match(stringA, "Documents\\(.*?)$").groups(1).Value use this sequence for reference Sequence.xaml (7.4 KB) result [image]

---

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

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

[system]

Daily Forum Report | 26 September 2022

Top 3 Topics with Most Views

Document Understanding - Digitization Service Public Preview made by @Monica_Secelean with 57 views.

How to delete/remove from starting to a specific item of an array made by @suresh.ghadai with 46 views.

How to provide regex made by @Chippy_Kolot with 44 views.

Top 3 Topics with Most Replies

Match column and update after concating to another column made by @Shilpa_Mohanty with 27 replies.

How to delete/remove from starting to a specific item of an array made by @suresh.ghadai with 21 replies.

Python Scope: Error initializing Python engine made by @Aastha_Singh with 15 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 40 posts!

@Gokul_Jayakumar made 25 posts!

@Sanjit_Pal made 25 posts!

Top 3 Most Liked Posts

This post made by @Monica_Secelean received 5 likes!

Document Understanding - Digitization Service Public Preview

Create automations using the framework capabilities of Document Understanding not only via RPA - newly, also via REST APIs hosted on the cloud, up & running in a matter of minutes In this sense, we’re happy to announce the launch of our first service: the Digitization Service - allowing, as the name suggest, to read the text from images or PDFs - offering support for various OCR types, used on demand, defaulting to the in-house built UiPath Document OCR. Having the Digitization Serv…

This post made by @dominik.hildebrandt received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, i am from Germany. I am an SAP Consultant for FI/CO and now working with UiPath. Looking forward to work with you.

This post made by @Jobin_Joy received 2 likes!

UiPath Activity Creator

Hi @loginerror Thank you so much for this update!

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

Regex, string manupulation

Yes @TUSHAR_DIWASE System.Text.RegularExpressions.Regex.Match(YourString,"(?<=on\s)\d.{2}\S.{1,8}\d{2}").Tostring Regards Gokul

This solution provided by @Gokul001 received 2 likes!

How to add a cron expression to run a bot daily but on four diffrent times of a day

Hi @sagar.raval You can try with the below link for CRON [image] Go to → trigger → Click Plus → Select Advance → 0 0 6,11,14,23 ? * * * [image] Regards Gokul

This solution provided by @Tapan_Behera1 received 2 likes!

GetExchangeMailMessages Activity - No Filter fields under Options

Yes @Steven_McKeering You can try this approach: Read the mails using Get Exchange mail activity and store in mails variable. Then use the search query using assign activity mails= search_query

---

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

Top 3 Topics with Most Views

How to pick latest date in excel using UiPath made by @Baby123 with 39 views.

ブラウザーを開く（OpenBrowser)で指定のURL先のWebページの完全表示を待つことができない made by @jasano with 38 views.

Not able to close window after clicking on exit button made by @Sam_H with 36 views.

Top 3 Topics with Most Replies

Not able to close window after clicking on exit button made by @Sam_H with 25 replies.

How to pick latest date in excel using UiPath made by @Baby123 with 22 replies.

How to read excel and enter the data into web forms.Help made by @punnipah with 20 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 53 posts!

@Tapan_Behera1 made 33 posts!

@Rahul_Unnikrishnan made 25 posts!

Top 3 Most Liked Posts

This post made by @sivaprasad.as received 2 likes!

Monthly Forum rewards - August 2022

congrats @Rahul_Unnikrishnan

This post made by @MatiM received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello Everyone, My name is Mathewos, but you all can call me Mathew. I’m here to learn Automation and was fascinated by my first Automation I built with StudioX. The concepts presented were amazing and my first hands-on experience with StudioX was amazing. I’m already thinking of tasks that can be easiy automated like Opening A ServiceNow Application and logging in call tickets and retrieving call tickets. Opening a mail application to view, compose, and send mail electronically. Using Data S…

This post made by @sivaprasad.as received 1 likes!

Monthly Forum rewards - August 2022

Congrats @muhamed_fasil

Top 3 Most Liked Solutions

This solution provided by @Gokul_Jayakumar received 1 likes!

How to split amount of USD

@Anand_Designer Try this String-> cint((System.Text.RegularExpressions.Regex.Match(YourString,"(?<=USD\s)\d.+").Tostring).Replace(",","")).ToString Integer-> cint((System.Text.RegularExpressions.Regex.Match(YourString,"(?<=USD\s)\d.+").Tostring).Replace(",","")) [image]

This solution provided by @ppr received 1 likes!

Simple Json Parsing a specific value

with [grafik] we can do [grafik]

This solution provided by @Tapan_Behera1 received 1 likes!

How to prevent typing simulation and just paste the value stored in memory

Hi @kaiji_San you can also use set text activity instead of simulate type

---

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

Top 3 Topics with Most Views

Try Catch activity for Run Query made by @redanime94 with 45 views.

Generic Predict Error Machine Learning Based Extractor made by @Dharsyana_Rao_a_l_Selladu with 42 views.

Regex to replace multiple comma with single space made by @naveenkumarr with 41 views.

Top 3 Topics with Most Replies

Selector won't click the dynamic data made by @Rhys18 with 31 replies.

How to delete the old excel file from a folder made by @HeartCatcher with 19 replies.

Generic Predict Error Machine Learning Based Extractor made by @Dharsyana_Rao_a_l_Selladu with 14 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 34 posts!

@Rahul_Unnikrishnan made 34 posts!

@Tapan_Behera1 made 27 posts!

Top 3 Most Liked Posts

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

Getting an error in Swagger API while executing Test Data Queues Query ("message": "testDataQueue must not be null",)

Try to see if this body is working for you: {"Name":"Test_Data_Queue_2","Description":null,"ContentJsonSchema":"{\r\n \"Name\": \"string\",\r\n \"Description\": \"string\",\r\n \"ContentJsonSchema\": \"string\",\r\n \"ItemsCount\": 0,\r\n \"ConsumedItemsCount\": 0,\r\n \"IsDeleted\": true,\r\n \"DeleterUserId\": 0,\r\n \"DeletionTime\": \"2022-09-28T17:58:07.639Z\",\r\n \"LastModificationTime\": \"2022-09-28T17:58:07.639Z\",\r\n \"LastModifierUserId\": 0,\r\n \"CreationTime\": \"2022…

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

How to export Queue data from Orchestrator without logging in to Orchestrator?

You can do this by using the /odata/QueueDefinitions(QUEUE_ID)/UiPathODataSvc.Reports endpoint. GET for https://cloud.uipath.com/your_org_name/your_tenant_name/orchestrator_/odata/QueueDefinitions(YOUR_QUEUE_ID)/UiPathODataSvc.Reports?$top=1000&$expand=Robot,ReviewerUser&$orderby=Id%20desc [image] [image] [image] [image]

This post made by @StefanSchnell received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello Mathew, welcome in the UiPath Community, excellent introduction, happy automation. Best regards Stefan

Top 3 Most Liked Solutions

This solution provided by @marian.platonov received 2 likes!

Getting an error in Swagger API while executing Test Data Queues Query ("message": "testDataQueue must not be null",)

Try to see if this body is working for you: {"Name":"Test_Data_Queue_2","Description":null,"ContentJsonSchema":"{\r\n \"Name\": \"string\",\r\n \"Description\": \"string\",\r\n \"ContentJsonSchema\": \"string\",\r\n \"ItemsCount\": 0,\r\n \"ConsumedItemsCount\": 0,\r\n \"IsDeleted\": true,\r\n \"DeleterUserId\": 0,\r\n \"DeletionTime\": \"2022-09-28T17:58:07.639Z\",\r\n \"LastModificationTime\": \"2022-09-28T17:58:07.639Z\",\r\n \"LastModifierUserId\": 0,\r\n \"CreationTime\": \"2022…

This solution provided by @Sudharsan_Ka received 1 likes!

Extract two rows from data table

Yes you can my idea of doing this is Before using this you can use filter datatable and filter only the column you want and filter them with the datatable dt and store them in same dt and use that updated filtered dt in your expression to take 2 rows [image] Hope this Helps Regards Sudharsan

This solution provided by @supermanPunch received 1 likes!

Extracting sentence with set word in it

Hi @Short , We could try by Reading the PDF file using Read PDF Text Activity (Mostly PreserveFormat property enabled), then we can split the text based on new line. textArray = Split(pdfText,Environment.NewLine).ToArray Here, textArray is a variable of type Array of String. Next, we perform the word search and grab the entire sentence like below : foundSentences = textArray.Where(Function(x)x.tolower.Contains("yourWordToSearch")).ToArray Here, foundSentences is also an Array of String ty…

---

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

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

[system]

Daily Forum Report | 29 September 2022

Top 3 Topics with Most Views

[要素を探す]アクティビティ 「表示されるまで待つ」プロパティの効果について made by @yoshimura.tomoko with 43 views.

Change the cell format as number made by @Aarthy1 with 42 views.

Remove duplicates comparing only 2 columns in excel made by @gokul1904 with 39 views.

Top 3 Topics with Most Replies

Filterr made by @Yurdanur_Yusuf with 20 replies.

Can't found Robot tab in Orchestrator made by @ThomasTH with 19 replies.

Change the cell format as number made by @Aarthy1 with 15 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 32 posts!

@raja.arslankhan made 31 posts!

@Gokul001 made 29 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 2 likes!

Is it possible to choose default selected methods for modern experience?

Hi @mateuszmacheta , If you check the Project Settings Panel, we have ways for configuring the selection by default : [image]

This post made by @Marius_Puscasu received 2 likes!

Automation in excel

Hello @ldiaz , An alternative would be to use VLookup activity link: https://docs.uipath.com/activities/docs/v-lookup-x It seems that there is a mess with all those 3 datatables dt1, dt_update and dt_output, that if condition and the nested for each row. Hope it helps! Best regards, Marius

This post made by @Adrian_Star received 1 likes!

How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right

Hi, solution to your problem: arr_text As Array of Strings arr_text = Split(your_text, Environment.NewLine) Usage details in the first post:

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

Is it possible to choose default selected methods for modern experience?

Hi @mateuszmacheta , If you check the Project Settings Panel, we have ways for configuring the selection by default : [image]

This solution provided by @Marius_Puscasu received 2 likes!

Automation in excel

Hello @ldiaz , An alternative would be to use VLookup activity link: https://docs.uipath.com/activities/docs/v-lookup-x It seems that there is a mess with all those 3 datatables dt1, dt_update and dt_output, that if condition and the nested for each row. Hope it helps! Best regards, Marius

This solution provided by @Marius_Puscasu received 1 likes!

Header,slip

Hello @Yurdanur_Yusuf , Please use StringSplitOptions.RemoveEmptyEntries like this: [image] 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 | 30 September 2022

Top 3 Topics with Most Views

Can robot mention number displayed made by @Rhys18 with 41 views.

What questions should i ask about infra setup made by @it13 with 39 views.

Keyboard short cuts in excel made by @cury with 39 views.

Top 3 Topics with Most Replies

Error - This folder doesn't exist - Developer Foundation Training made by @MOUNIA_S with 31 replies.

Can robot mention number displayed made by @Rhys18 with 18 replies.

Compare each line of row of 2 excel file made by @Tmo with 15 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 24 posts!

@Rahul_Unnikrishnan made 21 posts!

@marian.platonov made 16 posts!

Top 3 Most Liked Posts

This post made by @navya.haritha received 1 likes!

How works dynamics selector into the Modern Design Experience?

In fuzzy selector we can level of accuracy of the output based on fuzzy level accuracy(0-1) 0- lower the accuracy level, it returns the result with lower matching result related to the tag_name. 1- higher the accuracy level, it returns the result with higher matching result related to the tag_name for an example : If I have to input 123-098 , if I exactly type how it is than with better accuracy it will give the output, instead of that if I type 123098 than have to change the fuzzy accuracy …

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

Online Piano Playing Process

Hello everyone, I designed a process that navigates to an online piano site and plays selected songs. I tried to make the output look like human output by putting certain delays. I wanted to share the technical document of the project with you. In addition, you can watch the work of the process from my sharing on the Linkedin platform, a little music break Kind regards OnlinePiano.zip (298.9 KB)

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

How to assign JIRA Issue to a JIRA user using Assign Issue activity?

The UiPath Jira activity package supports only Jira Cloud instances.

Top 3 Most Liked Solutions

This solution provided by @marian.platonov received 1 likes!

How to assign JIRA Issue to a JIRA user using Assign Issue activity?

The UiPath Jira activity package supports only Jira Cloud instances.

This solution provided by @ppr received 1 likes!

How to get specific value from variable

it is about JSON Data Processing Use Desrialize JSON Activity (UiPath.WebApi.Activities Package) - myJObject then use an assign Activity: strID = myJObject("id").Value(Of String)

This solution provided by @sharon.palawandram received 1 likes!

Leveraging existing ML Skills for prelabelling

you can already use URLs of ML skills which have been made public in AI Center on-premises or in AI Center Cloud. This methodology ensures that there are only a few extra fields that require manual labeling.

[Previous Month] Top 3 Users with the most likes on their solutions

@Gokul001 received 43 likes for their solutions!

@ppr received 37 likes for their solutions!

@Yoichi received 30 likes for their solutions!

---

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

Top 3 Topics with Most Views

Safe Search: Cannot access a disposed object. Object name: 'Google.Apis.Http.ConfigurableHttpClient' made by @SJ_LIN with 33 views.

How to trim a column in datatable.select? I tried using Covert but its not working made by @pk123 with 31 views.

UiPath Support Ticket issue - Invalid email domain for your account! made by @vivekktr with 29 views.

Top 3 Topics with Most Replies

Dispatcher and Performer Question made by @Gus_Fring with 15 replies.

UiPath Support Ticket issue - Invalid email domain for your account! made by @vivekktr with 9 replies.

Compare 2 excel sheets and get 3rd column value made by @soundarya.a with 8 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 19 posts!

@marian.platonov made 12 posts!

@Tapan_Behera1 made 11 posts!

Top 3 Most Liked Posts

This post made by @Gus_Fring received 1 likes!

Dispatcher and Performer Question

Thank you @Tapan_Behera1 for your help

This post made by @raja.arslankhan received 1 likes!

How to wait still the progress bar disappear

Hi @Kumar_Shanmugam Make custom delay. Use while loop and check inside element exist activity if element not exist it loop should be break then you will preceed next record. Thanks

Top 3 Most Liked Solutions

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

---

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

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

[system]

Daily Forum Report | 02 October 2022

Top 3 Topics with Most Views

Working with Xpath made by @agathiyanv with 38 views.

Orchestrator Error Issue made by @RamgopalHS with 33 views.

I need to filter list of 11 months before date from current date made by @lokeshkumar.k with 32 views.

Top 3 Topics with Most Replies

Ignore if row contains alphabets made by @JesseChasen with 6 replies.

Hexadecimal value 0x00, is an invalid character made by @adamtan831 with 5 replies.

Excel automate in uipath made by @Ak_4 with 5 replies.

Top 3 Users Who Posted The Most

@Yoichi made 5 posts!

@agathiyanv made 4 posts!

@cury made 3 posts!

Top 3 Most Liked Posts

This post made by @Emira received 1 likes!

Excel Automation 3

Hi Can you give an example on the result you want to achieve?

This post made by @cury received 1 likes!

Pivot change dat source

It was incorrect usage. Corrected it. Thank you.

This post made by @JesseChasen received 1 likes!

Ignore if row contains alphabets

Thank you @Yoichi it works!

Top 3 Most Liked Solutions

This solution provided by @cury received 1 likes!

Pivot change dat source

It was incorrect usage. Corrected it. Thank you.

---

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

Top 3 Topics with Most Views

Genereate Datatable from String made by @Yezdani_Shaik with 63 views.

How to solve this Regex made by @Chippy_Kolot with 56 views.

Maximizing Excel via Using VB.Net made by @yigit.aybey with 53 views.

Top 3 Topics with Most Replies

For each loop, type into, string array made by @RACHEL_PAUL with 15 replies.

Genereate Datatable from String made by @Yezdani_Shaik with 14 replies.

Mails not filtered based on from address made by @GaneshPalaniappan with 14 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 26 posts!

@Yoichi made 19 posts!

@omer.ozturk made 11 posts!

Top 3 Most Liked Posts

This post made by @timothy.martinez received 1 likes!

SCCM command line for UIPathStudio.msi 22.4 is not working

Thank you so much for your response. We are looking forward for the resolution of this

This post made by @HainTavuk received 1 likes!

How could I merge 2 values of 2 columns and transfer them to a new column?

you can use write cell activity to write the formula to the excel and then use auto fill range activity to apply on all rows

This post made by @Gokul001 received 1 likes!

How could I merge 2 values of 2 columns and transfer them to a new column?

HI @pprin070 Check Out the XAML file [image] MergeColumn.xaml (9.4 KB) Output [image] Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

Maximizing Excel via Using VB.Net

Hi @yigit.aybey , Could you try replacing the screenSize.Maximize() with the below : Microsoft.Office.Interop.Excel.XlWindowState.xlMaximized Let us know if you still get an error.

This solution provided by @Dharsyana_Rao_a_l_Selladu received 1 likes!

Chinese, Korea Japan Endpoint not supported

I’ve found the solution, use the OCR- Japanese, Chinese, Korean activity rather than the normal UiPath Document OCR and use this endpoint. https://du.uipath.com/cjk-ocr

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

Linq help

Hi @ldiaz Try this approach [image] [image] [image] Refer the project DT_CompareAndUpdateColumnValues.zip (15.3 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 | 04 October 2022

Top 3 Topics with Most Views

今後の非推奨化予定 について made by @miwa_yamamoto with 51 views.

How to filter out the zero value from that column? made by @Kakooza-Allan-Klaus with 47 views.

Wierd behaviour of navigate to activity when using attr='src' made by @sagar.raval with 44 views.

Top 3 Topics with Most Replies

How to filter out the zero value from that column? made by @Kakooza-Allan-Klaus with 24 replies.

Wierd behaviour of navigate to activity when using attr='src' made by @sagar.raval with 22 replies.

今後の非推奨化予定 について made by @miwa_yamamoto with 13 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 21 posts!

@omer.ozturk made 18 posts!

@sagar.raval made 15 posts!

Top 3 Most Liked Posts

This post made by @ceeceehurt received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, I am just starting out this journey. I am excited to learn and grow with this community.

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

Welcome to our Forum! Please introduce yourself to our Community

Hi Everyone, I am Ömer Özturk, from Turkey. I have been working in the RPA industry for about two years and provide consultancy services. Nice to meet you, see you in the posts Kind Regards.

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

Unable to import template (Form Extractor) for Document Understanding Demo

Have you checked if all files are intact in your zip file? Also you can close and open the extractor again to see if it has gotten updated.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Assistatnt から実行する際のMainの引数の既定値について

こんにちは 以下あたりから認識されているバグなのですが、まだ解消されませんね．．．． バグ解消を待つか、引数の処理を変更するかですが．．．．

This solution provided by @Yoichi received 1 likes!

Issue with decimal

Hi, How about the following expression? [image] Math.Floor(123456.12537*100)/100 Regards,

This solution provided by @Yoichi received 1 likes!

今後の非推奨化予定 について

こんにちは まずプロジェクトの種類として、21.10以降、従来のWindows-Legacyに加え、Windows,およびCrossPlatformが選択できるようになりました。 今後これら追加されたWindowsおよびCrossPlatformが主流になり、Windows-Legacyは非推奨と なります。 上記のドキュメントから、Studio23.4以降はWindowsLegacyのプロジェクトを新規作成することが できなくなりますので、それを踏まえて、WindowsまたはCrossPlatformを使うよう計画を立てましょうということになります。 なおWindows Legacyプロジェクトの編集は当面可能のようなので、そのままにしておくか、保守上統一したほうが良ければ、マイグレーションする等に対応になると思います。

---

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

Top 3 Topics with Most Views

LINQ skip data while equal made by @mz3bel with 51 views.

Read range of excel rows with skipping rows made by @Kuro with 44 views.

Read and write into excel made by @rene.stein with 41 views.

Top 3 Topics with Most Replies

Find text and click on it made by @gilang_ramadhan123 with 19 replies.

For each excel row, get the cell after "A" and put it into the datable of Column A made by @Ben_siu with 12 replies.

Issue with Add Data Row, repeating the data in the DT made by @indrajit.shah with 12 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 21 posts!

@Yoichi made 13 posts!

@Gokul_Jayakumar made 13 posts!

Top 3 Most Liked Posts

This post made by @Nicholas_Noel-Labieniec received 1 likes!

UiPath Academy - Descriptor (Unified Target method uses which targeting methods?)

Looks like it was fixed. [Screenshot_20221005-063745_Chrome]

This post made by @ppr received 1 likes!

ppr 2000th Solution Flag Celebration

@kumar.varun2 thanks for the feedback and also for your collaborations. Together we can achieve more

This post made by @Jonathan_Knopp received 1 likes!

Automation Awareness - The Automation Journey - We want to hear your thoughts!

I am excited to learn about StudioX!

Top 3 Most Liked Solutions

This solution provided by @loveleet_Saini received 1 likes!

Usage of Excel SaveAs Method

Hi @yigit.aybey You need to provide an Extension to your file in the path. For Example “C:\Users\Admin\Downloads\Checkboxes\Samples\checkboxes.xlsx”

This solution provided by @Emira received 1 likes!

Read and write into excel

Hi I think this is the best and easiest way to achieve that. All you need to do now is Loop through your folders and files. Let me know if that helps. Excel Automation.zip (44.4 KB)

This solution provided by @loveleet_Saini received 1 likes!

Conditional Looping Based On Previous Cell Value of Excel Sheet

Hi @sravan_8844 Assign Variable for Company and department which will store Company and department name temporary for matching purpose. Please Refer Below Solution Test1.xaml (15.0 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 | 06 October 2022

Top 3 Topics with Most Views

Wait for download not working with delay added made by @Nathan_Betters with 45 views.

Filter few columns with LINQ made by @indrajit.shah with 44 views.

Get IMAP Mail messages got failed for all out Prod processes suddenly made by @Mamidwar_Anil_Ramlu with 42 views.

Top 3 Topics with Most Replies

Click an element in chrome browser made by @venkateshcheeni09 with 28 replies.

Download Files from WebPage Using UiPath made by @hsendel with 17 replies.

Filter few columns with LINQ made by @indrajit.shah with 16 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 46 posts!

@Sudharsan_Ka made 37 posts!

@Rahul_Unnikrishnan made 29 posts!

Top 3 Most Liked Posts

This post made by @raja.arslankhan received 7 likes!

Monthly Forum rewards - September 2022

Congratulations @Gokul001 @StefanSchnell and all nominated guys. you done great job.

This post made by @Sudharsan_Ka received 5 likes!

Monthly Forum rewards - September 2022

Congrats All !!! Regards Sudharsan

This post made by @Kaviyarasu_N received 5 likes!

Monthly Forum rewards - September 2022

Congrats guys

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Delete first few rows in csv filew

HI, If you need to manipulate csv file directly, the following will help you, for example. (The following delete first 3 rows except header) [image] strCSV = System.Text.RegularExpressions.Regex.Replace(strCSV,"(?<=^.*\n)(.*\n){3}","") or i f you need to handle datatable, the following will work. [image] Regards,

This solution provided by @supermanPunch received 1 likes!

Doing Unhide in Excel sheet/s

Hi @yigit.aybey , Maybe changing the above to the below Expression would work : xlsSheet.Visible = Microsoft.Office.Interop.Excel.XlSheetVisibility.xlSheetVisible Let us know if it results in an error.

This solution provided by @ahmad.sultan received 1 likes!

Postpone Queue item

If you have a trigger placed on your queue, then it will be treated just like other queue items after the postpone time. If you don’t have any trigger on your queue, then you will have to check the queue if there’s any queue item to process, but again it will be only be considered to process after postpone time.

---

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

Top 3 Topics with Most Views

Rate Process Mining on Gartner and get rewarded! Only until Oct 14th made by @Dana_Mustatea with 41 views.

Unattended bot is not working under lock screen made by @Rahul_Thombare with 40 views.

RPC SERVER ISSUE made by @Gokul_Murali with 40 views.

Top 3 Topics with Most Replies

String cannot be converted to Secure String made by @Vaishnav_Tej with 18 replies.

How to extract data in a specific column? Data that falls between two words made by @Marcelo_Melo with 13 replies.

How to find the maximum value for an Unique ID using linq made by @anjana.k with 13 replies.

Top 3 Users Who Posted The Most

@Sudharsan_Ka made 46 posts!

@Gokul001 made 40 posts!

@supermanPunch made 16 posts!

Top 3 Most Liked Posts

This post made by @Dana_Mustatea received 4 likes!

Rate Process Mining on Gartner and get rewarded! Only until Oct 14th

Share your experience with Process Mining on Gartner and get rewarded! Guidelines / Please read this carefully You can write your review here Deadline: Oct 14th Rewards: The first 50 reviewers of UiPath will get a $25 Visa.com‌ gift card Your gift card will be automatically issued by the Gartner team once your review get approved

This post made by @arivu96 received 2 likes!

Monthly Forum rewards - September 2022

Congratulations to all

This post made by @Gokul001 received 2 likes!

How to achieve iterate in SAP Tree to identify if there is multiple task

Hi @Gwen Check out the thread Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @Divya_Sadhasivam received 1 likes!

Unable to select Specific element in SAP 770 version

Hai @LevKushnir , the issue was solved thank you!!! Actually the authorization Rights is disabled from client side , now issue was solved. [image]

This solution provided by @Sudharsan_Ka received 1 likes!

Opening the Specific Excel Sheet Via vb.Net

Okay @yigit.aybey Try with this code xlsSheet = CType(xlsWB.Worksheets(sheetname), Microsoft.Office.Interop.Excel.Worksheet) xlsSheet.Activate Pass your sheet name in the parameter [image] Hope this helps Regards Sudharsan

This solution provided by @Gokul001 received 1 likes!

Regular expression in data extraction

[image] System.Text.RegularExpressions.Regex.Match(YourString,"(?<=^x|^X).*").Tostring Regards Gokul

---

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

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

[system]

Daily Forum Report | 08 October 2022

Top 3 Topics with Most Views

Data Manipulation Issue made by @arsalanrasheed143 with 38 views.

Can not Add Local User to Folder - on Prim Orchestrator made by @mahmoud.zaky with 29 views.

Testing licence robot status disconnected made by @Rachel7 with 28 views.

Top 3 Topics with Most Replies

Testing licence robot status disconnected made by @Rachel7 with 11 replies.

My problem with the rpa challenge is that I can't get it to count. It's zero made by @Mert_Samet_Sonmez with 9 replies.

Require solution and related activities of use case made by @Vinay_Gite with 9 replies.

Top 3 Users Who Posted The Most

@Sudharsan_Ka made 26 posts!

@marian.platonov made 10 posts!

@Gokul001 made 9 posts!

Top 3 Most Liked Posts

This post made by @AMALRAJ received 1 likes!

Monthly Forum rewards - September 2022

Congratulations to all the winners. Regards AMAL

This post made by @Gokul001 received 1 likes!

How to extract a paragraph from text file based on condition

Can you tell us what do you want to achieve in this Ismatch activity @Vidhi_Patel

This post made by @Gokul001 received 1 likes!

How to extract a paragraph from text file based on condition

Hi @Vidhi_Patel You can try like this 0 – 5[A-Za-z\d\D\n\W].+\n.+\n.+\n.+ [image] Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

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

こんにちは まずStudioのバージョンはいくつをお使いでしょうか？インストールモードは何を選択されていますか？ またインターネット接続環境では正しくプロジェクトを新規作成することができるということでしょうか？ ローカルにアクティビティパッケージを導入している場合、新規プロジェクトの場合 基本的にはそこへの参照だけですべてのアクティビティパッケージおよびその依存関係は 解決されるはずですので、状況としては少々奇妙な状況かと思います。 あるいはオンラインフィードへの参照で何か問題があり、これによって全体に影響を 及ぼしているようでしたら、nugetの参照先の設定を変更するか、 「オンライン フィードを無効化」のオプションを有効にしてインストールした方が 良いように思えます。

This solution provided by @marian.platonov received 1 likes!

Calling Orchestrator API using external Apps - On Prim Orchestrator

The configuration of the external application is not correct based on your called method in Postman. Perform these steps: Go to https://your_orchestrator_hostname/identity/management/externalApps Delete the External App [image] Add Application → Confidential application → Add Scopes: Orchestrator API Access → Application Scope(s): OR.Queues Your external app should look in the end like below [image] Let us know if now 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.