Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

# Extract four digit number from cell (i.e. year from citekey)

Topic Labels: Formulas
Solved
444 3
cancel
Showing results for
Did you mean:
4 - Data Explorer

Hi, for my academic research database I’m trying to write a formula that will automatically extract a four-digit number from a cell (i.e. extracting year from a citekey).

For example (Citekey --> Year),
Downs1965NonmarketDecisionMaking --> 1965
Welborn1968BureaucracyAnthonyDowns --> 1968

Any ideas on how I might be able to do this? Thanks.

1 Solution

Accepted Solutions
18 - Pluto

If you have periods, then use this formula:

`VALUE(SUBSTITUTE(Citekey,".",""))`

3 Replies 3
18 - Pluto

Welcome to the community, @M_W!

If those are the ONLY numeric digits within your entire text string, then you could do it with this formula:

`VALUE(Citekey)`

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

4 - Data Explorer

Thanks Scott!

It works perfectly well except for cells with a period (see screenshot below). Is there a way to make the value() formula work?

18 - Pluto

If you have periods, then use this formula:

`VALUE(SUBSTITUTE(Citekey,".",""))`