rodrigobertollo
New Member
- Joined
- May 27, 2021
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Hi guys,
Recently I've seen a workaround in this forum that made me think if this is also possible.
I have a file with expected gene coverage and I have genetic exams with a string of genes.
I have to check if the each gene is covered in each exam. However, for each search I need to transform the string of genes to a lis of itens. I want to transfer this task and reduce the complexity with a search similar of the image above:
Can this example be doable?
By the way, I also suffer with the partial match, since some genes names overlap (like NF2 and F2), I also need the search to be full match, my workaround for full match was to add spacial characters before and after the gene name so it would be unic.
Solving this also reduce the complexity of the task.
Thank you
Rodrigo
Recently I've seen a workaround in this forum that made me think if this is also possible.
I have a file with expected gene coverage and I have genetic exams with a string of genes.
I have to check if the each gene is covered in each exam. However, for each search I need to transform the string of genes to a lis of itens. I want to transfer this task and reduce the complexity with a search similar of the image above:
Can this example be doable?
By the way, I also suffer with the partial match, since some genes names overlap (like NF2 and F2), I also need the search to be full match, my workaround for full match was to add spacial characters before and after the gene name so it would be unic.
Solving this also reduce the complexity of the task.
Thank you
Rodrigo