Split Text and Numerical Data

[Sai33]

Hi All,

I have the following data in my ID column 

034781

097453

MUCGA

LIPZL

MELPOA

378431

BRVPOD

From this i want to seperate all the 'Text' values into one field and the numericals into one.

Name:

MUCGA
LIPZL

MELPOA

BRVPOD

ID:

034781

097453

378431

Thanks.

[martinpohl · Accepted solution]

if(isnum(ID),ID,null()) as ID,

if(isnum(ID),null(),ID) as Name

regards

[Sai33]

Thanks for the quick suggestion.

The problem here is i get the data from my Backend system in 'Text' format

[Quy_Nguyen]

If the data is text, try this:

If(Len(PurgeChar(Text,'0123456789')) > 0, Text, Null()) as Name,
If(Len(PurgeChar(Text,'0123456789')) = 0, Text, Null()) as ID

[Sai33]

Both the solutions work, i actually converted the data into 'Num#' and then used the suggestion from Martin.

Thanks both!