Search for ONE value and replace

[Anonymous]

Hi, 
I am new to the community, and I really hope you can help me.

I have a column with various organizational units, 15 different units, +8 specific unites per unit and over 1300 people belonging in those specific units. 

- ET/UTJ/BMM/TK-TUT/ASSET/T&P/B&J

- ET/UTJ/BMM/TK-TUT/ASSET/T&P/ESNR/BATH

- ET/UTJ/BMM/TK-TUT/ASSET/T&P/WINT

- ET/UTJ/BMM/TK-TUT/ASSET/T&P/E&O/D&WO

The only thing I then want to remain is T&P, so that everything else goes. I already tried to filter the column for all T&P and then extract everything before and after, so that only T&P remains. It works fine, but T&P is only one of 15+ org units and when I do this it seems like I lose all other data in the table except for the one belonging to T&P.

[DataVitalizer]

Hi @Anonymous ,

If you filter data with T&P it's obvious that other units will not show up, could you please clarify the need.