Can i split text using space delimiter?

[Dilon_Perera]

@Hani_Ibrahim

Please How to split Full Name “first and second” to obtain the first name only?

A Example : How to extract components from split text column

And also I believe that you can do this with Regex! I saw a post by Darren but It’s old and can’t find it! I think this is the code : (\w+) Maybe Darren ( @Darren_Murphy ) can confirm ?

With the Extract Matching Text column :

Thank you