Data table string validation


This is one data table, I need to extract only Master BOT and President Approval List_2022 from Column A.

How to do it.

Hi @sankar.mayilsamy

Try with this below

  1. Use Read range activity

  2. Use For each row in DataTable activity

Inside for each

  1. Use assign activity


Hi @sankar.mayilsamy ,

Could you let us in on some more detail as to why you would want to extract that specific data ?

Are you trying to fetch the 2nd row value ? Do you want to get the data after Excel Spreadsheet keywords ?

We would like to understand the logic behind the data extraction and suggest you the appropriate method.