Fetch data after a certain line(where we find the data called "|Company Code")

[gaitonde25]

We have to fetch the data after the line no 10(suppose we found the data called "|Company Code" at record id 10). Currently we are doing manually for each file through sample tool. But we have to automate this. One main thing is record id (|Company Code) is different for each file. so how can we set the "N" value with the Record id where i find (|Company Code).

Adding the screenshot for better understand.

[seven · Accepted solution]

You can use a multi-row tool to mark the company code row and all following rows as good data. A filter tool will remove the data before this row. It is dynamic because it searches for the text you want. Please see attached.