# Extract part of entity name

**URL:** https://community.fibery.io/t/extract-part-of-entity-name/4248
**Category:** Get Help
**Created:** [April 4, 2023, 5:39pm UTC](https://community.fibery.io/t/extract-part-of-entity-name/4248 "2023-04-04T17:39:43Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Marloes](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/marloes/32/5926_2.png) [@Marloes](https://community.fibery.io/u/Marloes)
#### Post date: [April 4, 2023, 5:39pm UTC](https://community.fibery.io/t/extract-part-of-entity-name/4248/1 "2023-04-04T17:39:43Z")

</div>

Hi,

I want to extract a part of an entity name to create a new entity in another database. I know the left / right function in the formula, but this won’t match the criteria.

**For example**  
The first entity is called _12. December '24_.  
I only want to extract everything after the dot. So I need the trim function (for removing the blank space), as well as something to extract only the last part → _December '24_.

When I use the _right function_ I have to set the number of characters I want to extract. But consider the fact that every month have a different number of characters, I don’t know how to make it work.

Is there something like _extract everything after x-number of characters_? Or is there a different solution?

Thanks!

---

<div class="post-metadata">

### Author: ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)
#### Post date: [April 4, 2023, 6:44pm UTC](https://community.fibery.io/t/extract-part-of-entity-name/4248/2 "2023-04-04T18:44:21Z")

</div>

There is the Middle function, which extracts a section, based on a start and end position, and you could set the end position to something ridiculously high, e.g.

`Middle(Name,Find(Name,".") + 2,1000)`

Alternatively, you could use something like this:

`Right(Name,(Length(Name) - Find(Name,".")) - 1)`

which just seems more elegant to me 😉

---

<div class="post-metadata">

### Author: ![Marloes](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/marloes/32/5926_2.png) [@Marloes](https://community.fibery.io/u/Marloes)
#### Post date: [April 4, 2023, 7:04pm UTC](https://community.fibery.io/t/extract-part-of-entity-name/4248/3 "2023-04-04T19:04:33Z")

</div>

Briljant!

Used the last one. Just because you think it’s more elegant. 😁
