I'm looking to do syntax highlighting within a string. Here is what I would like to see:
2000000001BRRYXYZQGUTZMST1122334 xxy 12 Frank
2000000002BRRYXYZQARNLDTM1020304 xrq 03 Jane
2000000003BRRYXYZQROBRTJN0102O30 xdr 02 Sam
2000000004BRRYXYZQBOBRTJN0102030 wer 11 Ducky
I'm looking to highlight the seven letters that start before the last set of 7 digits only if they match a pre determined set of stings. So in the above strings I would like to highlight GUTZMST, ARNLDTM, and ROBRTJN but not highlight BOBRTJN as it is incorrect.
Second feature if possible would be to highlight errors in the coding. The last seven characters are always digits and the 7 before them are always characters. See the O in the third line that should be a zero? Since it is not a digit, I would like it highlighted to spot the error quickly.
The first 18 rows are always the same except the index number in columns 2-10. BRRYSYZQ is always the same and in the same columns. GUTZMST is the predefined text and the 7 digits after that are a random set of numbers followed by a space then a bunch of other meaningless information for this topic.
I tried taking HTML tags and adding my predefined text but I don't have a good starting and ending delimiter. Could use BRRYSYZQ but how do I check the next 7 characters only? How can I also check for stray letters in the last 7 digit field?
Thanks,
2000000001BRRYXYZQGUTZMST1122334 xxy 12 Frank
2000000002BRRYXYZQARNLDTM1020304 xrq 03 Jane
2000000003BRRYXYZQROBRTJN0102O30 xdr 02 Sam
2000000004BRRYXYZQBOBRTJN0102030 wer 11 Ducky
I'm looking to highlight the seven letters that start before the last set of 7 digits only if they match a pre determined set of stings. So in the above strings I would like to highlight GUTZMST, ARNLDTM, and ROBRTJN but not highlight BOBRTJN as it is incorrect.
Second feature if possible would be to highlight errors in the coding. The last seven characters are always digits and the 7 before them are always characters. See the O in the third line that should be a zero? Since it is not a digit, I would like it highlighted to spot the error quickly.
The first 18 rows are always the same except the index number in columns 2-10. BRRYSYZQ is always the same and in the same columns. GUTZMST is the predefined text and the 7 digits after that are a random set of numbers followed by a space then a bunch of other meaningless information for this topic.
I tried taking HTML tags and adding my predefined text but I don't have a good starting and ending delimiter. Could use BRRYSYZQ but how do I check the next 7 characters only? How can I also check for stray letters in the last 7 digit field?
Thanks,