Hi all i have a data set , with a column containing two different information.
one information contains alphanumeric characters which i need a new column and the other is purely textural without any numbers and that i also need in a separate column. I know i can use Regres but then how do i configure it to filter the column, the data set is attached below.
Thanks for helping
Solved! Go to Solution.
Thanks Mark.
It is not giving me the output. So when i use the filter tool it gives no output with this formula
Contains([Primary diagnosis], "<")
When i run the code on the formula tool it outputs a column with 0 zeros
So what i want to do is to provide two column one with the terms (m.4536C>T) and another without those values but description ( text or whatever is contained without the terms coded).
You could parse then apply an if function.
1.
2.
3.
4. Gives you...
'Complex I' is a letter I though (capital i) not a 1. You could use another if function to turn those into 1's not i's.