Forum Discussion
Quick_BaseJunki
6 years agoQrew Captain
Hi Matt,
The Count function does not work the way you think it does. It's taking each of your items [LCMS CPT Codes],1, & "80332" and counting them... so there are 3.
And while this explains why you're getting the response you got, it does not help you achieve your goal.
What you are trying to do is not a simple task (although it ought to be). Is your string of text always the same length? Essentially what you'll have to do is parse out each 5 digit code (using Part and the comma delimiter) and compare it against your particular code and 'sum' the times it matches.
-Sharon
The Count function does not work the way you think it does. It's taking each of your items [LCMS CPT Codes],1, & "80332" and counting them... so there are 3.
And while this explains why you're getting the response you got, it does not help you achieve your goal.
What you are trying to do is not a simple task (although it ought to be). Is your string of text always the same length? Essentially what you'll have to do is parse out each 5 digit code (using Part and the comma delimiter) and compare it against your particular code and 'sum' the times it matches.
-Sharon