Help with manipulating some strings

Question

My strings are of this kind: City (PR) from a Database, where PR stands for Province.

At the end I want two separate variables. City and PR.

I have to do this with C#. Any idea? Thanks.

Answer 1

Assuming cities don't contain ( characters:

string s = "City (PR)";
int p = s.LastIndexOf("(");

string city = s.Substring(0, p).Trim();
string province = s.Substring(p + 1, s.Length - p - 2).Trim();

city is the substring from the first character up to but not including the last ( character.
province is the substring from the first character after the last ( to the end excluding the last character.