String problem

[#1]

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]

Hello Rohit,

Try something like:

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

Hope that helps

[#3]

Hi

I attached sample application herewith please find it.

Regards

Ashish

[#4]

Hello,

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

Cheers

Karol