Hello, i would like to know how search and cut data from list with following rules:
The text must contains "AAA" and "/12", in column "Text" and the result should be the text in middle such as in following table such as in the column "Output"
If requires are not satisfied, it writes blank.
| Text | Output |
| RSTS AAA 123/12 PIIO | 123 |
| POUIY AAA 1234/12 UIYYI | 1234 |
| HGFHGF AAA 123/34 HTDDD | |
Thank you