To change uppercase in datatable

Help
1

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

change entite datatable to uppercase like ABC DEF QTY

1 Like
2

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

1 Like
3

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
    }
}
2 Likes
4

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:

5 Likes
5

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
6

Resolved my issues. thank you