Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello Rohit,
Try something like:
LOAD SUBFIELD(StringField, ',') AS Number FROM FILE.QVD;
Hope that helps
Hi
I attached sample application herewith please find it.
Regards
Ashish
Hello,
See attached example. Data table have strings values and the OnlyNumbers table have numbers extracted from string.
Cheers
Karol