RegEx Tokenize question

adam_jones

I have a project with multiple rooms that each have their *name* followed up by Temperature or Humidity or Room Pressure.

I need to create a new column that only has the room name and drops the Temperature so that I can group these by the actual room name and not include the temperature, humidity, or room pressure.

For Example - 

Sterile Storage Temperature

Sterile Storage Humidity

OR - 5 Temperature

OR - 5 Humidty

OR - 7 Temperature

OR - 7 Room Pressure

Needs to drop the last word but create a new column for a "Parent Column"

I have RegEx but not sure how to express only those words are to be dropped and create new column with just room name. 

Luke_C

Hi @adam_jones 

I would use regular formulas or other tools, here's two examples:

1. Formula tool to find the location of the last word and take everything to the left
2. Find and replace on these 3 key words, wouldn't account for if they occur regularly in the rest of the field though.

New Workflow4.yxmd