Forum Discussion

4 Replies

    • j_martinho's avatar
      j_martinho
      Helper I
      6 years ago

      Tkz!

      Using:

       

      Mat1 = Mid('Termo de Recebimento de Material'[Material]; 1; SEARCH(UNICHAR(10);'Termo de Recebimento de Material'[Material];1))
       
      In PowerQuery Transform, how I can find UNICHAR(10)?
      • j_martinho's avatar
        j_martinho
        Helper I
        6 years ago

        Solution!!

         

        Text.AfterDelimiter([Material], Character.FromNumber(10))

  • StephenK's avatar
    StephenK
    Resolver I
    6 years ago

    In Power Query under the Transform Tab:

     

    - Split Column

       - By Number of Characters

     

    Number of Characters = 10

     

    Split = Once, as far left as possible