🏯 Tweet Scraper V2 (Pay Per Result) - X / Twitter Scraper
Pay $0.40 for 1,000 tweets
🏯 Tweet Scraper V2 (Pay Per Result) - X / Twitter Scraper
Pay $0.40 for 1,000 tweets
⚡️ Lightning-fast search, URL, list, and profile scraping, with customizable filters. At $0.30 per 1000 tweets, and 30-80 tweets per second, it is ideal for researchers, entrepreneurs, and businesses! Get comprehensive insights from Twitter (X) now!
Hi,
I am trying to parse the date in Excel but when I try to use DATEVALUE() in Excel on the string 'Wed Nov 21' it fails. I use other scrapers on this site that don't have this issue, for example the APIFY Instagram scrapers produce valid UTC strings where the date is of the form '2024-11-21' which Excel can parse with DATEVALUE(). I am working with students who can't code and need to process the data in Excel. Can you advise please.
EDIT: run number is 61RPP7dywgiy0JPD0 Thanks,
Andy
Hello Andy,
Can you please double check the run ID? I cannot access it https://console.apify.com/view/runs/61RPP7dywgiy0JPD0
Cheers
https://console.apify.com/actors/61RPP7dywgiy0JPD0/input
Also I I rearranged the string so Excel is happy with it using DATEVALUE(CONCAT(MID(G5,9,2)," ",MID(G5,5,3)," ",RIGHT(G5,4))) but it would be a lot easier for my students/me if the date formats were consistent across actors.
Thanks
Andy
Hello,
That is not the ID of the run, it is the ID of the actor. Can you please send us the run ID? You can find it under run details page.
Cheers
Hello,
Now I got the issue. Unfortunately that is how Twitter returns the date information and our actor provides raw data so there is nothing much to do on our end. But I'm glad you already figured out a workaround!
Let me know if you have more questions.
Cheers
thanks, I do some have another question but not about dates so I'll raise another ticket
Actor Metrics
1.6k monthly users
-
306 stars
99% runs succeeded
4.3 hours response time
Created in Nov 2023
Modified 18 hours ago