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

6 Replies

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    3 years ago

    post some lines to help you. Can't copy text from image

    • prpaz's avatar
      prpaz
      Regular Visitor
      3 years ago

      Thanks for the contribution. Could you be more specific? Is the image not complete? grateful

      • Ahmedx's avatar
        Ahmedx
        Icon for Super User rankSuper User
        3 years ago

        just give an excel file with a few lines words

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper 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"