01-15-2018 05:59 PM - edited 01-15-2018 06:00 PM
01-15-2018 06:02 PM
1. Use CATX() to combine all into one character variable.
2. Use COUNTC() to count the characters of interest. You'll probably need to call this twice, once for Y and once for N.
In general, its better to store Y/N as 1/0 because then you can use SUM() or other basic math functions.
01-15-2018 06:12 PM - edited 01-15-2018 06:13 PM
I would have liked to code had you given the sample data HAVE and WANTas plain text. Screenshot,pdf or any attachments doesn't help at all.
01-15-2018 06:35 PM
@novinosrin I choose to tailor my answers based on the question. No data, then you get an approach solution because I'm not going to make assumptions and have someone come back and say it doesn't work or provide sample data in a different format than I guessed. It's mostly inefficient for me.
Also, if the data is an image, the code is an image these days. It's maybe a bit petty but I think users also learn more when they have to type it out rather than copy and paste and I do follow that myself, I force myself to type it out line by line.
@stancemcgraw Nothing in this post is related to you directly, more so on general behaviour on the community forums.
01-15-2018 07:05 PM
@Reeza true. I got that. Also, I must admit, i code here selfishly for my practice and continued learning. Honestly, not generous yet. Please don't think I am a bad person. lol. I treat this as my school indirectly benefiting OPs. Once I accomplish like you have in career and knowledge, I'd then become selfless. Ok, i am going out for a beer. Have a great evening!