Separating data in a coulmn

[razzy]

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

[MarqueeCrew]

Did you want to filter these values?

Contains([description],"<")

That will find them.

Cheers,

Mark

[razzy]

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).

[MarqueeCrew]

For each row in your excel file can you create 2 columns with the desired results please?

[razzy]

Col 1 col 2 are the desired output

[DHB · Accepted solution]

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.

[ponraj · Accepted solution]

Here is the sample workflow for your case. Hope this is helpful. 

WorkflowResults