In my attribute table I have a column named 'BYGN_STAT' which includes information about building status (RA, IG, FA etc.) and dates (YYYYMMDD).
I would like to split this column, and separate building status 'IG' with the following dates. The length of the dates varies from one date to many.
I need to find 'IG' and the following dates before the next to letters. In this case this is 'FA', but it could also be another combination of two letters.
In the figure below I would like to find and copy the values in the red rectangle to a new column. Is this possible?