Hi all,

I have some addresses separated by ";" in the following format:

“ Univ London Imperial Coll Sci Technol & Med, Fujitsu Parallel Comp Res Ctr, London SW7 2BZ, England; Coventry Univ, Sch Math & Informat Sci, Coventry CV1 5FB, W Midlands, England; City Univ Hong Kong, Dept Mfg Engn & Engn, Kowloon, Peoples R China”

How can I extract the address only in People R China, that is "City Univ Hong Kong, Dept Mfg Engn & Engn, Kowloon, Peoples R China"?

Of course, the string with "People R China" could appear in the first string, in the middle, and in the last.

Many thanks!