Changing the name to specific format

[SH_94]

Dear community,

I would like to ask how can we change the name below to the format desired

Original Name

1. Jason Wong King Yong

2. Amal Binti Nadiah

3. Kelvin Kong hung hung

Output Desired

1. JWKY

2. ABN

3. KKhh

May i know is it possible to do the extraction in alteryx?

Many thanks in advance

[AngelosPachis · Accepted solution]

Hi @SH_94 ,

Here's one way you can do it using Regex

Hope that helps,

Angelos

[Qiu]

@AngelosPachis 
Nice use of the \b for word boundaries. 
It is in my notebook now. 😁

[sparksun]

/b is a good job!