Split column

[willy798]

Hi, I am new to MS Access and would like to know if it is possible to make a query that will split data from a column like this:



body - "<http://www.321.com/searchsale.321?id=679424> Region €172,000 - Apartment for sale, 2 Bedrooms, 2 Bathrooms"

into

several columns like this:

links -"<http://www.321.com/searchsale.321?id=679424>" region - "Region €172,000" type -"Apartment for sale" bedrooms - " 2 Bedrooms" bathrooms - "2 Bathrooms"

Any help would be much appreciated!

[orange]

It may be possible. Much of what you're asking is possible, IF
-the format of each record is identical.

You seem to be working with some existing html. Do you have the site link?
Or can you tell us more about the data involved?

[alansidman]

What you are looking to do is possible. It will take some query manipulation. Here is a link to a tutorial that will show you some concepts that I am sure you can modify to meet your needs.

http://www.datapigtechnologies.com/f...anipulate.html

Alan

[willy798]

Orange, I am getting the data through an RSS feed.
It is then being saved in MS Outlook. I then export the MS Outlooks RSS feed to MS Access. Thank you for the tutorial Alan.