topic Re: Index of string '* ??-??? *' in QlikView

Index of string '* ??-??? *'

Fri, 20 Jun 2014 16:27:13 GMT

Hi there,

I need to find an index of string '* ??-??? *' where question mark is a single digit and a star is any number of characters. 2nd and 3rd digits are seperated by a dash and there are spaces before 1st anf after 5th digit.

Example

String: Berliner Str. 154 20-254 Chemnitz

Substring: 20-254

Result: 27

So far I used MapSubString replacing ??-??? with a special character and found the index but it happened that ??-??? appeared in another part of a string (e.g. String: Berliner Str. 146-148 20-254 Chemnitz; Substring: 46-148) and MapSubString won't work here as it can't cope with surrounding spaces (when mapping ' 46-148 ' MapSubString will actually map '46-148'). Any idea how to get that index?

Regards,

Przemek

Re: Index of string '* ??-??? *'

swuehl — Fri, 20 Jun 2014 21:43:36 GMT

Przemek, could you post your current script snippet?

Re: Index of string '* ??-??? *'

nagaiank — Sat, 21 Jun 2014 01:58:08 GMT

You may replace each digit with 'n' and then locate 'nn-nnn' using index() function

Re: Index of string '* ??-??? *'

Sat, 21 Jun 2014 07:38:23 GMT

I can't due to the problem described in the above example.

Re: Index of string '* ??-??? *'

Sat, 21 Jun 2014 07:41:13 GMT

I found a workaround - when loading data from a file instead of inline QV recognises surrounding spaces so I moved all MapSubString data to a file.