- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-09-21 02:36 PM
------------------------------
Shalu Khandelwal
------------------------------
Answered! Go to Answer.
Helpful Answers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-09-21 02:58 PM
Use Utility-Strings VBO, use Action : Test Regex Match
Input
Pattern: "^([A-Z][a-z]+\s*)+$"
------------------------------
------------------------------
Vipul Tiwari
Senior Process Simplification and Optimization Designer(Solutions Architect)
Fidelity International
------------------------------
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-09-21 02:52 PM
Please try using Regex for this.
Give a pattern to check if first letter is Uppercase and rest are Lowercase.
------------------------------
------------------------------
Best Regards,
Ved Sengupta
RPA Developer
Deloitte India (Offices of the US)
Bangalore | INDIA
------------------------------
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-09-21 02:58 PM
Use Utility-Strings VBO, use Action : Test Regex Match
Input
Pattern: "^([A-Z][a-z]+\s*)+$"
------------------------------
------------------------------
Vipul Tiwari
Senior Process Simplification and Optimization Designer(Solutions Architect)
Fidelity International
------------------------------
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-09-21 02:58 PM
------------------------------
Shalu Khandelwal
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-09-21 10:07 PM
Here's what I came up with. If you needed to determine simply true or false for whether the text is formatted with the first letter as uppercase and the rest lowercase, then I think this would work in a Decision Stage. The idea is to convert the first letter to uppercase and compare it to the original, and then convert the rest of the text to lowercase and compare to the original. If no characters were changed, then we know it's in the right format:
Upper(Left([text],1))=Left([text],1) AND Lower(Right([text],Len([text])-1))=Right([text],Len([text])-1)
or
Upper(Left([text],1)) & Lower(Right([text],Len([text])-1))=Left([text],1) & Right([text],Len([text])-1)
And then if you wanted to just not even worry about it and always convert the text to the desired format, then you can use this in a Calculation Stage:
Upper(Left([text],1)) & Lower(Right([text],Len([text])-1))
I believe that both of these will work, regardless of the text that comes through and whether or not it contains numbers.
It'd be nice if we could do simple stuff like this directly in an expression using regex or whatever else, but it is possible currently even if not very nice looking. 😃
------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------
Dave Morris, 3Ci at Southern Company
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-09-21 04:27 AM
------------------------------
------------------------------
Vipul Tiwari
Senior Process Simplification and Optimization Designer(Solutions Architect)
Fidelity International
------------------------------
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-09-21 02:43 PM
Hello Dave,
One a different not with addition to your assumptions to the solution.
Why are we checking for the entire string ?
If the target is to check if the first letter is upper case and rest are lower case and we are expecting a Boolean output I think just checking if the first letter is upper case followed by checking if any other Upper case exists would do right?
I am not sure if we can try with ASCII values!
If so then I think that comparison would do.
Just suggesting as I am myself not very adapted to Regex yet. So a workaround maybe.
------------------------------
------------------------------
Best Regards,
Ved Sengupta
RPA Developer
Deloitte India (Offices of the US)
Bangalore | INDIA
------------------------------
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-09-21 03:33 PM
------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------
Dave Morris, 3Ci at Southern Company
