Forum Discussion

MattLegowski's avatar
MattLegowski
Qrew Trainee
7 years ago

I need to create a code that counts how many time a particular codes appears in a field

I have the below string of codes in one quickbase field: 80346,80329,80346,80371,80346,80335,80324,80346,80369,80332,80332,80356,80361,80361,80361,80361,80354,80358,80372,80329,80324,80367,80355,80...
Tables and fields
MattLegowski's avatar
MattLegowski
Qrew Trainee
7 years ago
Hi Dan, 

Thank you for you response. 
Unfortunately, I am not familiar with the Var Text Codes. 

I copy and pasted your code and it is throwing an error for me. 

Are you able to diagnose what is wrong with the code?



https://imgur.com/a/uvz3JLD 

It looks like the screenshot didn't upload that well, so a link to the image has also been added. 

Thanks,

_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
7 years ago
Now you have two double quotes at the start and end of the second line.