# How do I pull the first part of an email? **URL:** \ **Category:** Ask for Help\ **Created:** [January 14, 2021, 9:35am UTC](https://community.glideapps.com/t/how-do-i-pull-the-first-part-of-an-email/21157 "2021-01-14T09:35:52Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Pablo\_books](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablo_books/32/2110_2.png) [@Pablo\_books](https://community.glideapps.com/u/Pablo_books)\ **Post date:** [January 14, 2021, 9:35am UTC](https://community.glideapps.com/t/how-do-i-pull-the-first-part-of-an-email/21157/1 "2021-01-14T09:35:52Z")
Hey guys. I’d like for my user’s default Username to be their email without the `@domain.com` part. Is there some formula to do so? Or is it possible (somehow) with the split text column? ---
**Author:** ![Mariano\_Betta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mariano_betta/32/17895_2.png) [@Mariano\_Betta](https://community.glideapps.com/u/Mariano_Betta)\ **Post date:** [January 14, 2021, 10:10am UTC](https://community.glideapps.com/t/how-do-i-pull-the-first-part-of-an-email/21157/2 "2021-01-14T10:10:16Z")
Hello, does it have to be glide? Or can it be in google sheets? In glide I don’t know, in google sheet it can be done like this. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e628de700d2911d1fe94ad41d28def1b41336ea8.png) ---
**Author:** ![Mariano\_Betta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mariano_betta/32/17895_2.png) [@Mariano\_Betta](https://community.glideapps.com/u/Mariano_Betta)\ **Post date:** [January 14, 2021, 10:31am UTC](https://community.glideapps.com/t/how-do-i-pull-the-first-part-of-an-email/21157/3 "2021-01-14T10:31:26Z")
I was watching with split text. If you previously know the type of mail, eg. @ [gmail.com](http://gmail.com), @ [hotmail.com](http://hotmail.com), when doing split text and in the configuration you write that, it separates the text. But I don’t know how you can show it. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/7/57a76ac2178900daa61b0d0ac2004d16389973d5.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/d/2d21f0ebe15c61712fef3864a6f03ff0e8955d15.png) ---
**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:** [January 14, 2021, 10:34am UTC](https://community.glideapps.com/t/how-do-i-pull-the-first-part-of-an-email/21157/4 "2021-01-14T10:34:31Z")
If he has enough time then possibly a template column can help replacing all the @gmail.com, @hotmail.com etc. by a blank character. ---
**Author:** ![Mariano\_Betta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mariano_betta/32/17895_2.png) [@Mariano\_Betta](https://community.glideapps.com/u/Mariano_Betta)\ **Post date:** [January 14, 2021, 10:49am UTC](https://community.glideapps.com/t/how-do-i-pull-the-first-part-of-an-email/21157/5 "2021-01-14T10:49:58Z")
I’m not sure I understand. Suppose that you have already identified all the types of emails, I don’t see how to show the split text result. I tried template but couldn’t, surely there is a way. I can’t display split text with a template. ---
**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:** [January 14, 2021, 11:02am UTC](https://community.glideapps.com/t/how-do-i-pull-the-first-part-of-an-email/21157/6 "2021-01-14T11:02:13Z")
Split text can’t be shown in a text component because they’re an array. Template can theoretically replace all email handles with a blank character but the problem is to identify all of them handles. Still I think your original Sheet solution works best, it’s straightforward. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 14, 2021, 1:05pm UTC](https://community.glideapps.com/t/how-do-i-pull-the-first-part-of-an-email/21157/7 "2021-01-14T13:05:39Z")
This is another example where having some string manipulation methods in the math column would make this sort of thing trivial. ---
**Author:** ![Pablo\_books](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablo_books/32/2110_2.png) [@Pablo\_books](https://community.glideapps.com/u/Pablo_books)\ **Post date:** [January 14, 2021, 4:01pm UTC](https://community.glideapps.com/t/how-do-i-pull-the-first-part-of-an-email/21157/8 "2021-01-14T16:01:19Z")
Using the sheet formula solution. Thanks! ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 12, 2024, 1:50am UTC](https://community.glideapps.com/t/how-do-i-pull-the-first-part-of-an-email/21157/9 "2024-01-12T01:50:04Z")