Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
извлечение плохоструктурированных данных
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