Home › Forums › Advanced usage › get URL's only posted by user
This topic contains 3 replies, has 2 voices, and was last updated by mhawksey 5 years, 11 months ago.
Is there anyway i can extract the URL’s posted by the user in a seperate column?. Need urgent help. Thanks
the entities_str column in the archive will contain the data. You could probably extract the 1st url with formula =REGEXEXTRACT(Q2,"expanded_url.:.(http.*?).,") … or write custom function
thanks but i wanted to extract exact URL’s like http://xyz.com which i could not with the function that you gave.
See cell R2 https://docs.google.com/spreadsheets/d/1erHI-T3wCdKAkq_Tl5HoJ2SS1JNiDRA4ihldS1FoWK8/edit#gid=400689247
You must be logged in to reply to this topic.