Address field on multiple lines

#1

HI, I have an address field which is showing as being on multiple lines on the site but I am not able to select individual lines. When I scrape the site I'm getting the address as one field. I'd like to split it down to Address 1, Address 2, Postcode. If I try and bring into excel there is no logic I can use to split the address. It looks like I can't individually click on the lines when using web scraper. Appologies but I'm a novice at this and just trying to learn.

#2

@dkbolduk Hello. Could you, please, share your sitemap or the targeted website?

#3

Hi, thanks for the reply, this is the targeted page

https://www.dhfonline.org.uk/search-result.htm?m_product_group=5&m_product_area=&m_service_id=&m_postcode=Postcode+(optional)&Button=Search

it's the address on the right hand side. I wanted to split each line into a column.

#4

@dkbolduk Hello, it appears that this data is divided into paragraphs, however, unfortunately, due to the structure of this website, there does not seem to be a viable way to split this data into separate columns by the address and postcode.

example
example1331×1254 115 KB

1 Like
#5

Thank you for looking into this for me. I have now managed to split it out in excel. It's not perfect but it's nearly there. I have split the field out by the line breaks. I'm assuming there is no way do do that with the webscraper tool?

#6

@dkbolduk No, unfortunately, it is not possible to divide this data by the
tag - breaks.