Separating data in a coulmn

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

data23.xlsx

Datasets

Accepted answers

DHB

You could parse then apply an if function.

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

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

Workflow Results Results

Separating data in a coulmn.yxmd

All comments

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

ponraj

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

Workflow Results Results

Separating data in a coulmn.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280