Separate Numbers from text

[#1]

Hi all,

I have received the data in such a way that two fields are joined together. One of them is numeric and the other is text. I need to split them into individual rows. Is there a function or regex available to achieve this in qlikview?

The field looks like the below:

column 1

999Text

01Supplies

3Gifts

I need to separate the numbers from text as shown below. Please note the numbers always precede the text, so we need not worry about a number appearing in the text. They are also NOT fixed lengths. Any help will be appreciated.

column 1      column 2

999               Text

01                 Supplies

3                   Gifts

Thanks,

Praveen         

[hic · Accepted solution]

For example

Left(column,Len(Keepchar(column,'0123456789'))) as Num,

Mid(column,1+Len(Keepchar(column,'0123456789'))) as Text,

HIC

[#3]

Thank you.