Here’s a workflow that demonstrates one way to do this transformation.
It starts with this:
and ends with this:
If you have multiple ranges to parse, then you’d encapsulate this entire workflow in a Chunk or Window Loop to treat each row.
Here’s a workflow that demonstrates one way to do this transformation.
It starts with this:
and ends with this:
If you have multiple ranges to parse, then you’d encapsulate this entire workflow in a Chunk or Window Loop to treat each row.