Re: Regex for properly formed names
Erik Brandsberg <erik@heimdalldata.com>
From: Erik Brandsberg <erik@heimdalldata.com>
To: Shaozhong SHI <shishaozhong@gmail.com>
Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Date: 2021-10-11T15:16:29Z
Lists: pgsql-sql
Pointing back to Karsen's comment, what IS the definition, and instead of asking "what is the regex" bring the question to a higher level, such as "How can I validate that an insert on a "name" field has all the words capitalized (but just the first word). From a formal name perspective however, a name doesn't have all words capitalized, like "of" and "and" would be lower case. It may be easier to implement different logic than a regex to do this. On Mon, Oct 11, 2021 at 9:01 AM Shaozhong SHI <shishaozhong@gmail.com> wrote: > Hello, > > What is the regex for properly formed names? > > Scenario, > > Bus Stop (St Peter's Church) > > Scenario - wrongly formed name > > Bus stop (st peter's church) > > How to write a regex to detect wrongly formed names? > > Regards, > > David > -- *Erik Brandsberg* erik@heimdalldata.com www.heimdalldata.com +1 (866) 433-2824 x 700 [image: AWS Competency Program] <https://aws.amazon.com/partners/find/partnerdetails/?n=Heimdall%20Data&id=001E000001d9pndIAA>