I have pasted the image for the query in which i want that,
If the data in the column “A” contains the any of strings available in the column “B”, then the matching string (maximum part of it) should be removed and the resultant part should be left in column “D”.
List of input URLs in text :
List of strings to be removed:
Result Needed for each URL: