Hi,
I have the following entries in my column:
Full Description
Abelcet vial 5mg/ml 20ml 10 pack
Abilify dispersible tablet 10mg 28 pack
Abilify dispersible tablet 15mg 28 pack
Abilify oral solution 1mg/ml 150ml
Abilify solution for injection 7.5mg/ml 1.3ml
Abilify tablets 10mg 28 pack
Abilify tablets 15mg 28 pack
Abilify tablets 30mg 28 pack
Abilify tablets 5mg 28 pack
Accolate tablets 20mg 56 pack
Accupro tablets 10mg 28 pack
Accupro tablets 20mg 28 pack
Accupro tablets 40mg 28 pack
Accupro tablets 5mg 28 pack
Accuretic tablets 28 pack
I want to use expression builder to remove anything that has "[number] pack". i.e convert Accuretic tablets 28 pack to Accuretic tablets but leave Abilify solution for injection 7.5mg/ml 1.3ml as is.
I have been trying string functions to do this all afternoon but somehow I just can't get it to work.
Your help would be much appreciated.
Kind regards,
Shaheed Fazal