I have the detail as below and would like to extract section detail from the below:
Sample 1 )U Location XX Sub Sub Section Name CTS1 NEW Date 25 SEP 2021
Sample 2 )EVJeee Section NUDI Price Reference
Sample 3 )Activity Section JU81 Price Reference
Sample 4 )Section Name JEG9 Price Reference
Result Wanted (activity)
Sample 1 ) CTS1
Sample 2 ) NUDI
Sample 3 ) JU81
Sample 4 ) JEG9
May i know how to extract this kind of format detail if we have four scenarios?
Many thanks in advance.
Acitivty.txt (425 Bytes)