Extracting Specific Text in String

%3CLINGO-SUB%20id%3D%22lingo-sub-2355430%22%20slang%3D%22en-US%22%3EExtracting%20Specific%20Text%20in%20String%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2355430%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20attached%203%20instances%20of%20a%20link%20below%3A%3C%2FP%3E%3CP%3EWhat%20I%20would%20like%20to%20do%20is%20to%20be%20able%20to%20extract%20the%2016%20digit%20number%20after%20%22posts%2F%22%20for%20each%20of%20the%20links.%20That%20is%20all.%3CBR%20%2F%3EI%20have%20randomized%20the%20numbers%20within%20the%20links%20for%20confidentiality%20purposes%20and%20they%20will%20lead%20to%20broken%20pages.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CTABLE%20width%3D%221046%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%221046%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.facebook.com%2F319331008154444%2Fposts%2F3949634461790232%2F%3Fcomment_id%3D3972705792816315%26amp%3Breply_comment_id%3D3982045875215324%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.facebook.com%2F319331008154444%2Fposts%2F3949634461790232%2F%3Fcomment_id%3D3972705792816315%26amp%3Breply_comment_id%3D3982045875215324%3C%2FA%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CTABLE%20width%3D%221046%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%221046%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.facebook.com%2F110674865650231%2Fposts%2F4125373270847756%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.facebook.com%2F110674865650231%2Fposts%2F4125373270847756%2F%3C%2FA%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CTABLE%20width%3D%221046%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%221046%22%3E%3CP%20data-unlink%3D%22true%22%3Ehttps%3A%2F%2Fwww.facebook.com%2F319331008154720%2Fposts%2F3984168261670572%2F%3Fcomment_id%3D3984819191605454%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2355430%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I have attached 3 instances of a link below:

What I would like to do is to be able to extract the 16 digit number after "posts/" for each of the links. That is all.
I have randomized the numbers within the links for confidentiality purposes and they will lead to broken pages.

 

Thank you!

https://www.facebook.com/319331008154444/posts/3949634461790232/?comment_id=3972705792816315&reply_c...
https://www.facebook.com/110674865650231/posts/4125373270847756/

https://www.facebook.com/319331008154720/posts/3984168261670572/?comment_id=3984819191605454 

 

2 Replies

@fcbda 

With a string in A1, enter the following formula in for example B1:

 

=MID(A1,FIND("posts/",A1)+6,FIND("/",A1,FIND("posts/",A1)+6)-FIND("posts/",A1)-6)

 

This can be filled down.

@fcbda 

If these are 16 digits numbers I'd simplify a bit

=MID(B3,FIND("posts/",B3)+6,16)