Hi Jithin,
I can see BOT 3027 failed today ,will reach out to you tomorrow to check.
Best Regards,
Sushant
I need regex only to fetch name after regards. “Sushant”
regards should not come.. only name is in result
Use this regex
(?i)Regards,?\s*(\w+)
in Assign activity:
strFirstName=System.Text.RegularExpressions.Regex.Match(yourTextVariable, "(?i)Regards,?\s*(\w+)").Groups(1).Value
we can work with regex:
Assign Activity:
strPattern = (?<=Best Regards.*\n).*
Assign Acitivity:
strName =
System.Text.RegularExpressions.Regex.Match(yourVar, strPattern).Value
Also have a look here:
[CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum
Hi @sshitol
you may use this regex to extract the signature
(?<=Regards)\n+.*\z
(note : Please using the trim method after the extracting the signature from the regex)
Regards,
Robinnavinraj S
I want to use multiple keywords to check for eg, thanks, regards, best regards,
in that case its not working
its fine but problem is like sometime surname also exist, in that case its not capturing that
then it should be mentioned at the begin when the requirements are shared with us:
(?i)(?<=(Best Regards|Regards|Thanks).*\n).*
1 Like
Hello Frank,
Looping @Alisson Sellaromailto:Alisson.Sellaro@morningstar.com for this case as it being followed under the SAP 20410204 which is being handled by Madrid team as the document is in German language.
Regards,
Shweta Shitole
From: Shweta Shitut Shweta.Shitut@morningstar.com
Sent: Tuesday, September 16, 2025 8:25:41 am
To: Frank Au Frank.Au@morningstar.com; Global New Funds Global.NewFunds@morningstar.com
Cc: Wanyi Kong Wanyi.Kong@morningstar.com; Linh Luu Linh.Luu@morningstar.com
Subject: Re: new share class - UBS
Hello Frank,
Sure let me check the case.
Regards,
Shweta.
From: Frank Au Frank.Au@morningstar.com
Sent: Tuesday, September 16, 2025 7:20:44 AM
To: Global New Funds Global.NewFunds@morningstar.com; Shweta Shitut Shweta.Shitut@morningstar.com
Cc: Wanyi Kong Wanyi.Kong@morningstar.com; Linh Luu Linh.Luu@morningstar.com
Subject: RE: new share class - UBS
Hi team,
Any feedback please? Also, I have found the following problem and please fix it ASAP as we need to support our client solution.
- Please set UBS Lux Global Hi Yld Bd RMB Hgd P-mdist F00001SJ0K ACTIVE status so that the fund data can be available in API center.
- The div frequency for this share class is wrong. UBS Lux Global Hi Yld Bd RMB Hgd P-mdist F00001SJ0K
- These share classes are currency hedged and class category info is missing.
* UBS Lux Global Hi Yld Bd AUD Hgd P-mdist F00001SJ0J
* UBS Lux Global Hi Yld Bd RMB Hgd P-mdist F00001SJ0K
Hi @Shweta Shitutmailto:Shweta.Shitut@morningstar.com, can you please help on this request and get this done by noon today?
Regards,
Frank
From: Frank Au
Sent: Monday, September 15, 2025 1:06 PM
To: Global New Funds Global.NewFunds@morningstar.com
Subject: RE: new share class - UBS
Importance: High
Hi team,
Please be reminded that these share classes are all monthly distributed. Please ensure the div frequency is correctly set in GPP. Thanks.
Regards,
Frank
From: Frank Au
Sent: Thursday, September 11, 2025 2:34 PM
To: Global New Funds <Global.NewFunds@morningstar.commailto:Global.NewFunds@morningstar.com>
Subject: new share class - UBS
Importance: High
Hi team,
We have received client request to cover the following share classes in our database. Can you please help to cover them asap? As we need to support client solution, please make sure they are ID ready, category ready and ACTIVE status. Thanks.
UBS (Lux) Global High Yield Bond Fund
Class (USD) P-mdist
LU3152347608
Class (HKD) P-mdist
LU3152347780
Class (AUD hedged) P-mdist
LU3152347863
Class (RMB hedged) P-mdist
LU3152347947
Regards,
Frank Au
Lead Data Consultant
+852 2973-4621 direct
frank.au@morningstar.commailto:frank.au@morningstar.com
its not working for all thanks and regards..
when there is blank line after thanks or regards, its not working
feel free to adapt:
(?i)(?<=(Best Regards|Regards|Thanks).*\s+).*
giving blank output in UiPath
Hi @sshitol
Try this regex
System.Text.RegularExpressions.Regex.Match(Input, "(?i)regards,?\s*\r?\n(.+)").Groups(1).Value
This is working for Single name as well as for having surname in it.
Thanks!!
so you can debug and inspect when doing further RnD and adaptions:
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum
and also keep in mind:
Hi team,
Please be reminded that these share classes are all monthly distributed. Please ensure the div frequency is correctly set in GPP. ->#1Thanks.
->#2Regards,
Frank
an expected anchor word is already previous to another expected anchor word. Maybe the strategy of using Regex.Matches and taking the last match can help
will it works even if there is spaces eg.
thanks,
Sushant Sadhu
in above case
this is perfect but what if i have to add more words like thanks, warm in the regex.. how i can do that
Hello @sshitol,
you can use this regex :-
System.Text.RegularExpressions.Regex.Match(emailBody.Trim, “([A-Za-z ]+)\s*$”).Value
If the provided solution is working fine. Please mark it as a solution.
Hi @sshitol
use this regex
System.Text.RegularExpressions.Regex.Match(Input, "(?i)thanks,\s*\r?\n(.+)|regards,?\s*\r?\n(.+)").Groups(1).Value
add all the words which you want in the given regex
(?i)thanks,\s*\r?\n(.+) like this just use | between each words of regex
Thanks!!