Regex expression matching exact keywords anywhere in a file name

Asked Jun 29 '20 at 15:57

Active Jun 29 '20 at 16:13

Viewed 29 times

How would You negate the following expression? ^(.(?<!_all_|_team_))*?$

I am interested in only those files that contain exactly these expressions with underscore anywhere in the file name. I do not have trouble returning only those that do not contain exactly these.

Unfortunately ^(.(?<=_all_|_team_))*?$ does not work. I need to tackle an ETL step in the PDI - Data Integration tool.

The alphabetic bits of these two expressions do not have to be case-sensitive.

edited Jun 29 '20 at 16:13

asked Jun 29 '20 at 15:57

Richard

Can you give an example where it should match and where it should not? – lightBullet Jun 29 '20 at 16:04
For example: DailySales_CompanyName_team_20200629.xlsx, DailySales_CompanyName_all_20200629.xlsx - the two keywords do not have to be case-sensitive – Richard Jun 29 '20 at 16:09
.*(?<=_all_|_team_).* this work? – lightBullet Jun 29 '20 at 16:14
Just `_all_|_team_` or `_(?:all|team)_` – Wiktor Stribiżew Jun 29 '20 at 16:15
@Wiktor Stribiżew - none of these match the entire file name. – Richard Jun 29 '20 at 19:08
Sure, if you need to match it all, add `.*` on both ends, `.*_(?:all|team)_.*` – Wiktor Stribiżew Jun 29 '20 at 19:10
@Wiktor Stribiżew - thank You. It has resolved my problem. – Richard Jun 30 '20 at 07:55

Regex expression matching exact keywords anywhere in a file name

0 Answers0