How to remove string

Hw can i remove alphabets ‘Rs’ from ‘Rs.89,600.0’… i need to keep only numbers in the column of my excel file

@Chetan_N

Check as below

For writing back to excel, check as below for your reference

Hope this helps you

Thanks


how can i do this for whole column of ‘Due amount’

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+”)

@Chetan_N

Check below workflow

BlankProcess9.zip (13.2 KB)

Mark as solution if this helps you

Thanks

it’s working
thank u

row(“Due Amount”).ToString.Substring(3,row(“Due Amount”).ToString.Length-3)
could u plz elaborate this

@Chetan_N

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.