Find and extract a substring from a string

[Little_Ghost]

I've been reading around and found all kinds of problems that where like the one I'm having, but none of the solutions worked for me.
I have a list with lines liek these:

****** name="email" content="dl-departmentmailbox">
<p><a href="mailto:dl-departmentmailbox">dl-departmentmailbox</a></p>
<li><a href="http://holidayplanner/cgi-bin/scheduele.pl?config=dl-all-deps">dl-all-deps</a></li>
<form name="PlanningRequest" method="post" enctype="text/plain" action="mailto:dl-planningrequest@mycompany.com?subject=Planning Request">

What I want/need to do is go through those strings and look for the part that starts with "dl-".
Then I need to copy/extract that + whatever is behind it.

I can't find a way to do it because the leading characters differ as do the ones at the back and the position and length of the string it need to find.

Is there an (easy) way to do this??

Kind regards

 

[Little_Ghost]

it works as long as the dl- part is not mentioned twice, like:

<p><a href="mailto:dl-department2">dl-department2</a></p> 
<li><a href="mailto:dl-all_departments@company.com">dl-all_departments@company.com</a></li>

Changed it.
it now read:

=MID(A2;SEARCH("dl-";A2;1);SEARCH(""">";A2;1)-SEARCH("dl-";A2;1))

This works on ALLMOST all of the entries... still trying to fine-tune.
Thanks for all the help and tips so far

 

[Little_Ghost]

I figured out why it still doesn't work on ALL entries:
Sometimes it will (for instance) encoutner the dl- at position 94 and encouter THE FIRST "> at position 55. This way, the "substraction" ends in a negative (because the ending character comes before the starting character).

 please contact <a href="mailto:person@company.com">Persons Name</a> or <a href="mailto:dl-department@company.com">dl-department@company.com</a>.</p>

Not sure how that could be solved though.

 

[NinadM]

If the end point has a numeric value ("dl-department1"> OR dl-department2">) as seen in both the examples provided you could try out the following:

The starting point begin the first instance for dl- and the end point being a numeric value

=MID(A1,SEARCH("dl-",A1,1),(MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))-SEARCH("dl-",A1,1)))

 

[NinadM]

Didn't view your last response before I responded. So the end point can vary as per the latest string example you provided

 

[István Hirsch]

it works as long as the dl- part is not mentioned twice, like:

[EMAIL="dl-department2"]dl-department2[/EMAIL]
 
[EMAIL="dl-all_departments@company.com"]dl-all_departments@company.com[/EMAIL]

Then which one do you want to be extracted?

 

[NinadM]

=MID(A2,SEARCH("dl-",A2,1),SEARCH(""">",A2,SEARCH("dl-",A2,1))-SEARCH("dl-",A2,1))

Hopefully this should work; tested on all the example strings provided.

 

[Little_Ghost]

=MID(A2,SEARCH("dl-",A2,1),SEARCH(""">",A2,SEARCH("dl-",A2,1))-SEARCH("dl-",A2,1))

Hopefully this should work; tested on all the example strings provided.

Only 1 or 2 left that are not working, but I'll just filter those out by hand.
Thanks!