Regex Replace Names

[rickydata]

I want to change the Names of individuals: 

,Patrick L.

, A. Miles

into: 

Patrick

Miles

[rickydata]

To clarify im trying to use Regex_Replace()

This will fit nicely to my existing formula to extract the last names. 

[IraWatt]

Hey @rickydata,

Here is one way of doing this:

[[:alpha:]]{1}\.

The first pattern captures 1 letter next to a dot.

[,\s]+

The second pattern captures any , or spaces.

If you want to learn more about Regex the community has some really quick interactive videos on getting to grips with it here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20...

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[Emmanuel_G]

@rickydata 

Find attached the way of doing that with regex_replace function.

Let me know if there is any issue and do not hesitate to mark this answer as solution if it helped.