Excel replacing and looping

excel

#1

hello … i have an excel sheet with mobile names and price as shown in the below figure . here i want to replace ₹ and , up to 20 rows to compare with price > 10000 mobiles … How to remove ₹ and , for all the data in excel … i tried but replace is validating only for one variable with default value only can you please tell me this how to go through …here is my work flow and excel fileMobile.xlsx (10.8 KB)
practice_datafilter.xaml (15.1 KB)


#2

Hi,
To remove ₹ which i see the first character of price value.
You could use any below code:
Price.Remove(0,1);
Price.TrimStart(‘₹’);
Price.Substring(1);

To remove ,
Price.Replace(",","")

PS: please change datatype of Price from generic to string .