Hi there, I’m looking to pull a string from a datatable and then search that same data table for a similar string with a different year in the name.
For example - IF “product name 2020” contains “2020”, then find “product name 2019”
I’m using a read range to populate the datatable, then I’m using a For Each Row to find which rows contain “2020”, at this point I’m storing the other data I’m interested in.
Within this first For Each Row I’m using a nested For Each Row, to search the datatable for names similar to the current row name. I then want to use an IF condition determine whether these values match, using regex to allow for the difference in year.
I’m struggling with the regex necessary to create the correct IF condition. Any help greatly appreciated