Read specific line from a cell having multiple line data

Hello,
I would like to read a specific line within a specific cell of an excel.
sample

I would like top read “Country” from the above cell shown.
Thanks,
Aditi

@AditiGandhi,

Use Excel Read Cell Activity to read the cell value.
Hold the output with a string variable named as strOutput.

Then you can get the country with the following line of code

strOutput.Split(Environment.NewLine.ToCharArray)(3)
1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.