Forum Discussion

prpaz's avatar
prpaz
Regular Visitor
3 years ago

extract numerical sequence in form

Hello friends. I need help with this challenge. I'm having trouble thinking of a solution. I need to extract from this column a certain sequence of numbers, example:  
Need Help
Show and Tell
Ahmedx's avatar
Ahmedx
Super User
3 years ago

pls try this

 

Text.BeforeDelimiter(
Text.BetweenDelimiters(
     [input], """:"" -","//"),"-")
let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("7VSxboMwFPwVRNeE2AZj3K2VMjYdki1ElrFNYyXBqW3Soeq/1zWBpZ8QGBC6u3c6PU5vv0+/6/SoparT5zr1tg8fizp1R2M9k8oJq69emy7SHCZeOT8olL1pMYyVtK0w4lI2sAjvAjouuYANhrCgJaRwMO2ZVWfulWSeu5OLo5Gw6rMPvoFojQ2ii7nxc6RBDjAQNIeNQFJAQB1HmOQVIaDFRSMa2t6tJfeciTN3Trda8Cmz7ryyHfsy9hTMxZAkqPrOGwZA1CTLBOcYZxDlBS5JhmCGAoaGJ1mtksCQihYljuPDXqZxmsEMlmFgBKKImauyMccIb9/Qy2vkPqzpryO8W29375v1EMyjEeb/1uz15R5/ctw+LXMQsauZ8lSUUBpB49jfSvmF6S44aRmAjjM3KjemTn/Sw2JuwdACRCuSgakGYK7BQ9ZgPgZzC0ILChL+Pq5IAcNRwHMLHrIFJajAw96Cwy8=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [input = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"input", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Text.BeforeDelimiter(
Text.BetweenDelimiters(
     [input], """:"" -","//"),"-"))
in
    #"Added Custom"