Skip to main content
Solved

How to find a cell containing a partial text match in a data table?

  • July 25, 2025
  • 1 reply
  • 34 views
L
Navigator | Tier 3
Forum|alt.badge.img+6

Hello, I'm trying to find the index (row and column) of a cell within a data table that contains a specific text pattern. For example, I need to find all cells that contain the value "Redirection =>" rather than an exact match of the entire cell. The search action I've tried only works for exact values, not for partial matches. How can I achieve this?

Best answer by Aaron.Gleason

​@LAHCEN AGLAGAL You will need to loop through the table using numeric indices to keep track of the row and column of the matching value. Use an IF, string condition, if $yourvariable$ Includes "matching string". The Includes operator checks if the source string contains the string you're looking for. 

1 reply

Aaron.Gleason
Automation Anywhere Team
Forum|alt.badge.img+14
  • Aaron.Gleason
  • Automation Anywhere Team
  • Answer
  • July 25, 2025

​@LAHCEN AGLAGAL You will need to loop through the table using numeric indices to keep track of the row and column of the matching value. Use an IF, string condition, if $yourvariable$ Includes "matching string". The Includes operator checks if the source string contains the string you're looking for. 

Shreya.Kumar
L
abhay_naik
Terms & ConditionsCookie settingsAccessibility statement