Skip to content

Instantly share code, notes, and snippets.

@ImkeF

ImkeF/TextTrimEndOptional_query.pq

Created March 20, 2020 07:37
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 ImkeF/94b0f95ace70dca4f408f0c54db370da to your computer and use it in GitHub Desktop.
Save ImkeF/94b0f95ace70dca4f408f0c54db370da to your computer and use it in GitHub Desktop.
Download ZIP
Raw
TextTrimEndOptional_query.pq
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcvL389AN0PXVNTRTitWJVnJ29NN18tF1NDQHc8GEhYVukK6js66hpVJsLAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [product_name = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"product_name", type text}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Text.TrimEnd([product_name], {"0".."9"} & {"-"}))
in
#"Added Custom"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment