End Read Range on a string

Help Studio
, ,
1

I am trying to read a range in Excel and have it stop when the below string is in a row
CurrentRow.ItemArray.Contains(“Indicator: C Medicaid AC IP Discharges”)

This string above is always in Column A, but each week could be a different row.

The below use case does not error out and writes my datatable to Sheet 1. Trouble is, it writes the entire range, it does NOT “break” when it gets to the above string.

Anyone have any ideas why this would be happening?

The image shows a flowchart in an automation tool, detailing the steps to read a range from an Excel workbook, iterate through each row to search for a specific string, and then conditionally break or continue the loop before writing the data to another sheet in the workbook. (Captioned by AI)
The image shows a flowchart in an automation tool, detailing the steps to read a range from an Excel workbook, iterate through each row to search for a specific string, and then conditionally break or continue the loop before writing the data to another sheet in the workbook. (Captioned by AI)649×801 22.5 KB

2

Hi,

There might be extra whitespaces in the cell data.
For now, can you try the following expression?

CurrentRow.ItemArray.Any(Function(o) o.ToString().Trim()="Indicator: C Medicaid AC IP Discharges")

OR

CurrentRow.ItemArray.Any(Function(o) o.ToString().Contains("Indicator: C Medicaid AC IP Discharges"))

Regards,

3

Both of those lines produce full data and doesn’t break at “Indicator” (I just used that one word in the contains part).

It seems to completely ignore this line, where I want to stop reading the range. I’m gonna be doing another sequence that takes data after this line as well.

image