Hi guys

First thread on EF... I've been browsing for a while.

I have a list where the zip code (4 digits) is within the adress coloumn. I would like it to be in seperate columns:

Now it's like this:
Company name; Adress
Output: Blueblau; Vardegade 23 5. 2100 Copenhagen East

I would like it to be:
Company name; Adress; Zip code; City
Output: Blueblau; Vardegade 23 5.; 2100; Copenhagen East

How can I do this??

Thank you in advance...