# Parsing/Cleaning up imported Gmail emails **URL:** \ **Category:** Ask the Community\ **Created:** [July 30, 2021, 8:47pm UTC](https://connect.superhuman.com/t/parsing-cleaning-up-imported-gmail-emails/24834 "2021-07-30T20:47:54Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![agoodman](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/agoodman/32/19164_2.png) [@agoodman](https://connect.superhuman.com/u/agoodman)\ **Post date:** [July 30, 2021, 8:47pm UTC](https://connect.superhuman.com/t/parsing-cleaning-up-imported-gmail-emails/24834/1 "2021-07-30T20:47:54Z")
I got emails being pulled into my table via the Gmail Pack. Do you have any pointers in how to clean up the text? The info I have has 8 reliable fields in the original data. Right now it’s being imported into the cell as one big blob. Since I have 8 consistent fields, perhaps I can break the content up into columns based upon that? ---
**Author:** ![Scott\_Collier-Weir](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/scott_collier-weir/32/29677_2.png) [@Scott\_Collier-Weir](https://connect.superhuman.com/u/Scott_Collier-Weir)\ **Post date:** [July 31, 2021, 1:33am UTC](https://connect.superhuman.com/t/parsing-cleaning-up-imported-gmail-emails/24834/2 "2021-07-31T01:33:40Z")
Hey there! It’s a little difficult to respond to questions like this without more context, screenshots, or an example doc. There are SO many possibilities with Coda so it’s hard to specify how to help with the little amount of context. Shoot some more information in this thread and I’d be happy to help! ---
**Author:** ![agoodman](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/agoodman/32/19164_2.png) [@agoodman](https://connect.superhuman.com/u/agoodman)\ **Post date:** [July 31, 2021, 2:05pm UTC](https://connect.superhuman.com/t/parsing-cleaning-up-imported-gmail-emails/24834/3 "2021-07-31T14:05:43Z")
I can’t get a screenshot right now but what the data looks like in the original is like: Name: Sarah Age: 32 Email: [hi@ok.com](mailto:hi@ok.com) What I get with the Gmail Pack: [Name:SarahAge:32Email:hi@ok.com](mailto:Name:SarahAge:32Email:hi@ok.com) If the person has a two word name, it’ll honor the space there: Name:Sarah [AnnAge:32Email:hi@ok.com](mailto:AnnAge:32Email:hi@ok.com) ---
**Author:** ![Scott\_Collier-Weir](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/scott_collier-weir/32/29677_2.png) [@Scott\_Collier-Weir](https://connect.superhuman.com/u/Scott_Collier-Weir)\ **Post date:** [August 1, 2021, 6:03am UTC](https://connect.superhuman.com/t/parsing-cleaning-up-imported-gmail-emails/24834/4 "2021-08-01T06:03:51Z")
Here you go! Its kind of silly, and there might be a more elegant way to do it with just regexextract() but its working nonetheless! https://coda.io/embed/oZvD9gWX97/_supnz?viewMode=embedplay