Forum Engagement Daily Reports

[system]

Daily Forum Report | 10 July 2023

Top 3 Topics with Most Views

Date formatting issue occurred made by @suraj_gaikwad with 58 views.

Split the File name made by @Priyesh_Shetty1 with 57 views.

Regex to check if a string separated by pipeline contains a certain keyword made by @mnlatam with 53 views.

Top 3 Topics with Most Replies

Use Application Browser - Input Element made by @170290064 with 24 replies.

Split the File name made by @Priyesh_Shetty1 with 21 replies.

Error writing excel formula with " " made by @atarantino with 19 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 51 posts!

@Anil_G made 33 posts!

@lrtetala made 31 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Help me to get the folder name from a file path

@StevenIsRobotOnline As this is a path…it would be good to use path related commands Path.GetFileName(Path.GetDirectoryName("YourPath")) or new DirectoryInfo(System.IO.Path.GetDirectoryName("YourPath")).Name cheers

This post made by @zeynepnaz.yardim received 1 likes!

Uipath Consolidate 8 different "Google Sheets" in one Excel sheet

Hello, I would like to consolidate 8 different but same formatted tables that are made in 8 different “Google sheets” into one Excel sheet by using UiPath. As the row numbers of each sheet differs from both each-other and not fixed, it totally depends on the person who fills the sheet, I could not understand how should I write the range as “A2:?” in UiPath. I would be very happy if you could help me on both of these questions. Thank you in advance. Best regards.

This post made by @lrtetala received 1 likes!

Take action if there is text in the field

Hi @sullivanne Try like this Not String.IsNullorEmpty(CurrentRow("YourColumn").ToString) [image]

Top 3 Most Liked Solutions

This solution provided by @vrdabberu received 1 likes!

PDF extraction using Regex exp

Hi @praveena.nadi Try using the below expressions Omkumar Tolani ------------ (?<=\n)[A-Z]+\s*[A-Z]+(?=\s*[A-Z]+.[A-Z]+\s*: ) DOC.No ----------------- (?<=[A-Z]+.?[A-Z]+\s*:\s*)[A-Z]+\d+-?\d+(?=\s*[A-Z]+[a-z]+\s*: ) Policy/Cert No ----------------------- (?<=[A-Z]+[a-z]+.\s*:\s*)[A-Z]+-\d+-?\d+-?\d+-?\d+(?=\s*[A-Z]+\s*[A-Z]+) Being Policy Premium ----------------------------- (?<=[A-Z]+-\s*)\d+,?\d+.?\d+(?=\s) Tax -------------------------- (?<=TAX\s*)\d+%?(?=\s*\d+.?\d+) Total ------…

This solution provided by @Anil_G received 1 likes!

Dynamic Selector Activity Problem!

@170290064 Can you try with simulate… also the selector photos you gave look different in two pictures also can you confirm if you are getting error or is it just not clicking an moving ahead? cheers

This solution provided by @Steven_McKeering received 1 likes!

Question on delays and timeout property

Hello @A_Learner If the element is not found, the amount equals: Delay_before + Timeout. If the element is found: delay_before + delay_after + ‘the amount of time taken to click’ based upon WaitFor setting. (WaitForReady.None, WaitForReady.Interactive and WaitForReady.Complete) The default settings are: 30 seconds is the default timeout. WaitForReady.Interactive is default WaitForReady setting (aka blank). These can be configured in the project. Does this make sense? Cheers Steve

---

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.