Condition in column

[MintuBaruah]

Hi @all

I have the data in a column as per below: 

Period

3 years

12 months

0

22 months

Over 3 years

16 months

>2 years

16 Months

< 2 years

>7 years

Not applicable

From 15 January 2018 till date

10 months

2 years

134 months

>2 years

N/A - Struck off on 03.08.2018.

35 months

>7 years

>2 years

< 4 years

From 14 February 2008 till date

I have to find out the Period more than 3 years.

Is there a way to find this from the above data as the records are different from each other.

Please help resolve this issue.

[lbendlin]

Not unless you write your own parsing language.   You could have a process where you interpret all known variations, and then issue an alert when a new variation is enountered.