Forum Discussion
Solved
How to extract multiple dates from description?
I have description in column A like below screenshot. How can I extract dates from this strings like right portion?
Thanks for response. I have figured out it as
=LET(x,FILTERXML("<t><s>"&SUBSTITUTE(A2," ","</s><s>")&"</s></t>","//s"),TRANSPOSE(FILTER(x,ISNUMBER(x))))
4 Replies
Thanks for response. I have figured out it as
=LET(x,FILTERXML("<t><s>"&SUBSTITUTE(A2," ","</s><s>")&"</s></t>","//s"),TRANSPOSE(FILTER(x,ISNUMBER(x))))It could be modified as
=TRANSPOSE( FILTERXML("<t><s>"&SUBSTITUTE(A2," ","</s><s>")&"</s></t>","//s[translate(.,'1234567890','')!=.]") )but still depends on locale.
You can use a formula like this one:
=LET(words,TEXTSPLIT(A2," "),TEXTSPLIT(TEXTJOIN(",",TRUE,IFERROR(DATEVALUE(words),"")),","))That doesn't work with US format (11/01/2015) if we are in another locale.
