Replace data to UpperCase in Excel

Help
1

Hello,

Question
Do you know the way to quickly change all data from DT to UpperCase?

I read an Excel Sheet1 and store in DT (I have data in different format sometimes lowercase, sometimes uppercase, sometimes mix)
I want to convert all data to Upper case and then write to Sheet2

Thank you
Gosia

2

Hi,
you can use for each row activity. And inside the activity use assign as below
row(“your column name”)=row(“your column name”).tostring.toUpper

3

Hi,
Convert datatable into String then apply string manipulation function str2.ToUpper()

4

Use Output Datatable activity to convert from DT to String.

5

Hi @poorna_nayak07

Make sense, however how to finally have again DT which I will need for further calculation?

6

convert to string using Output DT activity
then change to upper
convert string to DT by using split array with delimiters to DT again

1 Like
7

Use Generate datatable activity to convert from string to datatable

1 Like
8

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