It's been a long time since I've done any coding, and I feel like an idiot for having to ask this and not being able to just figure it out but I'm being kind of lazy and I promised work that I'd have this report run for them. Is there a simple way to ignore case in a string, or is there a simple way to convert a string to all lowercase? The method I've thought of is splitting the string into a variant, going through the variant and figuring out of the ASCII code for each letter was cap or lowercase, making it all lowercase, and then re-assembling the string but this will add significant time to the time it will take me to run this report as I'm comparing a list of about 300 names to a list of about 6000 names and would need to do this for each one in addition to some other code that ultimately writes several values for each name on a spreadsheet.
Any help would be appreciated
Reply With Quote