Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-26-2021, 03:10 PM
Belle Belle is offline extract text from website / html - anyone? Windows 8 extract text from website / html - anyone? Office 2007
Novice
extract text from website / html - anyone?
 
Join Date: Oct 2021
Posts: 2
Belle is on a distinguished road
Default extract text from website / html - anyone?

Hi there! For weeks I've been trying to solve this problem and I already sought for help on other forums. Unfortunately, nobody was able to help me.


I have a very long list of words, several thousand words that I collected over time. I'd like to create a personal dictionary. (Only for personal use)

My plan is to import the meanings from a specific website (Duden | Sprache sagt alles.) into Excel. Duden is a dictionary of the german language and their website is well organized. The names of the links are very predictable.

For instance the adress for "Unboxing" is "https://www.duden.de/rechtschreibung/Unboxing"

(Note: There are a lot of english words as well in the dictionary and "Rechtschreibung" means orthography)

Now, I'm lucky to have ALL the links. (I simply generated them by automatically combining the first part "https://www.duden.de/rechtschreibung/" with each word (for ex. "Unboxing")
This means that I got all the sources for the imports. These links are meant to be integrated into the formula that is supposed to extract the text beneath the subtitle "Bedeutung" (meaning) that you can find on each of those websites.

Because of the vast amount of words it needs to be a formula that I can apply for all words (in some sort of order to not over-strain my pc, excel, the connection.... the conventional way to import data from an external source won't work here.

I tried to modify formulas that I found on the web

=import(website;html string) (or something like that)

but because of my lack of knowledge when it comes to html I did not get anywhere.

I give up. Can anyone please help me?

Last edited by Belle; 10-27-2021 at 04:47 AM.
Reply With Quote
Reply

Tags
dictionary, html, import

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract data from HTML File. donlincolnmsof Word VBA 5 08-26-2019 08:36 PM
Extract data from HTML File. donlincolnmsof Word VBA 0 03-07-2019 12:17 PM
extract text from website / html - anyone? How to extract text between <> LearnerExcel Excel 4 02-07-2018 06:11 AM
Formula to Extract text from a text string Haha88 Excel 2 11-14-2017 01:32 AM
extract text with formula s7y Excel 7 06-05-2013 06:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft