Power Query - Extracting Patterns - Dates & Hash Tags 🦖🦩

Part 2 of Pattern Extraction in Power Query in this video i show how you can extract Hashtags and dates from a dataset.
#datavalidation #dataanalysis #powerbi #powerquery #excel #mquery
File
github.com/jbo...
Query Website
powerquery.how/
PowerQuery Book
www.amazon.com...
Noteworthy techniques
Nested Lets
Culture Datetime
text.combine
powerquery.how...
list.select
powerquery.how...
text.split
powerquery.how...
list.distinct
powerquery.how...

[@kebincui]

Excellent as always 👍. Thanks James

[@juansepowerplatform]

amazing videos. thanks for your hard work in putting these together

[@qasimawan3568]

Great video! Thank you for the tutorial!

[@raimundojs9547]

Excellent!

[@mnowako]

Amazing. Thanks a lot!

[@masgitz]

Are square brackets the same as nested let?

[@jerrydellasala7643]

The file link is the same file as your last video, and the Table1 table has NO #'s in the "Pattern Sentence" column.
Also, not all of the dates looked like dates. Some used /, others used - as a separator.

[@basensei8699]

Hey Jerry! damn wrong file ! i updated it now thanks for letting me know!
yes the dates i deliberately made / and - to show that one can pick up both formats with the culture.
Those were all dates in format dd/mm/yyyy or dd-mm-yyyy which is the UK Culture setting.

[@cathrerinezetadrones3169]

🤌🏾