Help with data table issue

Help Activities
, , ,
1

Hi everyone, I have a data table containing prices, that also have the currency symbol. Can someone help me remove it?

Thanks in Advance.
Regards,
Divya Kulkarni.

2

Hi @Divya_Kulkarni

Where is the symbol? before the price or after it.
Can you please give me a screenshot of the column price?

3

Hi,
The symbol is before the price. Sure, I have attached the screenshot.query

4

Add Read Range Activity and save the data in variable ExcelDT for example
Add For Each Row activity
Add Assign acitivty in it:
row(“Product_Price”) = row(“Product_Price”).ToString.Replace(“$”,“”)
Instead of $ set your currency

See the attached file
Sequence25.xaml (6.1 KB)

Best regards
Mahmoud

1 Like
5

Hi @Divya_Kulkarni ,

You can also use Linq.
The query will change it’s format instead of replacing symbol.

(From r In dt Select dtOutput.LoadDataRow(New Object() { r.Field(of Object)(“Product_Name”), CInt(r.Field(of Object)(“Product_Price”)).ToString(“N2”) },False)).CopyToDataTable

I have attached output of this query
Check out the result.
ReplaceCurrecySymbol.xlsx (9.7 KB)
ReplaceCurrecySymbol.xaml (5.9 KB)

1 Like
6

Thanks a lot. It works.

7

Thank you @ermanoj3101 .

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.