Can anyone tell me how can i extract the data which is highlighted in red, also the debit amount

[Lakshya_Sharma]

[Palaniyappan (Palaniyappan P)]

Hi

Welcome to UiPath forum

1. Use a excel application scope and pass the filepath of excel as input and use read range and get the output as datatable named dt

2. Now use a FOR EACH ROW activity and pass dt as input

3. Inside the loop use a assign activity to get the string value you want and the debit column value with another assign activity like this

I could see a common string along with your value
Replace them with null value so that you get your exact value

str_output_1 = row(2).ToString.Replace(“your common text”, “”)

For debit use another assign inside the for each row loop

str_output_2 = row(“Debit”).ToString

Cheers @Lakshya_Sharma