Remove currency symbol values from column

[Chandra_Sekhar_K]

In excel automation there needs to be operations performed on multiple columns . But i need to remove the values in the columns that are extracted from webpage in terms of currency like £€$ etc
How to achieve this??

[rlgandu (Rajyalakshmi Gandu)]

@Chandra_Sekhar_K

Use For each excel row activity

row("ColumnName") = System.Text.RegularExpressions.Regex.Replace(row("ColumnName").ToString(), "[£€$]", "")

[sandyarpa767]

Hi @Chandra_Sekhar_K ,

U have the options in extract datatable where u can write only numbers .

[Chandra_Sekhar_K]

Can u explain in detail

[Chandra_Sekhar_K]

Not in excel i want do while extraction

[sandyarpa767]

Lets take this example of datatables.net website

use below options to achieve what u are looking for

Regards
Sandy

[Chandra_Sekhar_K]

Column settings will help to remove the text value and keep only numbers rt?

[sandyarpa767]

Yes thats right it can be appilied on any column of ur choice based on ur requirement ,

which will help to remove currency symbols in extracted table

this approach will help u not to modify in the excel rather u can have therequired data u are lookng for

[singh_sumit (Sumit Singh Tariyal)]

Hie @Chandra_Sekhar_K i"m attaching sample workflow hope it will reslove your query first store your input as datatable as an example → dt1 use for each row inside that assign a string variable and pass the regex pattern which check and replace that sign …
Cheers Happy Automation
your input as datatable

your output flow

here the regex pattern to check and remove the sign

if this reslove your query mark this as solution …

[Chandra_Sekhar_K]

I am trying to get modification of data while extraction not after extraction

[singh_sumit (Sumit Singh Tariyal)]

ok @Chandra_Sekhar_K while Using Table extraction after selecting salary filed do one thing change format
click on that icon

this screen will appear

change parse data as : format from text to Number so it will remove the dollar sign before writing it to the excel file
hope you understand
mark this solution if you find it was helpful
cheers Happy Automation