Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
8 years ago

Split Text Up and Down

 

HI , i have no clue how to split the First Text in 1 column and Second Text in another column 

for ex : 1 Column : Khan Daun Penh 12200 

            Another Column : Psar Tmei 3 12210 

 

I tried all of split options , but doesn't work. 

Data Modeling

6 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi Chanleakna123,

     

    You can use Split Column by Delimiter feature with line break #(lf). You can test with below Power Query: 

     

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8s5IzFNwSSzNUwhIzctQMDQyMjBQiMkLKE4sUgjJTc1UMAaJGRooxepAFTtnJOZmJxbl5hflAaWMDQxi8kLyS3MUgssSKxUCilIrDcHCFkqxsQA=", 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}}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Column1", Splitter.SplitTextByDelimiter("#(lf)", QuoteStyle.Csv), {"Column1.1", "Column1.2"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Column1.1", type text}, {"Column1.2", type text}})
in
    #"Changed Type1"

     

     

    Reference:

    https://www.excelguru.ca/blog/2015/10/16/split-by-line-breaks/

     

    Best Regards,
    Qiuyun Yu 

    • Chanleakna123's avatar
      Chanleakna123
      Post Prodigy
      8 years ago

       

      See the 3 pictures i shared , 

      and the other one with the table of the line up and down. 

       

      i failed to success your. 

      can you please advise more. 

      v-qiuyu-msft