Separate Numbers from text

Mon, 02 Mar 2015 18:12:45 GMT

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

Re: Separate Numbers from text

hic — Mon, 02 Mar 2015 18:21:41 GMT

For example

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

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

HIC

Re: Separate Numbers from text

Wed, 04 Mar 2015 15:52:35 GMT

Thank you.

topic Separate Numbers from text in QlikView

Separate Numbers from text

Re: Separate Numbers from text

Re: Separate Numbers from text