Jay Killeen jaykilleen
jaykilleen
/ australian-postcodes.m
Last active
December 20, 2018 02:56
— forked from randomecho/australian-postcodes.sql
Australian postcodes (with states and suburb names) geocoded with latitude and longitude.
This file has been truncated, but you can view the full file.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Taken and cribbed from blog.datalicious.com/free-download-all-australian-postcodes-geocod | |
| May contain errors where latitude and longitude are off. Use at own non-validated risk. | |
| */ | |
| let | |
| Source = Table.FromList( | |
| { | |
| [ID="200",Name="Australian National University",State="ACT",Lat="-35.28",Long="149.12"], |
jaykilleen
/ Text.Count.m
Last active
May 10, 2016 03:12
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| (Haystack as text, Needle as text) as number => | |
| List.Count(Text.Split(Haystack, Needle)) - 1 |
jaykilleen
/ pquery.m
Created
May 10, 2016 03:25
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| (Haystack as text, Needle as text) as number => | |
| List.Count(Text.Split(Haystack, Needle)) - 1 | |
| (Rec as record, Lambda as function) as record => | |
| let | |
| Keys = Record.FieldNames(Rec), | |
| Values = Record.FieldValues(Rec), | |
| Renamed = List.Transform(Keys, each Lambda(_, Record.Field(Rec, _))), | |
| Recorded = Record.FromList(Values, Renamed), | |
| Return = Recorded |
OlderNewer