You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How to check that every first letter of a data item is Uppercase?
- Thread starter Gary96
- Start date
sahil_raina_91
Active Member
Hi All,
How to check if every first letter of words in a data item is set to uppercase and the rest set to lowercase. ( Variable is the length of words can change in the data item)
Data item = "joHn Michael Ryan" = False
Data item = "John Micheal Ryan John" = True
You can use Regex to validate this :
^([A-Z][a-z]+\s*)+$
Last edited:
sahil_raina_91
Active Member
How would I use this with the data item?
In Utility-Strings VBO, use Action : Test Regex Match
Input
Pattern: "^([A-Z][a-z]+\s*)+$"
String: Data Item having the text value
Output
Matched will let you know if the result is True or False
sahil_raina_91
Active Member
Do you only have to check if the first letter of a word is lowercase ? OR are there other conditions too like you mentioned before ?Working. How would you manipulate that Pattern to check if the first letter is lowercase?
Working. How would you manipulate that Pattern to check if the second letter of the second word of the string is lowercase and all other first letters are uppercase?
John frank Micheal = True
John Frank Micheal = Flase
The length of the string would be 3 words.
The length of the individual characters may vary.
John frank Micheal = True
John Frank Micheal = Flase
The length of the string would be 3 words.
The length of the individual characters may vary.
sahil_raina_91
Active Member
Working. How would you manipulate that Pattern to check if the second letter of the second word of the string is lowercase and all other first letters are uppercase?
John frank Micheal = True
John Frank Micheal = Flase
The length of the string would be 3 words.
The length of the individual characters may vary.
Something like : ^[A-Z][a-z]+\s[a-z]+\s[A-Z][a-z]+$