Extract substring from text string folllowing keyword - formula required

[steallan]

Hi - hoping some expert can help me with a text search query

I've got a column full of text entries. What I would like to do is extract x number of characters after certain keywords.

So for example.

keyword 'DOB: ' then bring back the next 10 characters

So if the below is the text in cell AP2 -

"blah blah blah DOB: 1982-11-32 Name: Sir Billy Weesle Major turn ons: women dressed as Rabbits, GoT blah blah blah"

- I am after a formula I can put in another cell that would find 'DOB: ' and then return the next 10 characters, so i'd get back 1982-11-32

Some formula that works I can then use in other cells to find other keywords and return other values.

Any help would be greatly appreciated.

Thanks

Ste

 

[Fluff]

How about
=MID(A2,SEARCH("dob:",A2)+5,10)

 

[sandy666]

with PowerQuery (Get&Transform)

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]raw[/td][td][/td][td=bgcolor:#70AD47]raw[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]blah blah blah DOB: 1982-11-32 Name: Sir Billy Weesle Major turn ons: women dressed as Rabbits, GoT blah blah blah[/td][td][/td][td=bgcolor:#E2EFDA]1982-11-32[/td][/tr]
[/table]

[SIZE=1]// Table23
let
    Source = Excel.CurrentWorkbook(){[Name="Table23"]}[Content],
    ExtractAfter = Table.TransformColumns(Source, {{"raw", each Text.AfterDelimiter(_, "DOB: "), type text}}),
    Extract10 = Table.TransformColumns(ExtractAfter, {{"raw", each Text.Start(_, 10), type text}})
in
    Extract10[/SIZE]

 

[steallan]

Yep that works, and I even understand it, which is double good.

Thank you good Sir. You are a star.

 

[steallan]

Thanks also Sandy666 I shall look at your solution as well, also will probably teach me something,

xx

 

[sandy666]

you are welcome

Have a nice day

 

[Fluff]

Yep that works, and I even understand it, which is double good.

Thank you good Sir. You are a star.

You're welcome & thanks for the feedback