Extracting a number

[Ghosh]

How to extract 19 from 2019456532?

I know of findstring, but that gives me the position of the digit.

Thank You for your help.

Shounak

[thllm]

HI Shounak,

Can you be more specific please with what you want. What are you trying to extract? Is it that you always want the 3rd and 4th digit of a string?

If that is the case one of the many ways you can do this is to use the Substring function.

[danilang · Accepted solution]

Hi the @Ghosh 

This Substring formula using FindString and Length as parameters will give you what you looking for

substring("2019456532",findstring("2019456532","19"),length("19"))

Dan

[Ghosh]

thank you for the solution. I managed to get it frm substring function, but the findstring function paired together works great too.