I using query to get value from excel and this query is working fine. When it has data like “$2345.44”, but this query get failed when there is no data like “0”. and not having currency symbol with.
Its always better to split the query into steps so that we can validate whether it meets a a given criteria before proceeding to operate on the data that is supposed to be present.
I’ve developed a short workflow, could you give it a try?
I have tried your code and it is working on total payment . Same I need " Total Amount Owed" and “Balance Remaining” value. So I did replace “Total Payment” with “Total Amount Owed” but it got failed.
Could you please help me to understand it get failed when replace only some other value.
Please see reference:-
I need your help.
Actually When I trying to fetch data from balance remaining it will return date value like 3 it is return.
Infact I did add current date format so that it should contain like a row but it is not reading value against balance remaining
dt_sampleData.AsEnumerable().ToList().FindIndex(Function(i) i.ItemArray.Select(Function(s) s.ToString.ToLower.Trim).Contains(“balance remaining as of”+System.DateTime.Now.ToString(“MM/dd/yyyy”)+“:”))