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
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
Convert datatable into String then apply string manipulation function str2.ToUpper()
Use Output Datatable activity to convert from DT to String.
Make sense, however how to finally have again DT which I will need for further calculation?
convert to string using Output DT activity
then change to upper
convert string to DT by using split array with delimiters to DT again
Use Generate datatable activity to convert from string to datatable
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.