Power Query: Identify & Retrieve Partial Strings of Text

1 Просмотры
Издатель
It's one thing to identify if a partial strong of text exists in a cell. It's another to identify it and also dig it out. That's the challenge in this video.
1. Identify if an address contains SW, South West, NE or Northeast.
2. If one of those is found, populate what was found in the cell next to the address.

This requires thinking really slowly and planning.
The first step in this video is a cross-join. Along the way, we use a left outer join and the Power Query command: Text.Contains

It's all here!

Download the file: https://datascopic.net/IDTXT

#PowerQuery
#Text.Contains
#PartialTextString

For a list of my Excel courses at Lynda/LinkedIn:

https://www.linkedin.com/learning/instructors/oz-du-soleil

There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: http://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336

My old blog: http://datascopic.net/blog-2-2
Категория
Язык программирования Swift
Комментариев нет.