Finding numeric strings

mtfisch7864 — Sat, 16 Nov 2024 17:41:30 GMT

I have a need to extract up to 4, 9-digit consecutive numbers from an unstructured text string in a load script. Here is an example,

JtR56743 tid lengths,,123456789 0846 987654321nnbfetgw,135796616

Result is:

123456789

987654321

135796616

Mike F

Re: Finding numeric strings

Vegar — Fri, 18 Dec 2020 06:00:41 GMT

Try this method

1. Replace all non digit symbols with an odd symbol like '|'.

2. Run the data through subfield() using only two parameters, like this

SubField(YourField, '|') as SubNumber

3. You now have generated a row per number in dour data, now you need to filter it. You can do that by loading a Resident load on your output table with a where condition.

Noconcatenate LOAD... RESIDENT... WHERE LEN (SubNumber) =9

4. You now have a table containing your 9 digit values.

Good luck!

topic Re: Finding numeric strings in QlikView

Finding numeric strings

Re: Finding numeric strings