I am pretty new to…I guess what tools are available in each platform. I am somewhat comfortable writing very basic programs in c#, but I’ve also dabbled in other languages like Python, and have read up on others like R, and I think my familiarity with C# would lead to the same with Java as well (Just for an idea of my capabilities).

The task i’m inquiring about is technically completed and off my plate, but I’m still curious as to how i may have used technology to accomplish my task as opposed to just “brute forcing” it or doing it manually like a caveman.

I’ve got two big lists of information that i need to sort through for a job task. One contains the implemented data types, data lengths, and a string variable name that always starts with “str”. i.e. (“@JOB”, SqlDbType.VarChar, 32).Value = strJOB

The other list of information contains a longer string that essentially will contain the same information, just not necessarily in the same order or in the same position.

I will need to:
Match the “str” strings first. If these match then i would want to somehow compare the datatypes next (VarChar), and if these match i would finally need to compare the data length (i.e. 32 in the above example).

I know I can use excel, but the formulae to do something like this can be quite a bit more complicated than the basic “Concat, Trim, xlookup/vlookup” type of formulae that i’m already comfortable with, and I believe there may be tools in C# and other languages that would be much more intuitive for me, I just don’t know where to begin.

Maybe someone could direct me to a previous post for this question, I have tried searching Google and Stack, but I just can’t seem to find the right search terms to pinpoint helpful information. Not just looking for someone to solve it, but also want to educate myself.

I tried first using Text to Columns in Excel to separate the information and “whittle” it down so that the various bits were in different cells, but then i get lost because CoPilot was suggesting that i first count the length, and then do something with some “Aggregate” function that i have no clue about. It honestly just started looking like a RegEx expression in terms of complexity.