Dynamicly select the start row based on a name

[racoon]

Hi,

I have an excel file where the start row keeps changing. The only constant is one of the column Names. Is there a way I can use the column name to identify the first row to import from?

Thanks

[CharlieS · Accepted solution]

Do you mean to use a value within the constantly-named field to identify the starting position? If so, use a RecordID field on the file. A Filter tool can filter where <Constant Field> = <Starting Value> and that will give the starting RecordID value. Append that Starting ID value and use that to filter the data.

I have attached an example solution. Let me know if you have any questions.

[racoon]

Thanks Charlie, this is exactly what I was looking for.

[Deliverance]

Thanks for the example, this was exactly what I needed. I was trying to figure out some RegEx method which I have no experience with.