| From: | Erik Brandsberg <erik(at)heimdalldata(dot)com> |
|---|---|
| To: | Shaozhong SHI <shishaozhong(at)gmail(dot)com> |
| Cc: | pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Regex for properly formed names |
| Date: | 2021-10-11 15:16:29 |
| Message-ID: | CAFcck8HJmvYm6r8cQ=QbPCH8yoQWa6sDUo71m5i=tQD4P_z-Dg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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(at)gmail(dot)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(at)heimdalldata(dot)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>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | aditya desai | 2021-10-11 15:31:57 | Re: LISTEN / NOTIFY |
| Previous Message | Steve Midgley | 2021-10-11 15:08:45 | Re: Regex for properly formed names |