Hw can i remove alphabets ‘Rs’ from ‘Rs.89,600.0’… i need to keep only numbers in the column of my excel file
Check as below
For writing back to excel, check as below for your reference
Hope this helps you
Thanks
Use Read Range to Read Data and then Use For Each row
In that use assign Activity
row(“Due Date”)=row(“Due Date”).Tostring.Substring(3)
After For Each use Write Range
use this System.Text.RegularExpressions.Regex.Match(inputString, “\d+”)
it’s working
thank u
row(“Due Amount”).ToString.Substring(3,row(“Due Amount”).ToString.Length-3)
could u plz elaborate this
Regarding Substring, you can visit below link
check the post which resolves your query and mark that post as solution
Thanks
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.