Forum Discussion
Get Data from Web From <div title=
Hello,
Can you please assist with get data form web for the following information. <div title=? e.g.
Desired text, refer # 1: Electrical installations - Connectable electrical installations and supply arrangements Part 1: Site supplies for connectable electrical installations, and
Not desired text, refer # 1: Electrical installations - Connectable electrical installati....
I unsuccessfully trialled using the CSS selector ".record-title + DIV", each [Attributes][title]” provided by a colleague, that fails apparently as the entry below, refer # 2, does not have a title, that stops all collection for the page.
I speculate that the following may be options, though I have been unable to progress, search: a “child” of a higher row, or provide “fault tolerance” for the ".record-title + DIV", each [Attributes][title]”.
An example of fault tolerance is return the text: “error/nil etc”, or adjacent text etc.
I have limited experience with: CSS selectors, and/or Power Query; though I have unsuccessfully trialled various guesses of random CSS selectors etc, including according to: previous responses on this forum, and general searches of the internet etc.
Thanks and regards.
Hello, I found the following "error handling" by inserting "?" that relatively resolved my enquiry. Regards. https://community.fabric.microsoft.com/t5/Power-Query/quot-quot-in-M-syntax/td-p/901748
3 Replies
Hello settingsaver - It's hard to provide a specific solution without the site you are scraping, but here is an example of text from nested child items. It sounds like you are needing to include some custom logic to evaluate whether or not an element exists as well. Can you please share the site you are trying to scrape?
Hello,
Thank you for the assistance.
The website follows:
Regards.
Hello, I found the following "error handling" by inserting "?" that relatively resolved my enquiry. Regards. https://community.fabric.microsoft.com/t5/Power-Query/quot-quot-in-M-syntax/td-p/901748
