How to remove currency in Total Column

Help Activities
, ,
1

Hi i have an excel data, i want to remove currency in total column like – from 245866 USD to output should like 245866

This image displays a spreadsheet containing invoice details including invoice number, vendor tax ID, invoice item, total amount in USD, and date. (Captioned by AI)
This image displays a spreadsheet containing invoice details including invoice number, vendor tax ID, invoice item, total amount in USD, and date. (Captioned by AI)543×276 8.02 KB

invoiceData.xlsx (20.4 KB)

2

Hi @Anand_Designer

After reading data in Studio, you can use split function in the loop like below;

CurrentRow.Item(“Total”).ToString.Split({" "},StringSplitOptions.None).ToArray(0).ToString

image
image701×403 33.2 KB

Regards.

1 Like
3

@Anand_Designer,

You can use Read Range to read the excel file as Datatable and use this LINQ to remove the currency using this LINQ:

dtInvoices = dtInvoices.AsEnumerable().[Select](Function(row)
    row("Total") = System.Text.RegularExpressions.Regex.Replace(row("Total").ToString(), "[^\d.]", "")
    Return row
End Function).CopyToDataTable()

Invoke code argument should be like this.

This image depicts an invoked code activity in a software automation workflow, with its arguments configuration window showing an In/Out DataTable argument named "dtInvoices" assigned the value "dt1". (Captioned by AI)
This image depicts an invoked code activity in a software automation workflow, with its arguments configuration window showing an In/Out DataTable argument named "dtInvoices" assigned the value "dt1". (Captioned by AI)1271×699 38.2 KB

Before:

The image displays a data table titled "dt1" with columns for invoice number, vendor tax ID, invoice item, total amount, and date, listing multiple entries with various services and transactions. (Captioned by AI)
The image displays a data table titled "dt1" with columns for invoice number, vendor tax ID, invoice item, total amount, and date, listing multiple entries with various services and transactions. (Captioned by AI)749×860 31.7 KB

After:

The image shows a table of invoice data containing columns for Invoice Number, Vendor Tax ID, Invoice Item, Total, and Date. (Captioned by AI)
The image shows a table of invoice data containing columns for Invoice Number, Vendor Tax ID, Invoice Item, Total, and Date. (Captioned by AI)754×867 30 KB

1 Like
4

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