Data table string validation

Help Studio
, ,
1

Hi,

image
image1156×493 24.2 KB

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

How to do it.

2

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
System.Text.RegularExpressions.Regex.Match(Currectrow(0).Tostring,"(?<=spreadsheet\n)(\S.+)").Tostring

image
image1083×376 32.4 KB

Regards
Gokul

3

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.