Designer| Text Extraction from String

Mj9715

Hi All 

I have a Name field as below and need to extract the initials as shown in the field "initial". The problem is the varying lengths of first names making it difficult to use regex. I tried "REGEX_Replace([Surname], ".....(.*)", "$1")", however it works only for first names with five letters because of the five dots ".....". 

Is there a way to drop the first word of the string, that occurs before a space? Then whatever remaining needs to be initial.. Attached excel with surnames and the desired initials that needs to recreated. 

Initial	Surname
PD & JA	MARTIN P D & J A
AH & MM	RILEY A H & M M
PADDOCK	N PADDOCK
N	DALE N
JE & M	YARNALL J E & M
TW & CHUFY	LEE T W & CHU F Y

Test.xlsx

atcodedog05

Hi @Mj9715 

Here is how you can do it.

Workflow:

Hope this helps : )

inital.yxmd