Edited.
Real data attached as YXZP.
Reference image below.
I want to find each occurrence (row) that starts with the class below.
<div class="tcDtlSegFrame"...
As seen below, there are 6 occurrences. I want to assign a number 1-6 to each respective occurrence and the corresponding number for all the rows between.
Solved! Go to Solution.
It is hard to provide a suggestion without the dataset.
Added zip containing extracted h t m l and image of h t m l structure. Note Frame = tcDtlSegFrame and so on.
I already isolated the relevant text by cutting everything above and below using a few Multi Row tools.
It is not elegant, but it works.
if startswith([Text],'<div class="tcDtlSegFrame"') then 1 else null() endif
if isnull([Tag]) then [Row-1:Tag] else [Tag] endif