Help

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
Jump to Solution
444 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

If you have periods, then use this formula:

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

See Solution in Thread

3 Replies 3

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:

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?

Screen Shot 2020-09-01 at 5.53.35 pm

If you have periods, then use this formula:

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