Checking the format of a string

[Ciara]

I have a field that holds customers names. 

Eg, Lastname,Firstname

I want to create a flag that will check for the above format. 

For example: Does it meet the following criteria

• there are 2 substrings delimited by a comma
• the first substring starts with an uppercase letter followed by lowercase
• the second substring starts with an uppercase letter followed by lowercase

If the field meets all the criteria above, then give it a flag of 1, otherwise, give it a flag of 0.

Thanks

Ciara

[Ciara]

Thanks so much @Kushal_Chawda  and @Taoufiq_Zarra 

I will try both solutions..... plus I've learned a lot by breaking down your code.

Every little helps 😊

Thanks

Ciara