Extract Number from a String

[lac]

Hello, 

Can someone please help? I'm trying to extract numbers from a field that are followed by the letters CY.

so in this example i only want to extract the numbers 2020 from the string below. This number will change but will always be followed by CY or cy

U9898 Happy go lucky until 2020CY or until today 321

[Luke_C · Accepted solution]

Hi @lac 

Here's 2 ways, one regex, one text parsing:

Regex:  .*(\d{4})CY.*

Formula: tonumber(substring([Field1],findstring(UPPERCASE([Field1]),'CY')-4,4))

[binuacs · Accepted solution]

@lac 

[lac · Accepted solution]

Thank you this was super helpful