Forum Discussion
Condition in column
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.
1 Reply
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.
