Extract each occurrence of a string into a separate line to build a list of URLs

Started by: Simon McMahon2 voices4 posts

Tagged: find in files

Hi there, I would like to extract all occurrences of a URL string pattern (which can appear multiple times in a file) to build a list of all occurrences. Currently I can identify each occurrence with the Find in files feature, but I would like the Extract feature to list each occurrence on a new line. Currently the feature lists each line that contains the string. And a line can contain the sting multiple times. My goal is to get a list of the full URL that contains __data/assets/ In the below example __data/assets/ occurs 48 times. However, the extract only 44 lines are extracted, but I need to output all 48 occurrences (the full URL). I will be running this extract over 270 files in total. View source of this example webpage: https://www.walkerville.sa.gov.au/council/strategic-plans/2020-2024-living-in-the-town-of-walkerville-a-strategic-community-plan
Partial answer You probably cannot do it in one step, but you would* be able do this in two: First extract and then Find -> Extract with the following Regex* /https:\/\/.*__data\/assets.*(?=")/gU *there is a problem here: The syntax above is not perl compatible Does somebody know how to apply the /gU regex flag? Would really appreciate this
Figured it out: First extract the lines via find in file Then Find → Extract with Regex: (?<=")[^"]*__data\/assets.*?(?=") 🙂
Arghh, stupid me You can do this in one step Find in files → Extract with Regex: (?<=")[^"]*__data\/assets.*?(?=") With the extract option display matched strings only 😴

4 posts in this topic