How to get data from row

Hi @anmita

Check out the XAML file

Excel Regex.xaml (8.7 KB)

You can try with Regex expression

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=Organization Code\s\W)\S.*").Tostring

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=Address\W)\S.*").Tostring

image

Regards
Gokul