Good idea, El - thanks.

The link is https://docs.google.com/document/d/1QwuaWZk6tYlWQXJ3WLczxC8Cda6zVERk/edit?usp=sharing&ouid=103065135255080058813&rtpof=true&sd=true

This is helpful.

From the article, which is typical of Lexis+ output, I want to extract the following fields and append to a Calc/ Excel spreadsheet. Given the volume of articles I have to work through, if this can be iterative and semi-automatic, that would be a god send and I might be able to do some actual research on the articles before I reach my pensionable age. :-)

Title
Newspaper
Date
Section and page number
Length
Byline
Subject (only if the threshold of coverage for a specific subject is >=50% is reached (e.g. Greenwashing (51%)) - if not, enter 'nil' and move onto the next article in the folder

This is the ambition. I am clearly a long way short of that though.

Many thanks.
Andy


On 30/12/2023 00:08, Dr Eberhard W Lisse wrote:
Andy,

you can always open a public Dropbox or Google folder and post the link.

el

On 29/12/2023 22:37, Andy wrote:
Thanks - I'll have a look at these options too.

I'm happy to send over a sample document, but wasn't aware if
attachments are allowed. The documents come Lexis+, so require user
  credentials to log in, but I could upload the file somewhere if
that would help? Any ideas for a good location to do so?
[...]

______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Reply via email to