Select Specific Strings & String Format

johnca — Mon, 05 Oct 2015 16:27:47 GMT

I need to select lines where there are specific strings contained somewhere in the field. The format of the string desired is 'nnnn-nnnnn' where n = a number 0-9 (no vowels or special characters), so they would look like this; 2015-70707. My problem is there are examples where the string I want is there but does not follow the format exactly. Sometimes there may be a space on one side of the hyphen or not, or more than one example in each line. The result desired would be the string 'nnnn-nnnnn'. Here are examples of what I need to include and not include in my query;

Any ideas on how to maximize my selections?

Value	Include	Result
6.23.2015-429226	no	<not included>
521 / 2015-88584	yes	2015-88584
2015- 80808	yes	2015-80808
2015-60776	yes	2015-60776
2015-66208	yes	2015-66208
2015-71757 & 2015-71726	both	2015-71757
2015-71757 & 2015-71726	both	2015-71726
2015-72052 PO BL060315	yes	2015-72052
711717 - PROJ040805	no	<not included>
711733 2015-74104	yes	2015-74104
BL5928 2015-78037	yes	2015-78037
cG75382-WP / 2015-72069	yes	2015-72069
GRS515 / 2015-88522 / 2015-87229	both	2015-87229
INC13778737 / 2015-89742	yes	2015-89742
LOST UNIT REPLACEMENT- 109325	no	<not included>
LOST UNIT REPLACEMENT-100016	no	<not included>
Quote 2015-66816	yes	2015-66816

Re: Select Specific Strings & String Format

cwolf — Tue, 06 Oct 2015 16:41:41 GMT

Hi John,

I hope that help.

Regards

Christian

Re: Select Specific Strings & String Format

johnca — Tue, 06 Oct 2015 18:25:20 GMT

Hi Christian, considering that I am going to be using this in a subsequent "Where Exists" clause it works perfectly for my needs. Thank you very much!

(This was inadvertenly addressed to Joe. My apologies to Christian)

topic Re: Select Specific Strings & String Format in QlikView

Select Specific Strings & String Format

Re: Select Specific Strings & String Format

Re: Select Specific Strings & String Format