Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
if(isnum(ID),ID,null()) as ID,
if(isnum(ID),null(),ID) as Name
regards
Thanks for the quick suggestion.
The problem here is i get the data from my Backend system in 'Text' format
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
Both the solutions work, i actually converted the data into 'Num#' and then used the suggestion from Martin.
Thanks both!