Created
November 19, 2018 15:59
-
-
Save maxim-uvarov/666fc5c10eaa68f556123f401cf452d6 to your computer and use it in GitHub Desktop.
извлечение плохоструктурированных данных
This file contains hidden or 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
let | |
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("NYsxCoAgFECvIk461IXEu1QQLZ2gzYZmCQSj8gzv3ygd2h6P95zT7BROogyGreJNloUko0xVFyWz4iDxElWnCFUXMg+lJbJaQ2gh17/YXnv/AQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]), | |
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}), | |
#"Inserted Text Before Delimiter" = Table.AddColumn(#"Changed Type", "Товар", each Text.BeforeDelimiter([Column1], "("), type text), | |
#"Inserted Text Between Delimiters" = Table.AddColumn(#"Inserted Text Before Delimiter", "Количество", each Text.BetweenDelimiters([Column1], "(", "х"), type text), | |
#"Inserted Text Between Delimiters1" = Table.AddColumn(#"Inserted Text Between Delimiters", "Цена", each Text.BetweenDelimiters([Column1], "х", "-"), type text), | |
#"Inserted Text Between Delimiters2" = Table.AddColumn(#"Inserted Text Between Delimiters1", "Стоимость", each Text.BetweenDelimiters([Column1], "-", ")"), type text), | |
#"Inserted Text Between Delimiters3" = Table.AddColumn(#"Inserted Text Between Delimiters2", "Свойство", each Text.BetweenDelimiters([Column1], "(", ")", 1, 0), type text) | |
in | |
#"Inserted Text Between Delimiters3" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment