# Can i split text using space delimiter? **URL:** \ **Category:** Ask for Help\ **Created:** [May 10, 2022, 2:51pm UTC](https://community.glideapps.com/t/can-i-split-text-using-space-delimiter/41819 "2022-05-10T14:51:16Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\ **Post date:** [May 10, 2022, 2:51pm UTC](https://community.glideapps.com/t/can-i-split-text-using-space-delimiter/41819/1 "2022-05-10T14:51:16Z")
i try to find something to split text with delimiter “space delimiter” but i think i failed. the one i found is splitting based on count, similar to trim with left or right function at google sheet. Please How to split Full Name “first and second” to obtain the first name only? Thank you ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 10, 2022, 2:55pm UTC](https://community.glideapps.com/t/can-i-split-text-using-space-delimiter/41819/2 "2022-05-10T14:55:01Z")
A Split Text column should work to split the name into an array. Then use a Single Value column to get the first item from the array. ---
**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\ **Post date:** [May 10, 2022, 3:15pm UTC](https://community.glideapps.com/t/can-i-split-text-using-space-delimiter/41819/3 "2022-05-10T15:15:24Z")
this is a new approach for me 💐, i will try to implement it. ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [May 10, 2022, 5:13pm UTC](https://community.glideapps.com/t/can-i-split-text-using-space-delimiter/41819/4 "2022-05-10T17:13:11Z")
> [@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](https://community.glideapps.com/t/how-to-extract-components-from-split-text-column/36540) 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 ? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/d/fd786c4365bbed06dd587be9c105aec8af6a93cd.png) With the Extract Matching Text column : ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/0/402672ce88b1d4b922c63b48cfdc4d395aa01d5a.png) Thank you ---
**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\ **Post date:** [May 10, 2022, 5:17pm UTC](https://community.glideapps.com/t/can-i-split-text-using-space-delimiter/41819/5 "2022-05-10T17:17:43Z")
Thank you for your support. let’s wait for @Darren_Murphy kind confirmation. ---
**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\ **Post date:** [May 10, 2022, 5:27pm UTC](https://community.glideapps.com/t/can-i-split-text-using-space-delimiter/41819/6 "2022-05-10T17:27:35Z")
> [@Dilon\_Perera](#): > > (\w+) it works fine for English letters, but it doesn’t work with Arabic names, ---
**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\ **Post date:** [May 10, 2022, 5:28pm UTC](https://community.glideapps.com/t/can-i-split-text-using-space-delimiter/41819/7 "2022-05-10T17:28:38Z")
Hello @Jeff_Hager , i am not able to find a column named Split Text. please advise. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 10, 2022, 5:34pm UTC](https://community.glideapps.com/t/can-i-split-text-using-space-delimiter/41819/8 "2022-05-10T17:34:21Z")
> **[Split Text Column](https://docs.glideapps.com/all/topics/computed-columns/primary/split-text-column)** ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [May 10, 2022, 5:40pm UTC](https://community.glideapps.com/t/can-i-split-text-using-space-delimiter/41819/9 "2022-05-10T17:40:00Z")
Does this works? I guess it should! `(.+)\s((?!\.))` ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/1/d1ba9f08a63c94b2da2249d973e6bf9ea85a1a01.png) ---
**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\ **Post date:** [May 10, 2022, 5:59pm UTC](https://community.glideapps.com/t/can-i-split-text-using-space-delimiter/41819/10 "2022-05-10T17:59:46Z")
I will try ---
**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\ **Post date:** [May 11, 2022, 3:00am UTC](https://community.glideapps.com/t/can-i-split-text-using-space-delimiter/41819/11 "2022-05-11T03:00:08Z")
> [@Dilon\_Perera](#): > > (.+)\s((?!.)) Yup, it works, but it looks strange code for me at least 🙏 💐 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 12, 2022, 12:33am UTC](https://community.glideapps.com/t/can-i-split-text-using-space-delimiter/41819/12 "2022-05-12T00:33:52Z")
Ben Collins - the legend of the Google Sheets world, had a regular expression “day” in his 30-day course. > **[DAY 20: REGULAR EXPRESSION FORMULAS (REGEX)](https://courses.benlcollins.com/courses/222121/lectures/3630634)** > > Master 30 Advanced Google Sheet Formulas in 30 Days I would suggest you taking this course. It was life-changing for me. If that is not for you then probably this snippet of JavaScript will be easier to read, if you just need to take back the first name. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/3/9308e9e63908bf3b0a3c6a64207d57a509fa8627.png) Basically splitting the full name by the space character and taking the first item in the array (index 0). ---
**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\ **Post date:** [May 12, 2022, 4:05am UTC](https://community.glideapps.com/t/can-i-split-text-using-space-delimiter/41819/13 "2022-05-12T04:05:33Z")
Hola, this code looks readable for me at least 😀. I will see this course of course. If it is life changing for person like you then it would be for me. Thanking you for spreading and sharing your knowledge. ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [May 14, 2022, 10:37am UTC](https://community.glideapps.com/t/can-i-split-text-using-space-delimiter/41819/14 "2022-05-14T10:37:13Z")
A bit for me too! 😅 But getting there as far as I can! I’m new to this Regex World! Like to go deeper because I see some interesting things that can do! Didn’t added to my post that I found this code from this post! : > Good Luck! And Thanks Thinh for that Useful Information! ---
**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\ **Post date:** [May 14, 2022, 11:04am UTC](https://community.glideapps.com/t/can-i-split-text-using-space-delimiter/41819/15 "2022-05-14T11:04:23Z")
Thank you so much for taking from your valuable time to reply to me. 💐