Online Upper Case Converter

(Coding rookie posting first ever question so please pardon my mistakes)

I'm trying to learn simple methods of data validation. I read another post similar to what I'm doing: convert-entire-range-to-uppercase, but it doesn't work when I change the range to fit my needs. Couldn't find anything else that addressed this.

I have an Excel column named "Block" that appears in different locations in different workbooks, and I need to capitalize any letters that occur in that column. I think the code works as intended until the final line, which results in "#NAME?" filling the whole range.

This is what I have so far:

Dim LastColumn As LongDim LastRow As LongDim BlockColumn As LongDim BlockRange As Range    'defines LastColumn, LastRow & BlockColumn    LastColumn = Cells.Find(What:="*", After:=Range("a1"), LookAt:=xlPart, LookIn:=xlFormulas, _        SearchOrder:=xlByColumns, SearchDirection:=xlPrevious, MatchCase:=False).Column    LastRow = Cells.Find(What:="*", After:=Range("a1"), LookAt:=xlPart, LookIn:=xlFormulas, _        SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=False).Row    BlockColumn = Cells.Find(What:="Block", After:=Range("a1"), LookAt:=xlPart, LookIn:=xlFormulas, _        SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=False).Column    'capitalizes any text in BlockColumn    Set BlockRange = Range(Cells(2, BlockColumn), Cells(LastRow, BlockColumn))    BlockRange = [UPPER(BlockRange)]

Aside from wondering where I made a mistake, I'm sure I've over-complicated this. Could someone show me a way to rethink or simplify it? I was also wondering the general pros and cons to accomplishing a task like this via looping (as opposed to this method), but not sure if this is the place to ask that...

I have the following code i use to aggregate and get sums.Problem i have is the source data that populates the Account# column sometimes is upper and sometimes lower case.

I need the aggregate/sum regardless of case.

I have tried case insensitive but I dont seem to have got that to work.

I am thinking maybe I need to clone the account# column and make it uppercase then use the clone, but i am unsure how to make the column all uppercase.

please tell me how i make this code aggregate/sum regardless of case.

thanks

var accountGroups = completeDT_svc_RO_dr.AsEnumerable()    .GroupBy(x => new {         AccNo = x.Field<String>("Account#"),         Description = x.Field<string>("D e s c r i p t i o n . . . . . . . . . . . . x")                      .ToString()     })    .Select(grp => new {         Account = grp.Key.AccNo,         descrpt = grp.Key.Description,         Count = grp.Sum(row => row.Field<int>("Cur-Balance...."))     });var completeDT_svc_RO_dr_cr = new DataTable();completeDT_svc_RO_dr_cr.Columns.Add("D e s c r i p t i o n . . . . . . . . . . . .");completeDT_svc_RO_dr_cr.Columns.Add("Account#");completeDT_svc_RO_dr_cr.Columns.Add("Cur-Balance....");foreach (var grp in accountGroups)    completeDT_svc_RO_dr_cr.Rows.Add(grp.descrpt, grp.Account, grp.Count);

On Windows with Visual Studio 2017 I can use the following code to uppercase a u32string (wich is based on char32_t):

#include <locale>#include <iostream>#include <string>void toUpper(std::u32string& u32str, std::string localeStr){    std::locale locale(localeStr);    for (unsigned i = 0; i<u32str.size(); ++i)        u32str[i] = std::toupper(u32str[i], locale);}

The same thing is not working with macOS and XCode.I'm getting such errors:

/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/../include/c++/v1/__locale:795:44: error: implicit instantiation of undefined template 'std::__1::ctype<char32_t>'return use_facet<ctype<_CharT> >(__loc).toupper(__c);

Is there a portable way of doing this?

In my Android application I have different EditText where the user can enter information. But I need to force user to write in uppercase letters.Do you know a function to do that?

I am attempting to create a word filter to block any words listed in a textfile from being broadcast in chat.

The initial code works fantastically but ONLY if the words being said in chat are IDENTICAL to words in the textfile.

I need a way for it to block the word regardless if it's in all uppercase, all lowercase or anything in between but it must match the word in the list exactly.

e.g, it will not filter "ship, SHIP or ShIp" but it will filter.. "Sh**, SH**" you get the idea. I am open to other methods that don't include making a huge textfile list.

      foreach (var word in File.ReadAllLines("wordlist.txt"))            {                if (message.Contains(word))                 player.SendToSelf(Channel.Reliable, ClPacket.GameMessage, "You Cannot Say That Here!");            }            return true;}

I have tried

if (char.IsUpper(message[0]))             player.SendToSelf(Channel.Reliable, ClPacket.GameMessage, "You Cannot Say That Here!");

Something like CurrentCulture/InvariantCultureIgnoreCase/OrdinalIgnoreCase could be used, but I'm not sure how to implement such things.

Would also be extremely beneficial to block words in foreign (other than En) language using foreign characters.