K_Barnett
05-02-2018, 12:25 PM
Hello all,
22155
My main objective here is to make sure that Columns A and B agree with the "Rev" level here. I have about 11k rows to sift through. I am wondering how to search for this specific text (REV) in column A and assign the correct letter to a variable.
For example if we take the first row in the picture I would search "Rev" (this part is easy for me) and see that for this row, it does contain that word. Then (and this is the hard part for me) I would need to assign the letter(s) following "REV" to a variable to compare it to the value found in the corresponding row in column B. Can you assign specific text within a cell to a String? I know a fair bit so I don't need help with the searching, just how i would assign specific text within a cell to a variable for comparison purposes. Thanks for any help.
22155
My main objective here is to make sure that Columns A and B agree with the "Rev" level here. I have about 11k rows to sift through. I am wondering how to search for this specific text (REV) in column A and assign the correct letter to a variable.
For example if we take the first row in the picture I would search "Rev" (this part is easy for me) and see that for this row, it does contain that word. Then (and this is the hard part for me) I would need to assign the letter(s) following "REV" to a variable to compare it to the value found in the corresponding row in column B. Can you assign specific text within a cell to a String? I know a fair bit so I don't need help with the searching, just how i would assign specific text within a cell to a variable for comparison purposes. Thanks for any help.