Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi John,
I hope that help.
Regards
Christian
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)