|I have an alias.txt file that looks like this
CHALET_HIST_ARCHIVE - zz** Chalet History Archive **zz
CHALET_Practice - CHALET Retail ***Practice***
CHALET - CHALET
CPPractice - ***NCR Practice***
LANDSCAPE_Practice - CHALET Landscape ***Practice***
LANDSCAPE - CHALET LANDSCAPE
THALMANN - Thalmann Farm
CpSystem - CPSQL System Database
The value to the left of the dash is the alias name. I need to return all alias names that do not contain PRACTICE, ARCHIVE, RESTORE, or CPSYSTEM (regardless of case).
In the list above, the only valid values returned would be THALMANN, CHALET, and LANDSCAPE. All the others should be ignored as containing one of the above words to eliminate the result.
No white space before or after the returned value.
Currently i am at:
Which accurately includes everything left of the dash, but does not eliminate the above results containing one of the four words.
modified 20-Dec-21 12:16pm.