Filter DataTable issue to write in text file

[Anand_Designer (Anand_RPA)]

hi,
i have excel file and columns like–> Model,Color, price
if price is >500 i want to write in text file.
i tried but it showing error …
can anybody help…
…Pendrive.xlsx (11.4 KB)

[Pradeep_Shiv]

Hi @Anand_Designer,

What do you want to write in text file?
What’s the error you are facing?

Cheers
@Anand_Designer

[Anand_Designer (Anand_RPA)]

i want to write data where price >500 write to text file all columns.
i used read range > for each row > for each >if> write text file
i am getting error like below

[Pradeep_Shiv]

Okay Do this,

Use For each row, If Cint(row(“Price”).ToString.Split("₹"C)(1))>500 then write to text file.

Dont use For each

Cheers

[stefano_negro]

Also note that you are using a for each on item as DataRow but your if you are using row

You have to change your condition in the following
Double.Parse(item.Item(2).ToStiring)>500

[Anand_Designer (Anand_RPA)]

@Pradeep_Shiv
i followed your code, but it shows error in append line

[stefano_negro]

You have to write a variable of type string inside the Input field in Append Line.
So for example change row to row(“Price”).ToString in order to write the price into the file

[Anand_Designer (Anand_RPA)]

Thanks for given solution @Pradeep_Shiv @stefano_negro,

[Pradeep_Shiv]

Good
Happy learning!
@Anand_Designer