topic String problem in QlikView

String problem

Mon, 23 Aug 2010 08:36:24 GMT

Hi,

I have a string which contains 3 digit numbers separated by a comma:

here are the possible values of the string

213

221,225

548,457,598

Note: There can be any number of 3 digit numbers in the above mentioned String.

I want to each of these 3-digit numbers.

Please advice.

Regards,

Rohit

Miguel_Angel_Baeyens — Mon, 23 Aug 2010 08:51:39 GMT

Hello Rohit,

Try something like:

LOAD SUBFIELD(StringField, ',') AS Number FROM FILE.QVD;

Hope that helps

Mon, 23 Aug 2010 08:52:47 GMT

I attached sample application herewith please find it.

Regards

Ashish

Mon, 23 Aug 2010 09:11:30 GMT

Hello,

See attached example. Data table have strings values and the OnlyNumbers table have numbers extracted from string.

Cheers

Karol