Skip to content

Instantly share code, notes, and snippets.

@maxim-uvarov
Created November 19, 2018 15:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save maxim-uvarov/666fc5c10eaa68f556123f401cf452d6 to your computer and use it in GitHub Desktop.
Save maxim-uvarov/666fc5c10eaa68f556123f401cf452d6 to your computer and use it in GitHub Desktop.
извлечение плохоструктурированных данных
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