My unstructured data set looks like below
currency - AUD
period date rate period date rate
TDY 01SEP22 1.1 TOM 02SEP22 1.1
currency - USD
period date rate period date rate
TDY 01SEP22 1.1 TDY 02SEP22 1.1
end of report
currency - AUD
period date rate period date rate
TDY 02SEP22 1.1 TDY 03SEP22 1.1
currency - USD
period date rate period date rate
TDY 02SEP22 1.1 TDY 03SEP22 1.1
end of report
Continuing for 1 month
I need to capture only the rates under the USD values continuing for a month in a loop.
Ask any questions.
Update to question