To change uppercase in datatable

To change entire lowercase in Datatable to uppercase.please help me solve itCapture

change entite datatable to uppercase like ABC DEF QTY

Hi @brindhaS,
As you are building the data table, convert each value to upper before writing them in the data table.
Here is the code u need to use :
assuming var as a variable
var = var.ToUpper

If you already have the datatable you can do:

For Each row in dt
{
    For each Column in Dt.Columns
    {
        row.item(item.tostring).tostring.toUpper
    }
}
1 Like

Hi @brindhaS

I have done a sample for you. I did a read range to get data to a datatable. Then I have included a For Each Row activity to loop through the datatable and convert its values to upper case.

Check out the attached xaml file.

DataTableToUpper.xaml (7.5 KB)

Let know if this works for you…

If it works, please mark the answer as the solution as it will help others as well :slight_smile:

2 Likes

Thanks for help, here is complete command

For Each row in dt
{
    For each column in Dt.Columns
    {
        row.Item(column.ToString) = row.Item(column.ToString).ToString.ToLower
    }
}
2 Likes