Hello everyone,
I'm trying to make a clear table with error codes. The error codes are in a string of text. I manage to filter out the error code and only display that code, but sometimes there are several error codes in one string. At the moment that string is only displayed for the error code I mentioned first in my query.
How can I display this string with all the error codes it contains?
To clarify, here's an example of one string:
String
emergency stop E001, E206 detection failed, not enough pressure E080.
I tried to make a query with Pick an Wildmatch.
PICK(WILDMATCH([Field], '*E001*', '*E002*', etc.), 'E001', 'E002', etc.)
This works reasonably well, but only for strings with only 1 error code. In the example above, the output is as follows:
E001 emergency stop E001, E206 detection failed, not enough pressure E080.
But I want this output:
E001 emergency stop E001, E206 detection failed, not enough pressure E080.
E206 emergency stop E001, E206 detection failed, not enough pressure E080.
E080 emergency stop E001, E206 detection failed, not enough pressure E080.
How can I solve this? Can someone help me?