topic Set of numbers between two - in QlikView

Set of numbers between two -

dinicholls — Sat, 16 Nov 2024 00:35:53 GMT

Hi All,

I have a field that varies each side of two '-'s, example:

ABC-12345678-XYZ

ABC1-12345678-ZZXXZZ

A1-12345678-09LP

What I need to do is get to that middle number of 8, that won't change, unlike the text / numbers either of this field.

My question is how can I pull this out the 8 numbers, when the numbers / letters can change and vary in length.

Thanks All.

martinpohl — Wed, 27 May 2020 13:18:04 GMT

hi,

use

substring(yourfield,'-',2) as substring

regards

dinicholls — Wed, 27 May 2020 14:30:58 GMT

Hi,

What am I missing?! it doesn't like it!

substring([debtor_number],'-',2) as debtor_number,

Thanks

Di

vamsee — Wed, 27 May 2020 18:21:42 GMT

Use

SubField([debtor_number],'-',2) as debtor_number,