I have a column with data like these samples:
Tropical Gastroenterology: Official Journal of the Digestive Diseases Foundation ---Charaka Publishing HouseDepartment of Surgery, Jawaharlal Institute of Postgraduate Medical Education and Research, Pondicherry, India
Japanese Journal of Medical Science & Biology ---National Institute of Infectious Diseases, JapaneseDepartment of Experimental Medicine, Postgraduate Institute of Medical Education and Research, Chandigarh, India
Journal of Ethnopharmacology ---ElsevierPharmacology and Toxicology Section, Research Centre, Hindustan Antibiotics Limited, Pimpri, Pune-411 018, India
2001 IEEE Aerospace Conference Proceeding ---IEEE: Institute of Electrical and Electronics EngineersSIGCOM Co. HQ, Ghaziabad, India
The pattern here is that the "publishing houses" start with --- and then followed by "Department/Section/Division" of an "institute". There is no punctuation/indication of a start point of the institutional element after the publisher/publishing house.
Could you plz help me to separate it into two columns - column 1: Publication ---Publisher and column2: Department/Section/Division, Institue by applying suitable regular expression?
Powered by IDERA