How to remove the required data from one field?

[rkpatelqlikview]

For Example

FieldName

This is Dallas - (200)

This is Dallas -(202)

This is Plano 203

I need to remove "This is " and "- (200)" , "(202)" and combine those two Dallas data into one.

Only That City names should be appear. Which function can i use in Qlikview?

Thanks  in advance.

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .